SQR Run times vs C

[Steve Hall <srh@CONVOY.COM>]

I remember an engagement where this fellow claimed C++ was 'faster' than
SQR, even running over the network!

The point is: make certain to run SQL-intensive programs on the server, to
cut down on network traffic. Network traffic is far and away the biggest
performance-blocker.

The next biggest performance-blocker is bad SQL. Good SQL is efficient and
uses indexes.

Compiled language vs. scripted language is a red herring. It just doesnt
make any difference. We are basically sending SQL statements to ORACLE (or
whatever), and waiting for the results to arrive in thousands of little
packets.

The only difference is compiled languages (C) require the poor programmer to
crank up the compiler for every teeny tiny little change.

Development time takes forever and the whole enterprise becomes boring and a
waste of time.

!Script Languages, Si!
!Compiled Languages, No!