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 switched off windows virtual memory paging - the same effect. disk io is near zero, it's really the db commands only that causes this huge difference... working on the file db is much faster than on memory given the same process. do i have to pragma sth special (tried almost everything here, too...) thnx for your help, pong *stuck -- Psssst! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger?did=10 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
