Re: Dbspaces spanning multiple disks.

Since your dbspace is spanning over multiple disks, it would actually take more time to seek to the other disk. Could it be possible, by adding a new dbspace could have rearranged all your extents and indexes so that they would be in continuos order which would take less time to access the first extents? Just my two cents. Sunil -----Original Message----- From: Howard, Paul <PaulHow@medcmp.com> To: 'informix-list@iiug.org' <informix-list@iiug.org> Date: Thursday, January 06, 2000 1:06 PM Subject: Dbspaces spanning multiple disks. |Platform AIX 4.2 IDS 7.24 | |We have a few high use tables fragmented round robin across four dbspaces. |Until about a month ago each dbspace was made up of two 1GB chunks on the |same disk. The result was that each dbspace took an entire 2GB disk. |Performance was great. A month ago we ran out of space and added 300MB |chunks from separate disks to a couple of these dbspaces. After this we |noticed significant a performance hit (We are not seeing multiple threads |per session anymore). Could the reason for our performance hit be that our |dbspaces are now spanning multiple disks or should we be looking elsewhere? | | |