RaghavendraK 70574 <[EMAIL PROTECTED]> wrote: > Hi, > > 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. Performance is around 2400 > records/sec. Any ways to improve it. >
You should be getting something well in excess of 1 million records per second. Probably you are structuring your query in a way that is very inefficient. Please provide your schema and the exact text of your query and perhaps someone can help you. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------