开发者

mysql table problem

If I wanna provide a free guestbook service via php+mysql,I have two choices,

  1. store all message in one database
  2. create a table for each free user.
  3. 开发者_运维知识库

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜