in reply to DBI/DB2 slow on Fedora, fast on SUSE

IBM says here:
Database server performance, typically measured in terms of the transaction throughput and application response time, depends heavily on the I/O subsystem performance. To attain the best possible I/O throughput, database table data layout demands special attention from database and system administrators.
I suggest you examine the file systems in use, the layout and the performance of your disks, and the individual settings related to file system performance. Generally, the ext3 file system is conceived as less performant than, say, XFS. The choice and setup of your file system heavily impacts database performance.
--
Andreas
  • Comment on Re: DBI/DB2 slow on Fedora, fast on SUSE

Replies are listed 'Best First'.
Re^2: DBI/DB2 slow on Fedora, fast on SUSE
by hrr (Monk) on Jul 24, 2007 at 19:48 UTC
    All true, but the file system should not play a big role in my tests. (For the first test, the row should be in DB2's cache; for the second test, I have clustered the table on the key I have searched for, such that all 100,000 rows are on the same location on the disk.)

    Also note that the speep-up I have observed when upgrading from the Fedora to the SUSE perl packages (all on the Fedora system), was a factor of 10, even if I made no other changes.

    So I guess this is not a problem with DB2, but rather with perl accessing it.