Re: Deadly sins againts database performance/scalability

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 26 Nov 2003 09:08:45 -0800
Message-ID: <1069866554.790509@yasure>

Connor McDonald wrote:

> Dusan Bolek wrote:
> 

>>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

> 
> 
> Only one...
> 
> People on a project who aren't 
> - passionate about what they do.  
> - keen to learn
> 
> Everything else falls into place if you can satisfy the above

I'll add one more ...

Developers that seem incapable of understanding the basics of normalization and data integrity.

Again, today, I've been called into look at a database in which it is impossible to connect related events.

Example:

1. Cases have a case number
2. Citations have a case number and a citation number
3. Fees paid for citations have a case number and a payment number

If you can't see what's wrong ... you're part of the problem. ;-)

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Wed Nov 26 2003 - 11:08:45 CST