|
|
|
Re: Performance problem [message #1966 is a reply to message #1965] |
Fri, 27 February 2009 11:57 ![Go to previous message Go to previous message](/theme/default/images/up.png) ![Go to next message Go to next message](/theme/default/images/down.png) |
AJM
Messages: 2361 Registered: April 2006 Location: Surrey, UK
|
Senior Member |
|
|
Is the delay inside _cm_getInitialDataMultiple() where it is assembling the data, or in insertMultiple() where it adds the data to the database?
How much validation or pre/post processing is being done as each record is inserted?
How many indexes does the table being inserted to have?
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
|
|
|
|
|
Re: Performance problem [message #1970 is a reply to message #1968] |
Thu, 05 March 2009 05:11 ![Go to previous message Go to previous message](/theme/default/images/up.png) |
AJM
Messages: 2361 Registered: April 2006 Location: Surrey, UK
|
Senior Member |
|
|
It is possible that all your database inserts are being slowed down because they are also being written to the AUDIT database. You can turn audit logging OFF for an individual task by placing the following code in the _cm_initialise() or _cm_getInitialDataMultiple() methods:
$this->audit_logging = false;
This will affect the current task only, so will leave audit logging ON (if it is configured to be ON) for all other tasks.
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
|
|
|