Thanks Nick, good point. ahh yes, I've read about this somewhere...
My extension is currently ".db", a quick check indicates that using ".abc" gives a slight speed improvement, maybe 10%. But that is allready very close to the variation I get between different test runs, so I'm not really sure if I have this "microsoft effect" here. Anyway, thanks for the reminder. Well, I think now there is nothing wrong here, it is just as it is... Currently I achieve about 10 transactions/second, maybe not that bad... still slower than the "few dozen" that are mentioned on the www pages, but I agree that there too many issues that may affect the disk speed. Marcus Brandon, Nicholas (UK) wrote: >> my developemnt system is a Win XP, with of course NTFS, I >> don't know which drive it has, I guess a standard 7200 rpm. >> > > What file extension (i.e. the letters after the dot in the filename) do > you give the database? > > I faintly recall there is a windows peculiarity with system restore or > something similar that archives certain file extensions in the > background. That may contribute to your slow down. > > Nick > > ******************************************************************** > This email and any attachments are confidential to the intended > recipient and may also be privileged. If you are not the intended > recipient please delete it from your system and notify the sender. > You should not copy it or use it for any purpose nor disclose or > distribute its contents to any other person. > ******************************************************************** > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.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