Re: SQR for data extraction

[Ray Ontko <rayo@ONTKO.COM>]

Brian,

For a straight extraction to a text file using the
SAME QUERY, I would expect SQR and Pro*C to have
similar peformance if run on the same platform.

To make the comparison as equal as possible, you
should use the "-B" flag on the begin-select
to specify the same array size used in the Pro*C
program.

Pro*C allows you to pre-process a query into a C program
and process the query row-by-row (or array-of-rows
by array-of-rows).  The only performance-related
differences that I'm aware of between SQR and Pro*C
is that SQR uses the "HLI" (OCI) calls to interface
with Oracle, while Pro*C generates a slightly different
set of calls which get to the kernel by different means.
My impression is that these have similar performance
overhead in terms of CPU time, and almost identical
elapsed time characteristics (since most of the work
is done by the kernel).

Your mileage may vary.

Where I've encountered this before, it was generally
is a question of who is more comfortable with what.
If the Pro*C team is responsible for delivering the
services or maintaining the code, then they'll be
inclined to use technology they're familiar with.

Ray

> 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
>

----------------------------------------------------------------------
Ray Ontko       |  Ray Ontko & Co  |  Software Consulting Services
rayo@ontko.com  |  Richmond, In    |  http://www.ontko.com/