Best practice forum (Archived)

Totara and Oracle database

 
? ?
Totara and Oracle database
by ? ? - Tuesday, 5 February 2013, 4:56 AM
 

I would like to set up Totara on Oracle DB (our client on the latest project has Oracle DB). 

When I tried Moodle 2.4 on Oracle DB I had significant performance issues. 

Is Totara any different from Moodle 2.4 in this respect?

Cheers!
Re: Totara and Oracle database
by James Gale - Wednesday, 6 February 2013, 1:28 AM
 

Hi Tomaz

I'm by no means a technical expert but I understand that Totara/Moodle have both been built to run with Postgress (sp?) and MySql DB.  I think you would need to re-write a lot of code to achieve what you are looking to do.

Hopefully someone else can give you more specific reasons/tips/suggestions etc.

James

This forum post has been removed
Thursday, 26 September 2013, 12:03 AM
The content of this forum post has been removed and can no longer be accessed.
? ?
Re: Totara and Oracle database
by ? ? - Thursday, 26 September 2013, 1:59 AM
 

Hi,

eventually we did not go on with Totara + Oracle, we stayed for now on mysql but still are open for our clients that use Oracle.

We have done the same as you mentioned on Moodle 2.2 and 2.4, but not on Oracel 10g - on Oracle 11g. The clob data was the biggest problem. We also implemented php accelerator, which we did not have at the beginning, add extra ram onm server, excluded some options on moodle settings etc, there were some better results but still sites with mysql are much faster.

Regards

Tom