"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]>
