Re: SQR for data extraction

[Vivek Pandian <vp25@OIT.GATECH.EDU>]

I have delt with millions of rows with SQR and things work fine for me. The
main thing which you should concentrate is the SQL part. Take the SQL out
and run it in SQL plus, do a explain plan and tune it before you use it in
SQR. SQR is the simplest and as fast as Pro*C. I have worked on both.

Happy Coding

Regards,
Vivek

At 06:52 PM 10/13/99 , you wrote:
>My company is implementing an online data store and
>data warehouse.  I am responsible for extracting large
>amounts of data from the data store for use in other
>applications.  I thought SQR would work very well for
>this extraction, but have been told by a technical
>specialist that SQR is "primarily a reporting language
>and will have performance problems".  This person
>recommends we use Pro *C instead.  I have compared the
>runtime of SQR with that of PERL in simple data
>extraction purposes and found PERL was not
>significantly quicker.  I am not familiar with Pro *C.
>
>Does anyone have any input?
>
>
>
>
>
>
>=====
>
>__________________________________________________
>Do You Yahoo!?
>Bid and sell for free at http://auctions.yahoo.com
>