Index DataColumns In Advance?

  • Thread starter Thread starter localhost
  • Start date Start date
L

localhost

Dealing with large DataTables in a DataSet. I want to setup indexes
on certain DataColumns in DataTables before I do any
selection/finding/filtering to speed things up. How can I do that?

Thanks.
 
There is no DataIndex object, if that is what you are aiming at. The best bet
is to only pull the data necessary to the client. If it is a requirement that
massive amounts of data be pulled (offline processing, for example), consider
deploying a database like MSDE, as a temporary "buffer".

---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************
 
The DataSet in v2.0 (Whidbey) has vastly improved internal indexing for
inserts and deletes, so you may want to do some tests to see how it compares
in your situation.
 
Back
Top