>- see footer for list info -< Hi Its always going to be slow if you have 100,000+ options in the dropdown. Are you sure there are 100K options within the dropdown??
But with big dropdowns of users, what I do sometimes is have a hyperlink just above the dropdown (A, B C....) and when you initially load the dropdown just select all the members where surname like 'A%' and populate the dropdown with them If the members surname begins with S they just click the S hyperlink above the dropdown and the page reloads, this time populating the dropdown with members where surname like 'S%', so they can select themselves and continue This way the client keeps their dropdown and you get your performance increase But, 100K options in one dropdown??? You're kidding right? Dropdowns are bad enough with a complete country list.. Mark -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Davidson Sent: 29 June 2007 12:18 To: [email protected] Subject: [CF-Dev] (no subject) >- see footer for list info -< hi, i ma trying to improve performance and useability on a page I have inherited. Currenbtly, there is a dropdown at the top of the page that loads all th users in the system. This is just a simple dropwn, so you pick a user, the whole page reloads (with that userid sent as a URL parameter) and displays all the graphs and info for that user. This works perfectly fine with a small amount of users. The company has now had massive growth, and the number of users in the system is now something like 100,000+, and now the page is taking way too long to load (over 10secs sometimes). There are 2 thiings slowing it down, the stored proc to get the list of users is taking a few secs, but the main problem is that the size of the html page returned to the browser to load (with 100,00+ options in the user select dropdown) is about 4MB. Combined, this makes the page sooo slow. The company likes the idea of the dropdown of users though, and would like to keep it. Is this a case for AJAX ? I am familiar with AJAX, and have used it in a small scale before, but not for anything this big. If i were to use it, I would need to start populating the dropdown when the page loaded (so would not be waiting for an onClick or an onChange event), would the page still be useable (ie, could a user still click on all the other stuff on the page, would it still scroll, etc) ? Also, would it still have the same problems with about 4MB of data being sent to it to display ? Also, the user would still have to wait quite a while with the drop down saying just "loading" or something while the data was being collected and sent back to the page, so woudl still not be ideal. Would anyone have any suggestions about how you could display a very large dropdown (large amount of otpions), without have to use an actual select list dropdown (if that makes sense) ? How have other people presented an extremely large option slelect list to users ? any ideas appreciated ___________________________________________________________ Yahoo! Answers - Got a question? Someone out there knows the answer. Try it now. http://uk.answers.yahoo.com/ _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help >-< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
