On 25/11/2005, at 7:14 PM, Jens Miltner wrote:
Hi Jens
These are some really good questions. I had to reinstall system
10.2 (with a little foresight, probably should have had installed the
systems on different partitions in the first place). I rebuilt the
files with project builder in 10.2. The app worked fine. This build
also worked fine when rebooting in system 10.4. I then rebuilt the
app in system 10.2 linking to the sqlite build I did under 10.4.
This also worked fine. Magically, when rebooting into 10.4 and
converting this PB project to xcode and rebuilding, the build worked!
In summary, I have no idea what the original problem was, but its
working fine now. Thanks for the tips and feedback all.
Peter
Peter,
no hot resolution tip here, but a couple of points you may want to
investigate:
- Are you sure it's related to your move to Mac OS X 10.4?
- Did you try the same query with the same database in your 10.2
build?
- If the updated app is still running on 10.2 - what are the
results if running on 10.2?
- If it's related to 10.4 - are you sure no other background
service is doing disk i/o (spotlight's comes to mind)?
- Did you try the same query/queries with the sqlite3 commandline
executable for comparison?
- Since apparently you're not using make to build sqlite: when you
build with deployment build style, did you define NDEBUG=1 ?
BTW: we're using sqlite 3.2.7 on 10.4 and I don't see this kind of
sluggishness, but anyway sqlite performance certainly also depends
on the data & schema of the database being used, so results can't
be compared unless the same database is used...
</jum>