mysql table problem
If I wanna provide a free guestbook service via php+mysql,I have two choices,
- store all message in one database
- create a table for each free user. 开发者_运维知识库
If I have registered 1000 users and 100000 message,
A table have 1500MB VS 1000 tables are 0-3M each ,
which one is faster? and why ? Or better idea?
thanks
One table 1500MB will definitely be better in space & organisation. Because each table creates aditional space overhead.
In short, go with one table. That's the only valid solution. MySQL and other DBMSs are not made for such abuse you want to perform.
精彩评论