Re^2: SQLite database (or any) file in main memory!

Yes, this crossed my mind too! But I want control! :) Aka, KNOW its there! And Im also for a solution that works in Windows too! Thus, explicitly do it in Perl! (and not rely on some 3:rd part application, creating a Ramdisk...) But I guess the OS puts it there if used regularly.. (although it would be quite fonky to do this with Perl anyway :) )

Comment on Re^2: SQLite database (or any) file in main memory!

Replies are listed 'Best First'.
Re^3: SQLite database (or any) file in main memory! by BrowserUk (Patriarch) on Oct 06, 2005 at 17:21 UTC
Take a look at this free ram disk. I've been using it (occasionally) for a couple of years now both on NT and XP without problems. Whether your application performance will benefit I don't know, but it very small and easy to install and it is certainly the easy option for what you are trying to do. It would take you less than 5 minutes to try it out. Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error. Lingua non convalesco, consenesco et abolesco. -- Rule 1 has a caveat! -- Who broke the cabal? "Science is about questioning the status quo. Questioning authority". The "good enough" maybe good enough for the now, and perfection maybe unobtainable, but that should not preclude us from striving for perfection, when time, circumstance or desire allow.	[reply]

Replies are listed 'Best First'.

Re^3: SQLite database (or any) file in main memory!
by BrowserUk (Patriarch) on Oct 06, 2005 at 17:21 UTC

Take a look at this free ram disk. I've been using it (occasionally) for a couple of years now both on NT and XP without problems.

Whether your application performance will benefit I don't know, but it very small and easy to install and it is certainly the easy option for what you are trying to do. It would take you less than 5 minutes to try it out.

Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.

Lingua non convalesco, consenesco et abolesco. -- Rule 1 has a caveat! -- Who broke the cabal?

"Science is about questioning the status quo. Questioning authority".

The "good enough" maybe good enough for the now, and perfection maybe unobtainable, but that should not preclude us from striving for perfection, when time, circumstance or desire allow.

[reply]