Re: SQR for data extraction

[Rick Creel <Rick_Creel@AONCONS.COM>]

I use SQR for data extraction on a daily basis and it works quite well.  I have
no problems with it at all.  The quantity of data being extracted is not large
my any means, but I personally can't see what volume would have to do with
whether or not SQR would work efficiently.

My vote would be... if you know SQR and are comfortable with using it, and you
are the person responsible for on-going support of this particular process...
then I would use SQR.






Brian Speas <speasb@YAHOO.COM> on 10/13/99 06:52:40 PM

Please respond to SQR-USERS@list.iex.net

To:   Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
cc:    (bcc: Rick Creel/IT/Aon Consulting)
Subject:  SQR for data extraction




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