> 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 query (SELECT .. LEFT JOIN .. LEFT
JOIN.. ) and did not find any significant difference.
In another test from real program when I have a master-detail relation
between authors and their poems, the query forms a pool of not yet read
poems your new planner seems to show real improvements.
With the query
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 Date=StihiPoems.PoemDate AND
Num=StihiPoems.PoemNum
WHERE StihiAuthors.IsFav=1 AND StihiPoems.rowid Is Null
sqlite3-amalgamation-3_6_23_1.dll
reported 747 milliseconds returning 22,642 rows
sqlite3-20100415132938.dll
reported 563 milliseconds
Both measurements are made several times and for a db that at least once was
used before in order to exclude windows system cache as a player.
Max Vlasov,
maxerist.net
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
