Re: [GENERAL] What are the consequences of a bad database design (never seen that before !)

2005-04-13 Thread Robert Treat
On Wednesday 13 April 2005 01:21, Jinane Haddad wrote: > Thanx guys for the advices. > > i think i will have to find some "POLITICAL" approach in order to > restructure the existing database, which i am not so good at but worse > trying. Note that even the code is Bad (they are using PHP for a big

Re: [GENERAL] What are the consequences of a bad database design (never seen that before !)

2005-04-12 Thread Robert Treat
On Monday 11 April 2005 05:39, Jinane Haddad wrote: > Hi everyone, > > i just got a new job in a small entreprise and they are using postgres as a > database for their application. I was stupefied cause the database design > is so bad : we can even say it has been done by amateurs. I observed the >

Re: [GENERAL] What are the consequences of a bad database design (never seen that before !)

2005-04-11 Thread Martijn van Oosterhout
On Mon, Apr 11, 2005 at 09:39:13AM +, Jinane Haddad wrote: > My question is with such database, what are the lomg term consequences or > can we determinate them. I know that the querys will become slower, and the > database will grow more quickly ... And a lot of information will not be > tr

[GENERAL] What are the consequences of a bad database design (never seen that before !)

2005-04-11 Thread Jinane Haddad
Hi everyone, i just got a new job in a small entreprise and they are using postgres as a database for their application. I was stupefied cause the database design is so bad : we can even say it has been done by amateurs. I observed the following problems till now: 1- redondancy ( TOO MUCH) 2- M