sqlite on iOS 4.3.x much slower than 4.2.1

Why is sqlite on iOS 4.3.x much slower than 4.2.1. The same sqlite query (select query with 3 joins) gives the result开发者_开发百科s much faster on 4.2.1 than 4.3.x.

Is there any particular reason for the same? Or is it a bug on Apple's side?

Thanks in advance.

Is it the same database file? You may want to compact the database again. I'm not an iphone developer, but if they changed the filesystem from 4.2.x to 4.3.x there may be some issues with accessing trees from an old file. sqlite provides queries (look up VACUUM in the docs) that will compact and clean the database. As a last resort you can also try rebuilding the entire database (i.e. SELECT * from [each table in turn]; INSERT [each row] INTO [newdb].[table])

Hope this helps!