I have encountered some problems when upgrading to 3.2.5 from 3.2.2. I am
using the sqlite3.dll from a delphi application (windows xp), not the
sqlite3.exe
1. Order of returned records in a SELECT sometimes is not the same as 3.2.2,
when statement does not have an "ORDER BY". As an inmediate solution I added
the "order by" clause in every query, but am wandering whether there is an
alternative.
2. Performance (time to retrieve the same set of records, using the same SELECT
statement on both) is slightly slower on 3.2.5 than 3.2.2. Is there any
parameter that changed or that I need to set on this release?
3. When using the ":memory:" database, I attached a physical database and ran a
select statement which joined one table from the ":memory:" database to two
tables from the physical one. I use WHERE instead of JOINs. On 3.2.5 the
query freezes, on 3.2.2 it works fine. Is there anything special I need to
setup to work with attached databases on 3.2.5?
jp
---------------------------------
Start your day with Yahoo! - make it your home page
