RE: Dbspaces spanning multiple disks.

Paul, Is the data quite volatile? Is the data indexed? Do you rebuild your indexes? If you are deleting you will not reclaim the space unless you drop and rebuild your indexes. You may reclaim the 300 MB allowing you to drop the chunk. Hope this helps, Scott H. > ---------- > From: Howard, Paul[SMTP:PaulHow@medcmp.com] > Sent: Thursday, January 06, 2000 10:55 AM > To: 'informix-list@iiug.org' > 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? > >