I don't think there's anything you can do - sending back that much information for two related selects does take a long time. I tried the same thing once using WDDX - sending about 9000 records to the page - and it took like 5 minutes on our local network.
- Matt Small -----Original Message----- From: Michael Ross [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 1:52 PM To: CF-Talk Subject: Re: 2 Selects killing me Well it works it just takes about 5 minutes to load....literally and quite a few seconds when I select from the first box. What can I do to speed it up? >>> [EMAIL PROTECTED] 03/28/02 05:52PM >>> Can you view the source? Is it possible that you are querying too many records and the browser can't handle all of the javascript that the tag is generating? I've killed a browser or two in this manner before :) Check the recordcount... jon ----- Original Message ----- From: "Michael Ross" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, March 28, 2002 4:31 PM Subject: 2 Selects killing me > I am trying to use the 2 selects and it not working the page just won't load. So I know I don't have any bugs just that my query isn't running right and I am not populating the selects right.... > > here is my query. Basically I have a table with lots of records. Using the first select box I want to to show only the cpt codes from the 1st boxes list of locations. the fees table has a idnumber, the locationid, the cpt code and some other data. > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
