Query performance within Lucee 4.5.2.018 (vs CF 9)

78 weergaven
Naar het eerste ongelezen bericht

Aimon Jassim

ongelezen,
26 jan 2016, 06:12:3326-01-2016
aan Lucee
Hello there,

We are exploring Lucee 4.5.2.018 as an alternative to ColdFusion 9, and have stumbled across some huge performance discrepancies between the two when performing query of queries.

A function will return a cfquery which is in turn used to perform subsequent queries against the result set. 

Aside from re-writing the query to reduce the number of selects hitting the database, is there any configuration that we could be missing that would lead to a comparable performance vs ColdFusion 9?

It appears like ColdFusion is doing a lot of work behind the scenes to handle the query of queries.

We have a standard Lucee express installation against an Oracle 11.2 database. 

Many thanks,

Aimon.

Harry Klein

ongelezen,
26 jan 2016, 06:45:0826-01-2016
aan Lucee

Hi Aimon,

 

I certainly wouldn’t recommend the Lucee & Oracle combination with open issues like:

https://luceeserver.atlassian.net/browse/LDEV-637

https://luceeserver.atlassian.net/browse/LDEV-385

https://luceeserver.atlassian.net/browse/LDEV-413

(some of them created half a year ago and still not triaged)

 

We had several issues with Oracle in the past (also with Railo) and decided to recommend ACF to customers with Oracle databases.

 

-Harry

 

P.S. ACF had and still has also problems with Oracle, if the enterprise driver is no option.

Thin driver problems with ACF: date/time functions & timestamp support, QoQ types, CLOB support …

--
Love Lucee? Become a supporter and be part of the Lucee project today! - http://lucee.org/supporters/become-a-supporter.html
---
You received this message because you are subscribed to the Google Groups "Lucee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/8c08d599-26c1-4edc-9131-5d3f628ac2d7%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Allen beantwoorden
Auteur beantwoorden
Doorsturen
0 nieuwe berichten