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;
On Mon, Feb 01, 2010 at 07:49:50AM -0800, alenD scratched on the wall:
Hi all,
I wrote a small C code to execute a number of select queries.
If you're doing a number of similar queries, look at the
prepare/bind/step interface. It is generally better than the exec()
interface.
SELECT
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