September 8, 2004 at 3:27 pm
hi
i have an access xp application wich is connected to sql sever 2000. on one of my forms i have a combobox that have a rowsource of over 50,000 records (each record is around 50K). when oppening the combo for the first time it take atlist 7 sec to open.
does anybody have any idea how to reduce that time ?
i tried store procedure,function and view as the combo rowsource but there was mo change.
thanks
September 9, 2004 at 1:26 am
The user is not going to scroll through a 50000 long combo box. If it is Surnames for example, he would like to type the first 1 or 2 characters and then get a reduced list. What you will have to do is think of a method to reduce the records that is going to be loaded in the combo box. If it is Surnames, ask the user to select A - Z first thereby dividing the records to load in the combo box by at least 20.
5ilverFox
Consulting DBA / Developer
South Africa
September 9, 2004 at 6:49 am
Or on the same page as japie, you could make a search for the records... Something like : name like 'ab%' and state in (CA, FL) and.... (a little search engine). And also you could try not loading 50k lines if you don't need to... It's much faster for any app to only load a few small records (name + adress + phone instead of their whole information) than to load 2.3 gig of data (50 000 records time 50k = 2.384 GB of data to send over the network and then process).
this will be a lot faster for the server (with proper indexing) and also on the users that will have 1 less reason to b**ch at the server or you :-).
September 9, 2004 at 4:07 pm
If your data is not changed oftenly, copy the data to local access table and use it as a datasource for your combo box. It will run must faster.
Minh
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply