[PHP] Re: Data duplication in databases

2001-08-29 Thread james
Julian, I am not aware of any databases smart enough to decide to create references for rows whose data is identical to an existing row. If the duplicate data is creating resource issues, there's a couple things that you can do to eliminate the duplicate data. Probably the easiest would be, in

Re: [PHP] Re: Data duplication in databases

2001-08-29 Thread Julian Wood
The only problem is detecting that the data is identical in the first place. If I have to do a select with 7 AND statements to see if I have identical data, I'm going to take a huge performance hit. I was hoping this had been done at a very low level, but it doesn't look like it. Maybe it's