Traditionally we've found that it's better to issue a few larger queries against a database (such as MSSQL or Oracle) even when the results required some processing to separate out the data because much of the cost of running a query was communication and networking overhead. Since SQLite is an in-process/in-thread database engine, the communication overhead is now zero and we believe it may be more efficient to switch to chattier database communications.
What is everyone else's opinions on using many small queries vs one big one? Thanks, Sam ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------