What happens if you run your test outside of VirtualBox?
I'm thinking when you first write the file VirtualBox does it locally and then flushes the whole thing to system disk. Then, when you restart the file is on system disk and it is flushing each insert to system disk on the WAL file slowing things down dramaticalliy. If this is true your test will perform correctly on your main PC. I've heard about VM systems having problems writing to files like this. Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems ________________________________ From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Fabian [fabianpi...@gmail.com] Sent: Wednesday, November 02, 2011 11:57 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Slow INDEX 2011/11/2 Simon Slavin <slav...@bigfraud.org> > > So compare your 'restart-and-INSERT' test with one where you restart, log > in, then do a few random operations for a minute: start your web browser > and load a page. Open and close a few documents or control panels. Sit > and do nothing for a minute. /Then/ carry on with the test. > > To rule out your suggestion of background processes slowing down the operation, or any VirtualBox performance issues, I rebooted, and immediately copied the DB file (125 MB) to another location, and it completed within 5 seconds. So it doesn't seem VirtualBox or background processes are to blame. In the past I already did some tests with waiting for 15 minutes, and it had zero effect. Thanks for the suggestion anyway! _______________________________________________ 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
