<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">On 07/02/13 08:53, Alan Lord wrote:<br>
</div>
<blockquote cite="mid:kevmgq$drg$1@ger.gmane.org" type="cite">
<blockquote type="cite" style="color: #000000;">
<pre wrap="">I added this SQL command to do it in our cron:
<span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">> </span>$adb->query('delete vtiger_evvtmap from vtiger_evvtmap join
<span class="moz-txt-citetags">> </span>vtiger_crmentity on crmid = evvtmapid where deleted = 1');
</pre>
</blockquote>
<pre wrap="">Thanks, I am still thinking about the best way to deal with deleted
records, will probably use this <b class="moz-txt-star"><span class="moz-txt-tag">*</span>and<span class="moz-txt-tag">*</span></b> an event handler. But, as one can
undelete (restore from recycle bin) I am wondering if it is worth doing
at all, until the records are <b class="moz-txt-star"><span class="moz-txt-tag">*</span>really<span class="moz-txt-tag">*</span></b> deleted.
</pre>
</blockquote>
<br>
<br>
The way I propose the delete command eliminates the geolocation
information from the map table only reducing its size, but if the
record is restored the populate cache function will recover the
information on the next access so it will recover transparently.<br>
<br>
<br>
<pre class="moz-signature" cols="72">--
Un saludo
Joe
TSolucio</pre>
</body>
</html>