Building a new system...

Posted in 2008

Ian Michael Gumby — Wed, 30 Apr 2008 13:06:48 +0000 — source: Usenet: comp.databases.informix

Ok, so I have this client who has a need. High speed access for OLTP and data retrieval and a slower access for document retrieval. (.pdfs). Looking at the new(er) generation of SAS Raid controllers, I can mix and match SAS and SATA within the same backplane. So does it make sense to split the database spaces against the two types of disks? RootDB, TempDB, some appDBs on SAS, then some appDBs that contain the tables for the blobs on the SATA? Then use RAID 10 on SAS and maybe raid 60 on SATA? (Art will probably kill me for mentioning anything but raid 10... ;-) Does anyone see any performance tuning issues? I can see doing this set up for a medical office in a box system. (Not that this is the application for the client. For some reason they are extremely "hush hush") TIA! -G _________________________________________________________________ Make i'm yours. Create a custom banner to support your cause. http://im.live.com/Messenger/IM/Contribute/Default.aspx?source=TXT_TAGHM_MSN_Make_IM_Yours