Re: [sqlite] Please help test the latest query planner changes

2010-04-18 Thread Edzard Pasma
Op 16-apr-2010, om 19:51 heeft D. Richard Hipp het volgende geschreven: > > On Apr 16, 2010, at 11:52 AM, Max Vlasov wrote: >> >> SELECT StihiAuthors.Id As AuthId, StihiAuthCandidates.Date as Date, >> StihiAuthCandidates.Num as Num FROM StihiAuthors >> INNER JOIN StihiAuthCandidates ON >>

Re: [sqlite] Please help test the latest query planner changes

2010-04-16 Thread D. Richard Hipp
On Apr 16, 2010, at 11:52 AM, Max Vlasov wrote: > > SELECT StihiAuthors.Id As AuthId, StihiAuthCandidates.Date as Date, > StihiAuthCandidates.Num as Num FROM StihiAuthors > INNER JOIN StihiAuthCandidates ON > StihiAuthors.Id=StihiAuthCandidates.AuthorId > LEFT JOIN StihiPoems ON

Re: [sqlite] Please help test the latest query planner changes

2010-04-16 Thread Max Vlasov
> We are looking forward to your feedback, both positive and negative. > > Mr D. Richard Hipp found some time to compare this variant with the direct predecessor (3.6.23_1) Both dlls were compiled with Borland command-line compiler with identical options I tested a simple multiply lookup driven

[sqlite] Please help test the latest query planner changes

2010-04-15 Thread D. Richard Hipp
We've been tweaking of the SQLite query planner in an effort to help joins run faster. But whenever you tweak the query planner, there is always a risk that some query plans might become significantly slower. Your help in identifying any performance regressions is greatly appreciated.