Re: [sqlite] Plan not optimized ?

Hi Richard, Do you have a plan to implement "common subexpression elimination" ? In the attached database, when I try to execute "select * from v_category_display", performances are very bad and I don't know how to correct this problem. "common subexpression elimination" is the best solution

Re: [sqlite] Plan not optimized ?

Hi, Thank you for the answer. Do you know if it's planned ? Do you know a workaround? Regards, Stephane Le samedi 4 juin 2011 12:36:47, Richard Hipp a écrit : > 2011/6/3 Stéphane MANKOWSKI > > > 4-EXPLAIN QUERY PLAN SELECT total, total+1, total+2 FROM v_c > > > >

Re: [sqlite] Plan not optimized ?

On 03-06-2011 14:29, Stéphane MANKOWSKI wrote: > Hi, > > First, think you for doing sqlite. I like it ! > > I am surprised by the result of "EXPLAIN QUERY PLAN" on some queries. > > I will explain try to explain my issue. > > 1-Open the attached database > This database contains a table

Re: [sqlite] Plan not optimized ?

2011/6/3 Stéphane MANKOWSKI > > 4-EXPLAIN QUERY PLAN SELECT total, total+1, total+2 FROM v_c > returns: >SCAN TABLE c (~74 rows) >EXECUTE CORRELATED SCALAR SUBQUERY 1 >SEARCH TABLE a USING INDEX a_r_a_id (r_a_id=?) (~88 rows) >EXECUTE

[sqlite] Plan not optimized ?

Hi, First, think you for doing sqlite. I like it ! I am surprised by the result of "EXPLAIN QUERY PLAN" on some queries. I will explain try to explain my issue. 1-Open the attached database This database contains a table "a": CREATE TABLE a(id INT,v REAL,r_a_id INT)