I have migrated from moodle 1.9 to moodle 2.3 both with oracle 10g and the performance has been seriously degradated
The thing is that in the machine with moodle 1.9 we are using oci8 1.2.3 while in moodle 2.3 oci8 1.4.6 is being used. I know that oci8 1.4.6 is for Oracle 11g but anyway I installed it for two reasons:
-I supposed that it was compatible with Oracle 10g and in addition it will fix bugs of prevous versions of oci8
-In a few months we are going to migrate to Oracle 11g so I preferred to install the Oracle Instant Client for Oracle 11g instead of the Oracle Instant Client form Oracle 10g.
Anyway I am suffering performance degradations in Moodle 2.3 and I doubt if one of the problems comes from the oci8 version I have installed (may be I should install Oracle Instant Client 10g ? ). I think I have two options:
- Install Oracle Instant Client 10g
- Activate the use of oci8 persistent connections in order to try to improve performance
My actual configuration of oci 8 is:
oci8.connection_class no value
oci8.default_prefetch 100
oci8.events Off
oci8.max_persistent -1
oci8.old_oci_close_semantics
oci8.persistent_timeout -1
oci8.ping_interval 60
oci8.privileged_connect Off
oci8.statement_cache_size 100
What is the best option? Thanks in advance to every one