MySQL More Tables or More Rows

Posted by Pez Cuckow on Stack Overflow See other posts from Stack Overflow or by Pez Cuckow
Published on 2010-05-27T18:45:35Z Indexed on 2010/05/27 19:01 UTC
Read the original article Hit count: 250

Filed under:
|
|

I am working on a game that I am going to open to the public to have on their game. The game stores lots of information (about 300 rows) per website and spends a lot of time updating values within this MySQL database.

Is it better (faster/efficient) to add a new table for every website or to just have 1000's of rows in one table and add a column "website_id" or similar?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about efficiency