[ cf-dev ] Problems with CFFORM performance with MX

[Osullivan Karl (RKB) Senior Analyst/Programmer]

Hi Group, Has anyone had any performance problems with CFFORM/CFTREE under MX? I have a query that returns approx 1,500  names and runs in about 350ms.  It then shows these names in a tree, grouped by the first letter. Ie. click on "A" to show all the surnames beginning with "A".  This has worked fine for the last three years. Since we've upgraded to MX, the query still takes 350ms to run, but the page takes 55 seconds (according to the debug info).  Does anyone have any idea why?  We've not changed the Java applet, but this doesn't count within the debug time anyway. Thanks Karl O'Sullivan Senior Analyst/Programmer Computer & Network Services UHCW NHS Trust Clifford Bridge Road COVENTRY CV2 2DX Contact: Tel (internal): 28952 Tel (external): +44 (0) 24 7696 8952 Email: [EMAIL PROTECTED] Web: www.uhcw.nhs.uk