Re: What's the best alternative to this pl/sql ?

From: Gabriel Gonzalez <no-spam_at_no-spam.com>
Date: Thu, 27 Feb 2003 06:45:19 -0800
Message-ID: <3e5e0928_2@text-west.newsgroups.com>

"Billy Verreynne" <vslabs_at_onwe.co.za> wrote in message news:b3kvp1$d51$1_at_ctb-nnrp2.saix.net...
> Gabriel Gonzalez wrote:
>
> > Otherwise, save yourself some time and create the SQL on the client.
Make
> > sure you use bind variables/parameters and prepared statements so that
at
> > least the parsed queries remain in the cache to speed up performance of
> > repeat SQL statements. It should give you a speed boost anyway.
>
> Sorry, I don't understand this. It sounds like bollocks to me.
>
> How can you say that shifting the code from PL/SQL to something like C++
or
> Delphi or Perl or whatever, will boost speed?

As compared to not using prepared statements, it will... Maybe I dod not make that clear enough. Comparison was uprepared vs prepared client queries, not client vs server queries.

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Thu Feb 27 2003 - 08:45:19 CST