Re: [sqlite] AIX performance

2009-08-29 Thread John Stanton
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

[sqlite] AIX performance

2009-08-21 Thread Ken
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: