[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] SQLite Transaction Rate and speed...
From:       Jim Dodgen <jim () dodgen ! us>
Date:       2009-03-07 1:12:55
Message-ID: 7591df880903061712w6fd0025ai20ece5e236ca04d5 () mail ! gmail ! com
[Download RAW message or body]

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.Griggs@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.Kosse@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
Jim@dodgen.us
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[prev in list] [next in list] [prev in thread] [next in thread]