[Vtigercrm-developers] GeoTools code is up!

[Joe Bordes]

On 07/02/13 08:53, Alan Lord wrote:
>> I added this SQL command to do it in our cron:
>> >
>> >$adb->query('delete vtiger_evvtmap from vtiger_evvtmap join
>> >vtiger_crmentity on crmid = evvtmapid where deleted = 1');
> Thanks, I am still thinking about the best way to deal with deleted
> records, will probably use this*and*  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*really*  deleted.
>


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.


-- 
Un saludo
Joe
TSolucio

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20130207/2b6954a3/attachment.html