Re: [sqlite] How to save memory in Sqlite

2008-06-27 Thread toms
Hi In order to avoid fragmentation, we use sql as a buffer: all I/O have been rewritten to use a buffer instead a file writting. The previous solution (which cause fragmentation then) was to load a DB from file, creta a :memory: db, and then copy all data and structure from file DB --> mem DB. B

Re: [sqlite] prepare peformances

2008-06-11 Thread toms
just a little up since I have had no answers? I'm still having the pb and cannot understand why? :) Dennis Cote a écrit : > > I am forwarding this to the list in the hope that someone else will > have a good idea since the OP, toms, is having trouble posting himself. > >

Re: [sqlite] (juste a test sorry)

2008-06-10 Thread toms
looks like it works again, sorry for the inconvenience :) toms a écrit : > (juste a test sorry) > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] (juste a test sorry)

2008-06-10 Thread toms
(juste a test sorry) ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] prepare peformances

2008-06-10 Thread toms
(juste a test sorry) Dennis Cote a écrit : > > I am forwarding this to the list in the hope that someone else will > have a good idea since the OP, toms, is having trouble posting himself. > > Dennis Cote > > toms wrote: >> ok here is the code I use for the statem

[sqlite] prepare peformances

2008-06-09 Thread toms
sqlite3_exec. Did I miss something? Should I be aware of some tricks about prepare? Many thanks toms ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users