 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion Groups Database Servers DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybaseDesktop Databases FileMakerFoxProMS AccessParadoxGeneral General DB TopicsDatabase TheoryRelated Topics Java Development.NET DevelopmentVB DevelopmentMore Topics ... |
Database Forum / Informix Topics / October 2006Disk Srategy IFX Specirfic??
One of the tenants I've always adhered to when tuning RDBMS is that logfiles and datafiles should always be on separate physical devices if at all possible in order to exploit the nature of sequential reads vs. writes. Is there any reason this strategy should not be applied to an IFX installation? What would you suggest as an optimal strategy (in broad strokes as I understand much of this is situational...) for laying out datafiles vs. logs? Thanks Friends, Tam. Tam O'Shanter said: > One of the tenants I've always adhered to when tuning RDBMS is that > logfiles [quoted text clipped - 7 lines] > understand much of this is situational...) for laying out datafiles vs. > logs? It's one of the tenets I've adhered to. Adhering to tenants could be considered stalking, you know. ;o) I like to have a separate spindle (or spindles) each for root, llogs, plogs, a different set for temp and a different set for data, as many spindles as possible. Of course, you can't always get that, but that's what I like.  SignatureBye now, Obnoxio "... no bill is required as no value was provided." -- Christine Normile -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean. Are you going to charge me rent for this answer? Tam. > Tam O'Shanter said: >> One of the tenants I've always adhered to when tuning RDBMS is that [quoted text clipped - 17 lines] > > Of course, you can't always get that, but that's what I like. Tam O'Shanter said: > Are you going to charge me rent for this answer? I dunno. Let's get the basics out of the way: are you a hot babe? If yes, then I may charge in kind. Otherwise it'll be cash. SignatureBye now, Obnoxio "... no bill is required as no value was provided." -- Christine Normile -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.