OpenEuphoria

Re: SQLite wrappers

• Posted by Tone Škoda <tskoda at email.si> Sep 01, 2005
• 525 views

Chris Burch wrote:

> I used eusqlite as it stands atm, and created this. 

<snip>


Hi

i already wrote those additional wrappers and here are my results:

C version, prepared SQL statements:
100000 inserts to bench.db in 1.753 s = 57045.07 inserts/s

Eu version, prepared SQL statements:
100000 inserts to bench.db in 2.240 s = 44642.86 inserts/s

Eu version, without prepared SQL statements (the program posted by Chris Burch):
 100000 inserts to bench.db in 9.400 s = 10638.30 inserts/s




sqlite_bind_blob() can be used to save any eu object (i used compress() from
database.e)
i also added automatic fatal errors reporting, like EDS does it, and i made some
other smaller changes.
do i send it to you or do i post it on my site? either is fine with me.


PS. I said that sqlite_exec() doesn' work, well it does work, my mistake.