Re: Filtering data

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Wed, 10 Oct 2001 21:00:39 +0100
Message-ID: <3bc69182_2@mk-nntp-1.news.uk.worldonline.com>

Agree. Efficiency, robustness, encapsulation, network traffic...

As Sybrand wrote in a different thread (something like) - could you please e-mail _all_ my developer colleagues with this invaluable advice? :-)

Other possible 'commandments' (perhaps 'recommendations'?):

Use format masks for dates wherever possible, rather than rely on defaults Avoid relying on type conversions
Consider 'order by decode' before writing lots of client-side code Bind your variables whenever practicable

All contributions welcome.

Paul

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:ts91t2j6kgvmaf_at_news.demon.nl...
>

<snip>
> One of the first commandments in using Oracle is you should do
*everything*
> on the database side what you *can* do on the database side.
<snip>
>
Received on Wed Oct 10 2001 - 15:00:39 CDT