[Vtigercrm-developers] mass edit performance

[Alan Bell]

On 18/09/14 08:34, SIAM Translations wrote:
> Added word "temp" to description field in 300 leads. It took 2 min.
> Can it be improved? 15s seems reasonable but in 2 min I drink my coffee :)
>
> Rgds
> Andrew Smith
>
>
> _______________________________________________
> http://www.vtiger.com/
the issue with this (which I have come across with bulk imports) is that 
vtiger very sensibly uses transactions around the save of objects so 
that an entity saves in all the related tables or none at all. It starts 
a transaction, does the updates then commits, which takes a moment (0.4 
seconds per entity sounds about right, including the modtracker 
updates). If you want to temporarily do some fast bulk stuff and you 
know what you are doing, then you can look in 
include/database/PearDatabase.php and break the startTransaction and 
completeTransaction methods by just getting them to instantly return. 
You can then turn autocommit off and start your own transaction, do lots 
of stuff then commit it all at once. This is *fast* and *dangerous*. 
Other things to turn off are workflow and modtracker. I am not quite 
sure how this kind of thing might be applied to normal mass edit, but it 
certainly helps for automated bulk data.

Alan.

-- 
Libertus Solutions
http://libertus.co.uk

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140918/2d419e66/attachment.html>