Re: SQR as data transfer tool

[Eric Dimick Eastman <erice@ONTKO.COM>]

Redleaf,

My highly unscientific experience shows that as far as performance there
is virtually no difference.  I have gotten better than 110 records per
second on several data load programs using SQR.  These programs did some
parsing, manipulation and key lookups in addition to loading the
records.  The cost of executing the SQL statements total swamps the time
spent processing the data in the program.  SQR also has a few features
like "load-lookup" that are highly efficient and easy to use.

The big difference comes in programming and maintenance time.  C is a
pain.  Well written SQR programs read like english and are quick to
write compared to C.

Unless you have to calculate 500 digits of pi between each record I'd
use SQR.

Good luck,
Eric

"redleaf@mindspring.com" wrote:
>
> The company I am currently working for may be considering using SQR
> instead of C as a tool for data transfers from source tables to target
> tables. Does anyone have any thoughts and/or statistics about the
> efficiency of SQR vs. C for this? Has anyone performed any tests along
> these lines?

--
------------------------------------------------------------------------
Eric Dimick Eastman  | To match what we [humans] can do, there would
Ray Ontko & Co.      | have to 3 billion of them [computers] . . .
erice@ontko.com      | wired together, . . . talking incessantly.
http://www.ontko.com |           Lewis Thomas, The Lives of a Cell 1974