Re: DBEXPORT question

Posted in 1997

Kerry — Mon, 07 Jul 1997 15:47:22 GMT — source: Informix-list mailing list archive (1991-1998)

Hello, Irwin. Thanks for your post. >If your entire instance is to be located on a single RAID 5 array, I would >suggest using only three dbspaces: rootdbs, datadbs and tempdbs. Leave >your logical & physical logs in the root dbspace in this case and put your >databas(es) in the datadbs. 'tempdbs' is of course a temporary dbspace. This is the way we currently have it. While there are no bottlenecks in the System or I/O, we have a major transaction that is taking over TWICE as long to run in Version 7 as it does in Version 5. The only thing I can think of is that the large number of indexes on some of the tables that help Version 5's performance actually KILL the "inserts" that are being done while under Version 7. Thanks again! Kerry Kerry Davids Client: 414-751-1835 E-mail: dino@ix.netcom.com Sr. Consultant Pager: 888-360-5739 Pager E-mail: 0880955@pagenet.net