Re: SQR for data extraction

[Joe Nodeland <jnodeland@DCCNET.COM>]

I have to agree with the technical specialist.

Depending on your definition of 'large amounts of data', SQR can be a poor
choice. Running on Windows NT, I turned a SQR 'program' that took hours to
run, into a Delphi program that did the same queries in 15 minutes.

The best choice is stored procedures in the database that are called by
something like Visual Basic , Delphi, or Pro C.

Second choice is something that has the Oracle db engine embedded in it,
like Pro C.

Third choice is VB or Delphi doing ODBC calls.

Fourth choice is SQR.

----- Original Message -----
From: Brian Speas <speasb@YAHOO.COM>
To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
Sent: Wednesday, October 13, 1999 3:52 PM
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