Does BindingSource.Find() use an index?
-
I guess not. Doing 10 Find() operations on a large table (55000 records) loaded into a BindingSource component always takes about 1.8 secs, with or without a primary key set on the column being searched. Any ideas on how to add an indexed field to speed up searching? Kees
-
I guess not. Doing 10 Find() operations on a large table (55000 records) loaded into a BindingSource component always takes about 1.8 secs, with or without a primary key set on the column being searched. Any ideas on how to add an indexed field to speed up searching? Kees
I guess you've bound DataTable or DataSet to your control? If so, table is searched as it was an array of objects, not as a table in a database. Hence, indexes don't matter. If you want index to speed up the process then you need to perform search by database. Just execute query again with different WHERE clause.
-
I guess you've bound DataTable or DataSet to your control? If so, table is searched as it was an array of objects, not as a table in a database. Hence, indexes don't matter. If you want index to speed up the process then you need to perform search by database. Just execute query again with different WHERE clause.