Re: Perfromance of SQL DELETE vs clrpfm

[Alan Campin <alan0307d@xxxxxxxxx>]

Also, if you RI on the table you may not be able to do a CLRPFM and may have
to use a SQL Delete.

On Thu, Oct 14, 2010 at 9:31 AM, <Nick_Radich@xxxxxxxxxxxxxx> wrote:

> Hi Richard,
>
> I don't know about the performance part, but I believe the CLRPFM must
> have an exclusive lock on the file, and the SQL does not.
>
>
>
>
> Thanx,
>
> Nick
>
>
>
> Nick Radich
> Sr. Programmer/Analyst
> EPC Molding, Inc.
> Direct  (320) 679-6683
> Toll free  (800) 388-2155  ext. 6683
> Fax  (320) 679-4516
> nick_radich@xxxxxxxxxxxxxx
>
>
>
> From:   Richard Reeve <richreeve@xxxxxxxxx>
> To:     midrange-l@xxxxxxxxxxxx
> Date:   10/14/2010 10:25 AM
> Subject:        Perfromance of SQL DELETE vs clrpfm
> Sent by:        midrange-l-bounces@xxxxxxxxxxxx
>
>
>
> I just came across a program(CL) that uses the delete function within SQL
> to
> clear a file and that made me wonder if it is more efficient to do a
> CLRPFM or
> if the SQL delete would be as efficient.
>
> Any thoughts/experiences?
>
>
> Warmest Regards,
>
> Richard Reeve
>
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.