I'm more interested in how and why it would depend rather than the
actual answer.
In evenly distributed systems you should do x/y because ..... If your
data is not evenly distributed then you should...
Thanks
On 11/20/11 12:57 AM, Michel Segel wrote:
Mark,
Simple answer ... it depends... ;-)
Longer answer...
What's your use case? What's your access pattern? Is the type of data, in this
case evenly distributed in terms of size?
Sent from a remote device. Please excuse any typos...
Mike Segel
On Nov 18, 2011, at 3:29 PM, Mark<[email protected]> wrote:
Is it better to have many smaller tables are one larger table? For example if
we wanted to store user action logs we could do either of the following:
Multiple tables:
- SearchLog
- PageViewLog
- LoginLog
or
One table:
- ActionLog where the key could be a concatenation of the action type ie
(search, pageview, login)
Any ideas? Are there any performance considerations on having multiple smaller
tables?
Thanks
