Im looking for some ideas as to why the performance for a select statement takes roughly 5 times longer on AIX as on a linux system.
The disk drive on the aix platform is a 10k scsi vs the 7200 rpm drive on linux. AIX: sqlite> .timer on sqlite> .output ken.out sqlite> .read kdo.sql CPU Time: user 26.321955 sys 6.498729 sqlite> Linux: sqlite> .timer on sqlite> .output ken.out sqlite> .read kdo.sql CPU Time: user 4.648290 sys 0.888056 sqlite> Thanks, Ken Adding pragma temp_store=2 does seem to help, it does reduce the sys time from 6 to .5 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
