Hi RaghavendraK, * RaghavendraK 70574 <[EMAIL PROTECTED]> [2007-06-25 08:45]: > When the DB is opened in "in Memory mode",performance of query > does not improve. For table which has 10 columns of type Text > and each column having 128bytes data and having a total of > 10000 records.
that is small enough to fit into memory, and therefore small enough to fit into the OS disk cache. In such a case, the performance of SQLite does not differ significantly between in-memory and on-disk databases. Your problem is elsewhere. If you provide your schema and queries, someone might be able to tell you what about them makes SQLite go so slow and how to make it faster. Regards, -- Aristotle Pagaltzis // <http://plasmasturm.org/> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
