Re: [sqlite] regarding looping in vdbe for sqlite table joins!

2015-02-02 Thread Hick Gunter
il.com] Gesendet: Montag, 02. Februar 2015 16:24 An: sqlite-users@sqlite.org Betreff: [sqlite] regarding looping in vdbe for sqlite table joins! Normally for executing joins in sqlite,the vdbe program opens 1 loop for each and every table but in my code(attached that file via pastebin) ,i am facing an

Re: [sqlite] regarding looping in vdbe for sqlite table joins!

2015-02-02 Thread Igor Tandetnik
On 2/2/2015 10:24 AM, Sairam Gaddam wrote: Normally for executing joins in sqlite,the vdbe program opens 1 loop for each and every table What makes you believe that? but in my code(attached that file via pastebin) ,i am facing an issue because it is opening only 2 loops even if i use 4

[sqlite] regarding looping in vdbe for sqlite table joins!

2015-02-02 Thread Sairam Gaddam
Normally for executing joins in sqlite,the vdbe program opens 1 loop for each and every table but in my code(attached that file via pastebin) ,i am facing an issue because it is opening only 2 loops even if i use 4 tables in joining operation. can anyone explain why it happened like that and