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