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:thilo.sta...@apprologic.de] 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 >> Arsperl-users@arsperl.org <mailto:Arsperl-users@arsperl.org> >> https://lists.sourceforge.net/lists/listinfo/arsperl-users > > > ---------------------------------------------------------------------- > -- > > ---------------------------------------------------------------------- > -------- > > > ---------------------------------------------------------------------- > -- > > > > -- > Arsperl-users mailing list > Arsperl-users@arsperl.org > https://lists.sourceforge.net/lists/listinfo/arsperl-users ------------------------------------------------------------------------------ -- Arsperl-users mailing list Arsperl-users@arsperl.org https://lists.sourceforge.net/lists/listinfo/arsperl-users ------------------------------------------------------------------------------ -- Arsperl-users mailing list Arsperl-users@arsperl.org https://lists.sourceforge.net/lists/listinfo/arsperl-users
