locked
which approach will help me speed up my web app? RRS feed

  • Question

  • Hi,

    I have a website,which has 20 web forms that all of them contain cascading drop down list.We have used Json for cascading mechanism.At the server side we have a DAL class that have methods for filling the cascading drop down lists.all the methods at our first try use to grab the data from SQL SERVER and fill the appropriate drop down lists.You should be aware that all the methods grab info from SQL server from a single table.(We have written 4 stored procedures for that)

    Because the clients of our website have different internet connection speed varying 56K to ADSL,the clients which have dial up connections complaint that the contents of webpages(which contain cascading drop down lists) loads slowly.

    I came to a solution(which i don't know is it good or bad?!):

    I use an Application Object of asp.net and at the home page i fill it with DATA TABLE object which has that table data(in sql) in it.and in DAL instead of grabbing data from SQL SERVER,this time i grab the whole DataTable from Application object and search my condition through it with the help of "for" statement.

    Do you think this is a good idea?Will it help in speeding up my website.?

    Thanks in advance 

     

     


    Brainstorm your Brain and find solution,if no result stuck to Brainstormer.
    Thursday, March 31, 2011 6:51 AM

All replies

  • Do you use the entire datatable or some portion of it per user?

    Because you'd do a lot better with multiple keyed caches if the latter.

    In either case store what you will serve as an object in application / cache so you save the iteration and formatting.

    If this is fairly static data you can get it to cache locally on the client and at least the 56k modem users only download it once.

    Thursday, March 31, 2011 7:14 AM
  • thanks Andy,

    Do you use the entire datatable or some portion of it per user?

    the entire dataTable.


    Would you please let me know how can i cache locally on the client?

     


    Brainstorm your Brain and find solution,if no result stuck to Brainstormer.
    Thursday, March 31, 2011 7:18 AM
  • Client caching

    http://edn.embarcadero.com/article/38123

    You can cache xmlhttprequest objects but it can be a little tricky and I recommend reading up on it.

    http://www.mnot.net/javascript/xmlhttprequest/cache.html

    Thursday, March 31, 2011 7:32 AM
  • Plus do you really need to enum the table with a FOR? Can't you use a filter or a find or even just linq? You might want to look at 'Fragment caching' the control, especially if the data doesn't change. If it's the same for every user then I would certainly look at that. ASP.NET will look after the caching for you.
    http://pauliom.wordpress.com
    Saturday, April 2, 2011 7:27 AM
  • If everyone gets the same thing and it's relatively static then just batch up a file on the server with a datetime in the name and have a mechanism replaces it when the data changes.

    Monday, April 4, 2011 12:22 PM