Re: SQR for data extraction

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

Another thing to add. If its really huge and if you do not know much about
database have your dba by your side and run your SQR, he will tell you what
to do to increase performance or he might tune the database to your need.
Optimizing!!!!!!!!!!!!!!!!!!!! is the keyword to success. Some terms which
you will come across which can be solved easily.
Unable to extend rollback segment,
Maximum number of locks exceeded etc

I have a lot of statistics made with which i can say SQR is far more better.
Never use attractive front end tools(vb,pb,delphi) for your data intensive
processing.
Always use recovery procedure inside your SQR. Try running those SQR's in
the Server than in client.

If you need specific assist write to me.

Regards,
Vivek

At 08:53 AM 10/14/99 , you wrote:
>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
>>
>