Re: [Arsperl-users] ars_DeleteEntry

[Steve M. <Ste...@ch...>]

Well, sounds like sql is the way to go. Other than the t, h, b, and bxxx tables, do I have anything else to consider?

Thanks everyone.


-----Original Message-----
From: Thilo Stapff [mailto:thi...@ap...] 
Sent: Tuesday, March 31, 2009 1:17 AM
To: ARSperl User Discussion
Subject: Re: [Arsperl-users] ars_DeleteEntry

Just as a note, the speed of mass deletions can be vastly increased by using ars_Begin(End)BulkEntryTransaction. Of course, deleting by SQL will probably still be a magnitude faster.


jeff murphy wrote:
> Yes, although it'll take probably a long time to delete them all. You 
> might be better off going to SQL and deleting from the H, T and B 
> tables directly.
> 
> On Mar 30, 2009, at 7:56 PM, Steve McDonald wrote:
> 
>> Prior to a server upgrade and migration I need to purge 750k + 
>> records from my custom help desk application.  The records contain an 
>> attachment pool.  If I use ars_DeleteEntry will the corresponding b 
>> table bxxxcxxxxxxx entries be deleted as well?
>>  
>> Thanks,
>>  
>>  
>> Steve McDonald
>> Sr. Remedy Applications Programmer
>> Choice Hotels International
>>  
>> ---------------------------------------------------------------------
>> ---------
>>
>>
>> --
>> Arsperl-users mailing list
>> Ars...@ar... <mailto:Ars...@ar...>
>> https://lists.sourceforge.net/lists/listinfo/arsperl-users
> 
> 
> ----------------------------------------------------------------------
> --
> 
> ----------------------------------------------------------------------
> --------
> 
> 
> ----------------------------------------------------------------------
> --
> 
> 
> 
> --
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users


------------------------------------------------------------------------------


--
Arsperl-users mailing list
Ars...@ar...
https://lists.sourceforge.net/lists/listinfo/arsperl-users