Comments Posted By xero

Displaying 0 To 0 Of 0 Comments

DataTable.Select Optimization

DataTables are implemented internally with a BTree variation, just like most relational databases use. http://en.wikipedia.org/wiki/B-tree

Searching in from multiple angles and inherent in the structure. Usually, uou can speed things up by adding an index, though I don’t remember if DataTables support indexes. I know that searching on the primary key is incredibly fast compared to not searching on the key. So if you’re not using a PK, start using one.

Another way to speed things up is to process the rows into other tables so the search set is smaller, or to use DataViews to that effect.

» Posted By xero On January 15, 2008 @ 04:26