WRe: Deadly sins againts database performance/scalability

From: Alkos <azerty_at_nospam.org>
Date: Thu, 27 Nov 2003 10:23:56 +0100
Message-ID: <bq4frd$icm1@news.rd.francetelecom.fr>

"Dusan Bolek" <pagesflames_at_usa.net> a écrit dans le message news: 1e8276d6.0311250803.3cbc43be_at_posting.google.com...
> Hello,
>
> I'm just creating some document how developers should/must not behave
> when dealing with Oracle database. I written down some basic rules and
> came with idea what's the most stupid thing that you can do to your
> database.
> I have two on mind, first one is not using BIND variables and the
> second one is using COMMIT in a loop statement. However, there will be
> more of these.
> So I have question to you here. What's the most stupid, but in real
> world foundable, mistakes in development applications using Oracle
> datatabase?
>
> --
> with regards
>
> Dusan Bolek

Datatypes is an issue I'm constantly dealing with :-((

Using a unproper (is that correct English ?) datatype for column e.g. NUMBER for a date (number of days/seconds elapsed)

VARCHAR2 instead of NUMBER for a numeric

Being unaware of nearly deprecated datatypes and keeping on using them (VARCHAR, RAW) Oversizing variable length datatypes

hth
Alkos Received on Thu Nov 27 2003 - 03:23:56 CST