:memory: databases only have a page size of 1024. Try various page_size settings for a file based database file and see what happens.
I have no other suggestions. --- RaghavendraK 70574 <[EMAIL PROTECTED]> wrote: > It is a server platform,Linux SuSE9 enterpraise edition. > 4 CPU machine,8GB ram. > We want load all the tables in to mem db of Sqlite.Achieve > read performance of upto 50000records/sec for the table data i had mentioned > earlier. > > "so it would have to be file based." > I could not get it. Does it mean even increasing the page size there would be > no effect on the performance? ____________________________________________________________________________________ It's here! Your new message! Get new email alerts with the free Yahoo! Toolbar. http://tools.search.yahoo.com/toolbar/features/mail/ ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
