Re: [GENERAL] Table Inheritance / VARCHAR search question

2006-09-24 Thread Simon_Kelly
I would say that splitting the data will work ok if ( and only if ) you can remove some duplication of data and therefore reduce disk usage. If it won't, it'll not really save you anything, and it may increase disk space with the additional db overheads of another set of table meta informatio

Re: [GENERAL] Table Inheritance / VARCHAR search question

2006-09-20 Thread Martijn van Oosterhout
On Tue, Sep 19, 2006 at 02:15:03PM -0400, Jonathan Vanasco wrote: > Hi, > > I'm hoping someone on this list can save me some unnecessary > benchmarking today > a)one table with everything in it > pro: > simple > possible con: > when i had something