[sqlite] poor execution time with select queries

Hi all, I wrote a small C code to execute a number of select queries. Select execution code is rc = sqlite3_exec(db, BEGIN;, callback, 0, zErr); for(eQ = 0; eQ queries.size(); eQ++){ cout Executing eQ / queries.size() \t queries[eQ].query endl;

Re: [sqlite] poor execution time with select queries

By the way these queries execute very fast in MySQL, and one point I noticed is that a query is slow if tries to join two of the same tables, i.e. pte_atm r1, pte_atm r2, pte_drug r3 may this be the problem? _alenD alenD wrote: Hi all, I wrote a small C code to execute a number of select

[sqlite] creating database from dump file within C code

Hi all, I am a newbie to sqlite! Is there a way to create and populate a sqlite database from an already created dump file within C code. thanks! _alen D. -- View this message in context: http://old.nabble.com/creating-database-from-dump-file-within-C-code-tp27295724p27295724.html Sent from

Re: [sqlite] creating database from dump file within C code

Thanks, it worked perfect! _alenD Roger Binns wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 alenD wrote: Is there a way to create and populate a sqlite database from an already created dump file within C code. Load the dump text so you have it as one long string

[sqlite] creating indexes

Hi, Should an index be created before insertions or after insertions?:super: thanks in advance! _alenD -- View this message in context: http://old.nabble.com/creating-indexes-tp27299680p27299680.html Sent from the SQLite mailing list archive at Nabble.com.