[prev in list] [next in list] [prev in thread] [next in thread]
List: sqlite-users
Subject: Re: [sqlite] SQLite Transaction Rate and speed...
From: "Griggs, Donald" <Donald.Griggs () allscripts ! com>
Date: 2009-03-06 23:10:23
Message-ID: 8F808F4B25AF2744835E2BDA2802793122EC8BC3 () NCMAILBE2 ! onemisys ! com
[Download RAW message or body]
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
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic