[Gambas-user] New sqlite3 database driver

[Benoît Minisini]

Hi,

I have rewritten the sqlite3 database driver, so that I get rid of all 
that badly written brain-fucking C++ code.

Now everything is written in C and smaller (about 3000 lines of code 
instead of 6000). Less memory should be used by big results, and so 
things should be a little bit faster. But I didn't do any benchmark.

Please report if you have any bug or crash with that new driver.

Note that I use it daily on my machine for my job, so I will be the 
first one impacted by any mistake!

By the way, if you are looking for optimizations when reading a result 
(whatever the database you are using), don't access them by field name, 
but try to use field indexes.

I.e. Result[0], Result[1]... instead of Result["field name"].

Because Result["field name"] implies string comparisons with all result 
field names to find the field index.

Regards,

-- 
Benoît Minisini