if you need to always replace or create an new row you might just do a "INSERT OR REPLACE" which will replace the record if it exists or insert a new one if it does not.
On Fri, Mar 6, 2009 at 3:10 PM, Griggs, Donald <donald.gri...@allscripts.com> wrote: > 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 > -- Jim Dodgen j...@dodgen.us _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
