you would need to give more info about your db, the data, etc. On my
Macbook Pro, I get 1000+ inserts a second for a random 100 byte string
insert (that is, less than one per ms). That includes the time to
generate the string, and is all in Perl, while I am listening to
iTunes, and no funny pragma trix. Code follows...
I am using SQLite 3.4.2
CREATE TABLE foo (a);
sub speedtest {
$sth->execute( str() )
}
sub str {
my $str;
for (0 .. 99) {
$str .= ('a' .. 'z')[int(rand(25)) + 1];
}
return $str;
}
timethis(1000, \&speed);
$ ./db.pl
timethis 1000: 2 wallclock secs ( 0.20 usr + 0.75 sys = 0.95 CPU) @
1052.63/s (n=1000)
On 12/3/07, Mark Riehl <[EMAIL PROTECTED]> wrote:
> I've got an application that logs real-time data. Some of the data is
> periodic (every few secs), other data comes more frequently.
> Basically, I'm not dealing with bulk inserts, so, I can't queue things
> up and insert all at once.
>
> I'm noticing that my insert times are pretty slow (~5-50 ms on a Intel
> Core 2) for a single record of ~100 bytes.
>
> Any suggestions for speeding up single row inserts? I saw some of the
> other threads on using transactions, but, not sure if that applied to
> single inserts.
>
> Here is a simple app I wrote to test the timing:
>
> int rc = sqlite3_open("mydb.db", &db);
>
> for (i = 0; i < 10; i++) {
>
> printf("Executing %s\n", insertStatement);
>
> gettimeofday(&before, 0);
> rc = sqlite3_exec(db, insertStatement, NULL, NULL, &zErr);
> gettimeofday(&after, 0);
> if (rc != SQLITE_OK) {
> ...
> }
> }
>
> printf("Before %d %d\n", before.tv_sec, before.tv_usec);
> printf("After %d %d\n", after.tv_sec, after.tv_usec);
>
> sleep(1);
> }
>
> sqlite3_close(db);
>
> Thanks for the help,
> Mark
>
> -----------------------------------------------------------------------------
> To unsubscribe, send email to [EMAIL PROTECTED]
> -----------------------------------------------------------------------------
>
>
--
Puneet Kishor
http://punkish.eidesis.org/
Nelson Institute for Environmental Studies
http://www.nelson.wisc.edu/
Open Source Geospatial Foundation (OSGeo)
http://www.osgeo.org/
Summer 2007 S&T Policy Fellow, The National Academies
http://www.nas.edu/
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
