Hi Admins,
A development colleague of mine is having problems with Informix
performance.
The problem seems to be VERY slow query performance when using the SUM()
function.
Server details:
Digital UNIX V4.0F (Rev. 1229);
Informix Dynamic Server Version 7.30.FC4
Compaq AlphaServer ES40 DEC6600
CPUs: 4 Type: EV6 (21264) Speed: 500 Mhz Cache: 4.0 MB Memory size: 5120 MB
Any ideas gratefully received :-)
Kind regards
Lawrie Smith
Capita Technical Services
West Malling
email: lawrie.smith_at_capita.co.uk
Tel: 01732 877266
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**********************************************************************
Received on Tue Oct 16 2001 - 11:20:03 NZDT