Re: WGS 7.x STORED PROCEDURES DO HAVE A POOR PERFORMANCE VS ON LINE 5.x?

Andr's Castro Monge wrote: > > Dear INFORMIX customers: > > We did successfully installed INFORMIX WGS 7.x in a OPEN SERVER, > COMPAQ PROLIANT 3000, 1 CPU, 128 MB RAM., two disks (4 physical disks in > a redundant internal disk array): > Disk 1- O.S., INFORMIX engine and programs. > Disk 2- INFORMIX DB on raw UNIX partitions.. > > Overall database performance (DB updates, inserts, triggers > procedures, and son on) is better in WGS 7.x (Using raw devices) than it > was in the previous version ON LINE 5.x (Using cooked devices). > However, STORED PROCEDURES performance is around 5 times poorer in WGS > 7.x than it was in ON LINE 5.x: How is it possible? Is there any > workaround? Did I mismatch INFORMIX or O.S. parameters? > <big snip> Have you run UPDATE STATISTICS on all tables and the procedures? Like this: UPDATE STATISTICS FOR PROCEDURE;-- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 --- If all else fails, read the instructions. All opinions are my own and not those of Bayer plc. My Internet plumbing does not allow me to mail and post news together. Sorry. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/