On Wed, Jun 01, 2011 at 09:25:04 +0200, Alessandro Marzocchi wrote:
> However I was surprised as the performance got a lot
> worse, with execution times being more than 3 times more. I tried
> everything I could think of and also peeked at python module's source
> but i couldn't find any way to get C program performance to match
> python's one.
Are you linking against existing sqlite library or compiling it yourself?i
If the later, make sure you enabled all optimizations and disabled assertions
in sqlite. Your flags when compiling sqlite source should include -O3 (most
optimizations) and -DNDEBUG (to turn off assertions). These tend to make huge
effect on sqlite performance.
--
Jan 'Bulb' Hudec <b...@ucw.cz>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
