Re: Huge performance problems Sun/Informix

Posted in 2000

David ANDRIEU — Mon, 21 Feb 2000 16:17:03 +0100 — source: Informix-list mailing list archive (1991-1998)

Hi Glenn, what kind of Raid (1, 5?) are you talking about? How much cache do you have on this Raid systems? What is a BCP? TIA, David... ----- Original Message ----- From: Glenn Brackenridge <glenn@gbrack.demon.co.uk> To: <informix-list@iiug.org> Sent: Wednesday, February 16, 2000 11:19 AM Subject: Re: Huge performance problems Sun/Informix I bet your problem is mostly the A5000. Buy a decent RAID system. Here are some Sybase benchmark results from one of our customers. Disk Array Trials - elapsed time in seconds Raid"X" A5000 Disk Init 47 1GB Devices 600 720 Create 6 GB Database 360 4140 BCP in 1M rows 371 2415 BCP out 1M rows 63 117 Recreate clustered index on 1M rows 39 343 Recreate non- clustered index on 1M rows 39 120 BCP in 5M rows w/ 75 processes 709 814 BCP in 4M rows w/ 8 processes 728 1519 Run 24K select queries 384 453 Delete 500k rows 193 507 NB: Lowest is best! email me if you want details ---------- In article <38A97E52.5CA7D052@drgueldener.de>, Thomas Vogt <t.vogt@drgueldener.de> wrote: Hello everybody, we have huge performance problems on our 2-node Sun-Cluster with Informix: Environment: Sun E4500, 6 CPU's, 1GB Memory (primary host for database) Sun E3500, 4 CPU's, 1GB Memory (secondary host for takeover) 4 A5000-Diskarrays with 14 9,2GB disks each connected via FCAL