RE: Raw vs Cooked space?

Paul 1. I dont believe cooked is easier to backup. To backup using the OS you need to switch the engine off-line which seems to defeat the purpose or is inconvenient. Any attempt to backup with the engine on-line is likely to be unrestorable. 2. The increase of Raw over cooked has been discussed at length. Search the Archives for Raw vs Cooked. The improvement depends upon you application, hardware etc. Some recent measurement on certain hardware suggest around 25% - 35% improvement. Personally I would never consider cooked chunks in a live installation. I find raw disk, away from prying eyes, far more convenient. Murray Wood -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of Paul Jazwierski Sent: Friday, January 28, 2000 6:10 AM To: informix-list@iiug.org Subject: Raw vs Cooked space? Can anybody point me to any factual information about the benefits/drawbacks of using raw vs cooked spaces. Cooked space is much easier to do backups on, since I dont have to do an informix backup. It seems to me that it is easier to use cooked space. I know that there are speed benefits to using raw space, but what are the concrete numbers? Am I going to get 100% performance improvement by using raw space? or is it going to be 10%? I am trying to do a cost/benefit analysis on this but I can't seem to find any information about it anywhere. Any info will be greatly appreciated. Paul Jazwierski, DBA