Hi Normand,
Just for sanity, check whether Windows is not creating previous versions
for you.
Right click on the file in Explorer -> Properties -> Previous Versions.
Also check whether Caching is enabled on your HDD:
Control Panel -> Device Manager -> Disk Drives -> (Click on your HDD)
Then go to the "Policies" tab (should be second). There are two settings:
"Enable write caching on disk" and
"Turn off Windows write-cache buffer flushing on device"
The first one should probably be checked, but second one (if checked)
would be more dangerous, but faster (at least for me).
It depends how secure your data is. Our data can be regenerated, and
taken back from P4, and at worst I can lose some hours of work
(programming).
It's also good idea to check with SysInternals ProcMon what exactly is
going on.
Another good tool, is SysInternals RamMap - with it you can check what
portions of the file are in the file-cache (meta-data). You can also
flush the cache with it, and test various scenarios
Cheers,
Dimiter 'malkia' Stanev,
Senior Software Engineer,
Treyarch, Activision.
On 1/13/2012 3:56 PM, Normand Mongeau wrote:
On 2012-01-13 18:10, Roger Binns wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 13/01/12 14:35, Normand Mongeau wrote:
It gets worse. On a clean empty database, the same 534 transactions
take 140 seconds. That's a not very impressive rate of 3.8 inserts
per second. The FAQ says that SQLite should be able to do a "few dozen
transactions per second". I'd be happy to see that.
What file extension are you using for the database? There is a long list
of extensions that System Restore monitors, and makes backups of the
files
as they change. This will kill your performance.
I was using .db as an extension, and changed it to something ludicrous,
but it didn't make a difference. Good idea though.
Thanks,
Normand
Extension list and terse details are at:
http://msdn.microsoft.com/en-us/library/Aa378870
Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
iEYEARECAAYFAk8Quc4ACgkQmOOfHg372QQAowCgi0DlewfcHs6MIPIHSyjHw6mN
nFIAnjJch3erZfRF+I88yA3CzAkCQWVl
=HoSZ
-----END PGP SIGNATURE-----
_______________________________________________
sqlite-users mailing list
sqlite-users-czdrofg0bjidnm+yrof...@public.gmane.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
