On 22 Mar 2011, at 12:47am, Douglas Eck wrote: > I0321 16:48:04.492315 3924 gordon_generate_database.py:120] Running > sqlite3 /tmp/test.db < > /tmp/gordon_generate_databaseu0g1_c/gordon_sql-00007-of-00020. > I0321 16:59:39.222325 3924 gordon_generate_database.py:123] Ran in > 694.731889009 sec
Nice diagnostic. From five seconds to fourteen minutes a block. Just out of interest and for testing, can you put in at some point a pause of 10 seconds when your application is doing nothing ? Perhaps once out of every five of the above blocks. I'm wondering whether your major delays are when your caches are full and your disk is trying to catch up with your write commands. Something else you might try is to guess how big the eventual database file will be, then write a program create a dummy file with pseudo-random contents of that size. The time it takes that program to run will represent the fastest possible execution of your SQL-writing code, representing the speed limits of your operating system and hardware. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
