[EMAIL PROTECTED] wrote: > hi all, > > i got a question concerning in-memory-behaviour of sqlite. > > this is what i'm trying to do: > > i load an existing file db into a memory one (create a :memory:-connection, > attaching the file db which has ~ 60 mb and then copying its tables and > indices and detaching the file db - this works quite great so far, lasts > around 5 secs). now i begin a transaction on the in-memory-db and start > executing my queries (some 10k inserts, updates and deletes). and this > process is horribly (sic!) slow. > > in comparison i did all the inserts into an empty memory-db (without cloning > the whole file db first) which is faster by around factor 1000... > > anyone has a clue what happens there?
I don't have any ideas. Please provide more clues. What version of SQLite are you using. Did you DETACH the disk database before running the queries. What kind of queries are you using? What kind of data is in your database. Can you post examples? -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
