It takes about 6 seconds to insert 100 records into a sqlite db on my
Linux x64 system. Is sqlite normally that slow?
Thanks,
Tadhg
Here is the code I used:
USING: db db.sqlite db.tuples db.types ;
TUPLE: sqltest id ;
sqltest "SQLTEST" {
{ "id" "ID" +db-assigned-id+ }
} define-persistent
: with-sqltest-db ( quot -- )
"sqltest.db" <sqlite-db> swap with-db ; inline
: insert-test ( -- )
[
sqltest recreate-table
100 [ sqltest new insert-tuple ] times
] with-sqltest-db ;
[ insert-test ] time
------------------------------------------------------------------------------
Fulfilling the Lean Software Promise
Lean software platforms are now widely adopted and the benefits have been
demonstrated beyond question. Learn why your peers are replacing JEE
containers with lightweight application servers - and what you can gain
from the move. http://p.sf.net/sfu/vmware-sfemails
_______________________________________________
Factor-talk mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/factor-talk
