ekendricks
Posts: 34
|
| Posted: 06/02/2005, 3:27 PM |
|
Using MS Access 2000 - Asp - CCS 2.2.3.24
I have an Add/Edit grid "Procedures" with a textbox for "Code". The code is taken from the "Code Table". I changed the textbox to list box, and set DataSource=Code Table, BoundColumn=CodeID, Text Column=CodeName, and Date Type=Integer. The "Code Table" has in excess of 13K records.
When I load the "Procedures" page, it times out. I deleted all but a few records from the "Code Table" and the page loads perfectly. Is my problem the amount of records in the "Code Table", (as it appears to be) in that table. If so, is there a work around?
My major concern is that I have several other such functions in the website, and now I'm concerned about the number of records 6-12-24 months from now.
Thanks
Ernest
|
 |
 |
tecolotemx
|
| Posted: 06/03/2005, 9:16 AM |
|
Here is my advice.
Usually a ListBox hasnīt troubles. You can try using a sample Access Query, with less information, less Fields, or even with limited rows using a SELECT TOP query.
The stored Access Querys works as tables when you use CCS. So maybe you can use a Query that hasnīt the "code" field, for a faster response.
|
|
|
|
tecolotemx
|
| Posted: 06/03/2005, 9:24 AM |
|
In addition to my last comment, even if you have a list of 13k records, maybe you can filter this information.
In the data source of your list box you can add a "where" condition. Then, exactly as a Grid, you can receive the ID of another table or criteria, and the user will not have to search into a list of 13k options.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 06/03/2005, 10:02 AM |
|
ASP is very slow with assembling large strings required to build a listbox, but for larger amount of data you can speed up the listbox by placing such code the in "Before Show" event of the ListBox:
Formname.Listboxname.PopulatingType = ccsJoins
(Formname and Listboxname need to be replaced with your own values)
This method is little slower with lesser number of values, but should work in your case, if you still want your users to select from such a large number of values.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
