Hi Steve,
Good practice (so I've read!) is to only return the minimal amount of data
from a db that is necessary for your app.
Because you haven't given much info. I have to guess that you are returning
a complete table, ie. SELECT * FROM tblName. You then state that you are
performing filtering on the returned dataset (well, again I am assuming
because you haven't said).
A better approach would be to do a level of 'filtering' BEFORE returning the
dataset. ie. SELECT thisColumn FROM tblName. If you then need other data
associated with the selection you might use a button to get the rest.
This suggestion may be way off base, hence the need perhaps to be slightly
more descriptive so that we can help you out! :-)
Regards, Phil
"Steve Lloyd" <st****************@livenowpaylater.co.uk> wrote in message
news:u%***************@TK2MSFTNGP15.phx.gbl...
Hi,
I am setting the datasource to a combobox but there datatable has over
10,000 rows and it is responding rather slowly when setting the datasource
and the display and value members. I filter the choices by filtering the
dataview as they type. Is there a better alternative?
Thanks for any help
Steve.