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
