Re: [sqlite] Re: methods to improve insertion speed with SQLite

2005-09-14 Thread Martin Engelschalk
YES! Thank you very much, Igor. I overlooked that. Now my application runs a little bit faster (6%) Igor Tandetnik schrieb: Martin Engelschalk wrote: Also, i suspect that sqlite3_bind_text makes a copy of the text i pass, which could be eliminated too. Or am i wrong there? Only if you are

[sqlite] Re: methods to improve insertion speed with SQLite

2005-09-14 Thread Igor Tandetnik
Martin Engelschalk wrote: Also, i suspect that sqlite3_bind_text makes a copy of the text i pass, which could be eliminated too. Or am i wrong there? Only if you are using SQLITE_TRANSIENT flag, if I understand correctly. Use SQLITE_STATIC or an actual destructor callback. Igor Tandetnik