OpenEuphoria

Re: SQLite wrappers

• Posted by Matt Lewis <matthewwalkerlewis at gmail.com> Aug 30, 2005
• 609 views

Chris Burch wrote:
> 
> Hi
> 
> Just got back from hols in Ballamory.
> 
> I used eusqlite as it stands atm, and created this. Note sqlite_get_table is a
> wrapper
> for sqlite_exec, and as yet I haven't needed anything more complex than what
> the library
> provides, but looking at the benchmarks, it may be that sqlite prepared
> statements
> may be quite a bit faster than throwing sql statements at the engine one at a
> time
> - will look into this.

If you have a lot of repetitive queries to perform, and can simply change
a parameter, this is almost always better than simply executing a plain
text sql statement.  Basically, you're allowing the sql engine to compile
the statement once, and execute it many times.  It's not very important if
the statement is only rarely executed, but can make a big difference for
repetetive tasks.

Matt Lewis