the idea to allow diffrent properties to each object or to future objects: casino, bank.
Q: will it be better to design a DWH style table for each object
where property will be a column ? therefore reading one table for each object
OR will it be better to create this table module for future properties ?
it's more question of using alter table add column to add new properties, or
use this module, where i can simply insert new object and add it's properties...
Thanks for the quick reply.
It's a matter of working with multiply tables vs. working with one DWH style table - which will be faster. Assuming my data is most likely to be static
(alot more reading then updates).
But still the data will not consist of too many records, each one not more than 1k value records.
But then everytime new property will appear, i would need to add a new column. and everytime a new object added, means more tables.
I am more worried about performance, when reading from multiple tables (although indexed), then reading a full table for each object.