Regarding: sorry.. no luck either... or I have a personal problem with your ftp server -- he doesn't like my anonymous login... ;)
====================================== I get an error of "421 Too many users logged in for this account." I guess we smoked your tool. ;-) Pretty much echoing Roger Binn's recent comment, this posting by D. Hipp may be of interest: http://www.nabble.com/Behavior-of-SELECT-queries-during-transaction-to13 249797.html#a13257203 Just curious -- are you at liberty to say what this application is with this firehose of data? Also, I know you required multiple-millions of actions per minute -- but since you'll be updating some rows rather than inserting them all, about how big do you anticpate the database being? That can make a big difference because: a) Building and consulting the table's index will get longer the greater the number of rows, and b) If it's small enough, an in-ram database (":MEMORY:") Roger mentions might be feasible. FTP error below: N:\>ftp ftp.smokemytool.com Connected to ftp.smokemytool.com. 220-FileZilla Server version 0.9.24 beta 220-written by Tim Kosse (tim.ko...@gmx.de) 220 Please visit http://sourceforge.net/projects/filezilla/ User (ftp.smokemytool.com:(none)): anonymous 331 Password required for anonymous Password: 421 Too many users logged in for this account. Try again later. Login failed. ftp> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users