What machine runs AIX and what machine runs Linux and what FS are you using on Linux?
Ken wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users