Re: [sqlite] Saving a memory-based SQLite database to disk

Hi Jay, Definitely worth investigating. Thanks for the tip! -- Tito On 9 Nov 2008, at 8:44 AM, Jay A. Kreibich wrote: > On Sat, Nov 08, 2008 at 03:34:29PM -0800, Tito Ciuro scratched on > the wall: >> Hello, >> >> If I open a SQLite database in memory (using :memory:), would it be >>

Re: [sqlite] Saving a memory-based SQLite database to disk

Thank you for the pointer Joshua. -- Tito On 8 Nov 2008, at 3:46 PM, Joshua Paine wrote: > Tito Ciuro wrote: >> If I open a SQLite database in memory (using :memory:), would it be >> possible to save it on disk? > > Open a disk db and use the ATTACH sql command to add a memory DB. Do > your ops

Re: [sqlite] Saving a memory-based SQLite database to disk

On Sat, Nov 08, 2008 at 03:34:29PM -0800, Tito Ciuro scratched on the wall: > Hello, > > If I open a SQLite database in memory (using :memory:), would it be > possible to save it on disk? Here's the reason: > Manipulating data in memory is ~3.4x faster than using the file system > (YMMV). If

Re: [sqlite] Saving a memory-based SQLite database to disk

Tito Ciuro wrote: > If I open a SQLite database in memory (using :memory:), would it be > possible to save it on disk? Open a disk db and use the ATTACH sql command to add a memory DB. Do your ops in the memory DB, then insert select the results into your disk db. -- Joshua Paine LetterBlock:

[sqlite] Saving a memory-based SQLite database to disk

Hello, If I open a SQLite database in memory (using :memory:), would it be possible to save it on disk? Here's the reason: Using a file-based SQLite database: 2008-11-08 15:15:44.180 XML2Plist[5554:10b] Number of XML documents converted successfully: 2861 2008-11-08 15:15:53.053