171 reputation
3
bio website
location
age
visits member for 2 years, 11 months
seen Jul 30 '13 at 23:06

Jul
9
awarded  Editor
Jul
9
revised Should we add extra 5 columns or build a separate table?
extended with details
Jul
5
comment Should we add extra 5 columns or build a separate table?
Add these details to your original question so other people are aware of them too; you may get better answers. Also, try to describe what you're modeling; eg: what is "association", why is it currently related to "gps"? what is "alert" and why is it related to "association"? What are the 5 columns related to? Do they have anything to do with "association"?
Jul
4
comment Should we add extra 5 columns or build a separate table?
No. What I'm saying is that it depends. Put the columns where they belong (probably another table, but it may also be two other tables). You haven't described what you're trying to model; therefore it's impossible to make a decision of where the columns should be. Please read on database modeling & design...
Jul
3
comment Should we add extra 5 columns or build a separate table?
Not necessarily. If the indexes and queries are properly set up, and if the tables you are joining don't have millions of rows each, it doesn't need to be heavy. You should always start with a normalized database, and denormalize only when needed, where needed, making very conscious decisions on why you are denormalizing each specific part of the database. However, it might be better not to touch now that table with 35 columns, given the dependencies you may have all over. But take a good start with those 5 new columns.
Jul
1
awarded  Teacher
Jun
30
comment Dynamic contacts database
I think your keyboard is missing the keys for period and comma...
Jun
30
answered database schema for a product with multiple categories and hierarchical categories
Jun
30
answered Should we add extra 5 columns or build a separate table?
Jun
30
comment View metadata refresh in MySQL
>Rolando, what's that "\G" at the end of each query you wrote?
Jun
30
awarded  Supporter
Jun
30
comment Is using multiple foreign keys separated by commas wrong, and if so, why?
fire that outsourced team right away before they do any more harm... (-_-)