4.1.14 100's of times faster than 5.0.16??

[David Wynter]

OK, Finally got 5.0.16 installed on the same machine as 4.1.14 was installed (they wouldn't co exist nicely). Ran the same configuration on both versions. This query

SELECT u.SECURITY_ID, u.CUSIP, NULL, NULL, NULL, NULL, NULL FROM customer_watch_list cw, secm_security_universe u WHERE cw.CUSIP = u.CUSIP AND cw.Portfolio_Id = 2

Took 14 seconds on 4.1.14 and I kill it after 10 minutes running time on 5.0.16.

I'd say that 5.0.16 has some fairly serious problems. Bizarrely a similar query

SELECT u.SECURITY_ID, NULL, NULL, NULL, NULL, u.SEDOL, NULL FROM customer_watch_list cw, secm_security_universe u WHERE cw.SEDOL = u.SEDOL AND cw.Portfolio_Id = 2

Is fast on the 5.0.16 and 4.1.14, SEDOL is VARCHAR(8) and CUSIP VARCHAR(9), what is wrong with 5.0.16? This is not isolated to one machine my production server also has the CUSIP problem. There has to be something fairly fundamemtally wrong with 5.0.16 for this to occur I'd say.

Any takers?

David