Joe Wilson wrote:
The performance is pretty much the same as using a :memory: database.
Indexes can still be useful on memory databases to speed up queries.
It depends on your schema/data. Try it and see.
--- Cesar Rodas <[EMAIL PROTECTED]> wrote:
I am wondering if will be faster if i create a SQLite DB in a tempfs, but
with out index?
From my perspective, one notable advantage of using tempfs over
:memory: is that transferring the database to persistent storage is
essentially just a file copy (taking care to ensure you have exclusive
access to the database file). Going from a :memory: database to a file
involves some not overly complicated SQL which you can search for in the
list, but it isn't as obvious as a simple file copy.
--
Glenn McAllister <[EMAIL PROTECTED]> +1 416 348 1594
SOMA Networks, Inc. http://www.somanetworks.com/ +1 416 977 1414
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
