RE: dbspaces migrating from 7.3 to 9.4

It might 'take care of it' but who is to say that is any quicker (or slower) then a couple of days spent understanding the data, the application requirements and hand-crafting a layout. I do have a SAN, but with a 1980's application and database 'design' I still like where I am. No, I am not, nor have been, a contractor. When we have had to employ one it has been for very specific, well defined tasks with the stipulation of good documentation and skills transfer. We are hard task masters and make sure we get the best 'bang for our buck' !! :-) -----Original Message----- From: Captain Pedantic [mailto:theharlequin36@hotmail.com] Sent: Friday, April 21, 2006 7:00 PM To: informix-list@iiug.org Subject: Re: dbspaces migrating from 7.3 to 9.4 I think David Williams previously pointed out that very large chunk sizes might susceptible to long checkpoint times. I've created some large chunks and been advised by IBM Informix Tech Support that more, smaller dbspaces (specifically dbspaces, not chunks) will give better checkpoint performance. Although I have not actually personally been convinced by the argument some pretty smart people on here, including Art, Marco and Obnoxio have given the same advice. >> My personal view is that you should create several spaces for your data and some more for your indexes. Split your heavily used tables out to separate spaces. Try to get through any LVM and place each space on its own spindle where possible. You write like a man stuck in the 1980s, Keith, rather than somone who has a shiny and expensive SAN that takes care of all this sort of stuff for him ... >> Pick two or three chunks sizes and stick to them (makes admin easier and more understandable to 'strangers'). You've never been a contractor then ...? ;-) _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list ********************************************************************************** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. **********************************************************************************