Jim Wilcoxson wrote:
Here's what I'd try:
1. Write a small server that accepts connections and writes to the
SQLite database using prepared statements. If you need require 500
transaction per second, it's simply not possible with rotating media.
I am a late comer to this discussion, so this might have already been
purposed...
Ever consider having all the updates are done on none rotating media
(SSD) and then having 1 process that reads in blocks of the data and
puts it into it's final home? Purge the SSD SQLite db simply by rolling
to a new one from time to time and delete the old once once all the
connections have moved on to the new SQLite db.
Sam
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users