asp taking too long to load! help!

Results 1 to 2 of 2

Thread: asp taking too long to load! help!

  1. #1
    Join Date
    Dec 1969

    Default asp taking too long to load! help!

    my asp file produces a long html file through the use of a lot of loops to create about 100 drop down select menus.<BR>the data for the drop down list is taken from a database only once.<BR>only the first 50 or so lists appear complete.<BR>the rest is garbled.<BR>how can i speed up the page&#039s performance?<BR>what else can i do?

  2. #2
    Rich Williams Guest

    Default RE: asp taking too long to load! help!

    Look at the intermediate coding tips on this site, and use the rs.GetString function if you can. If some of the dropdown boxes are duplicates, save the result in a string instead of writing it out immediatly, and then re-use the string.<BR><BR>Ex<BR>&#060;%<BR>dd1 = "&#060;select name=dd1&#062;" & vbCrLf<BR>While Not(rs.EOF)<BR> dd1 = dd1 & "&#060;option value=""rs.Fields(0)""&#062;" & _<BR> rs.Fields(1) & "&#060;/option&#062;" & vbCrLf<BR>WEnd<BR>dd1 = dd1 & "&#060;/select&#062;"<BR>%&#062;<BR>...<BR>&#060;%=dd1%&#0 62;<BR><BR>Hope that helps,<BR>Rich Williams

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts