Re: SQL within application programs

[David Gibbs <david@xxxxxxxxxxxx>]

Mary:

Although I claim to be no expert on the topic, I suspect that SQL is most
efficent when you need to update a large number of records to a consistant
value.

The general concensus that I've heard is that single record access in SQL
is considered quite inefficent... and that native record reads (CHAIN,
READ, READE, etc.) are more efficent.

david

At 05:09 PM 12/15/98 , Mary Koetting wrote:
>When is it efficient  to use SQL within application programs? 
>
>It has been my thinking that if a subset of records can be selected at one
>time, it would be time effective use of SQL but if one and only one record
>is being sought, dynamic access would be faster. 
>
>Any thoughts/opinions on the matter.  Any and all greatly appreciated.  
>+---
>| This is the Midrange System Mailing List!
>| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
>| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
>| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator: david@midrange.com
>+---

--
| Internet: david@midrange.com
| WWW:      http://www.midrange.com/david
|
| ... A man can move mountains, a world can be turned,
| and the greatest of distances easily spanned,
| When the strength that's invested in making a fist
| is transformed into shaking a hand
|
|                       - DMRoth

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---