Page 1 of 1

mySQL Question

PostPosted: Mon Mar 26, 2012 10:07 am
by wisni1rr
I am using xataface and am having several complications in senarious involving 1:1 relationships. I understand that this feature will be available in v2.0 when it is relased. My question is how practical would it be to try to combine my 1:1 relations into a single table? The datatypes are mostly simple fields such as varchar, int, decimal, and enum with the execption of one blob field.

Combining these tables could result in approx 150 fields in a table. I know that this is generally not considered to be normalized. My question is can mySQL handle such a load? My tables are InnoDB and I could potentially have approx 5,000 records.

Using Xataface, it seems it would be easier to cunstruct as a single table. I really enjoy using this framework! Keep up the great work. This is BY FAR the easier framework that I have ever used!

Thanks for all your help!

Re: mySQL Question

PostPosted: Mon Mar 26, 2012 11:00 am
by shannah
Database design is up to you. There are trade-offs between a normalized structure and an unnormalized structure. More normalized is generally better for data integrity, but may be less convenient to work with sometimes.

As far as load goes, MySQL is a work horse. I have databases with tens of millions of rows that run fine (although those ones require more careful consideration of queries and indexes).

-Steve

Re: mySQL Question

PostPosted: Mon Mar 26, 2012 12:00 pm
by wisni1rr
Cool. Thanks Steve!