<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">On 18/09/14 08:34, SIAM Translations
wrote:<br>
</div>
<blockquote
cite="mid:CAAcitv2wskxhdz29N3mnnCJwfXAufm6P=B9wGUPcXPk2FzwqCw@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>
<div dir="ltr">
<div>Added word "temp" to description field in 300 leads. It
took 2 min.<br>
Can it be improved? 15s seems reasonable but in 2 min I
drink my coffee :)</div>
<div><br>
</div>
<div>Rgds</div>
<div>Andrew Smith</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
<a class="moz-txt-link-freetext" href="http://www.vtiger.com/">http://www.vtiger.com/</a></pre>
</blockquote>
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.<br>
<br>
Alan.<br>
<br>
<pre class="moz-signature" cols="72">--
Libertus Solutions
<a class="moz-txt-link-freetext" href="http://libertus.co.uk">http://libertus.co.uk</a></pre>
</body>
</html>