I already tried. I could see no particular effect or, at least, not so dramatic.
-----Messaggio originale----- Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Inviato: martedì, 7. febbraio 2006 14:22 A: sqlite-users@sqlite.org Oggetto: Re: [sqlite] Snapshot database creation performance "Clinco, Michele" <[EMAIL PROTECTED]> wrote: > > This operation is quite heavy and takes several seconds (20 sec on my > laptop, generating a 1700k data file) > > Since the file is absolutely temporary, I installed a ramdisk driver and > I tried to create the file in this driver instead that in the hard disk. > > The difference is really astonishing: 0.9 seconds instead of >20. This > means that I don' have to worry about performance any more. > Maybe if you set "PRAGMA synchronous=OFF" the performance would be nearly as good when going to disk as it is when using a RAM disk. With "PRAGMA synchronous=OFF", your database can become corrupt if you take an OS crash or power failure in the middle of an update, but I gather you really don't care about that. -- D. Richard Hipp <[EMAIL PROTECTED]>
