Hello!
Test script break with "out of memory" error
...
3887 7077236 microseconds per iteration
3888 7150770 microseconds per iteration
out of memory
while executing
"db eval {insert into data values (
datetime(julianday('now','localtime')),
abs(random()%10),
abs(random()%100),
abs(random()%1000),
abs(random()%10000..."
...
sqlite> select max(rowid) from data_content;
388800000
sqlite> pragma page_size;
8192
sqlite> pragma cache_size;
32000
===================================================
#!/usr/bin/tclsh8.5
package require sqlite3
catch {exec rm test.db}
sqlite3 db test.db
db eval {PRAGMA synchronous=0}.
#db eval {pragma cache_size=100000}.
db eval {PRAGMA journal_mode=TRUNCATE}
set ::env(USER) 1000
db eval "CREATE VIRTUAL TABLE data USING fts3(timestamp, id1, id2, id3, id4,
id5, id6, uid);"
for {set j 1} {$j<=5000} {incr j} {
puts -nonewline $j\t
puts [time {
db transaction {
for {set i 0} {$i<100000} {incr i} {
db eval {insert into data values (
datetime(julianday('now','localtime')),
abs(random()%10),
abs(random()%100),
abs(random()%1000),
abs(random()%10000),
abs(random()%100000),
abs(random()%1000000),
lower(hex(randomblob(16))))}
}
}
} 1]
}
===================================================
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
