DataTable efficiency

 My application uses a largish readonly database (CSV files,
 actually) consisting of several tables.  These tables are
 accessed somewhat frequently, and I want to make this as
 efficient as possible.  I'm currently using plain DataTable
 objects produced by OdbcAdapters and queries.     These
 tables are cached so I'm just searching in-memory tables
 after that.  My queries look like "SELECT * FROM [{0}]" and
 occasionally "SELECT * FROM [{0}] where [{1}] = '{2}'".
 I'm thinking of splitting the latter into just
 table.Select("colname = value").

 I have a nagging suspicion that the DataTable structure isn't
 super-efficient, or that certain ways of using it are
 effcient while others aren't.

 Is this so?  Are there certain things I should avoid?  Do you
 recommend a certain style for efficient access?  Is there a
 better approach that DataTable?

===================================
This list is hosted by DevelopMentor®  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com