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
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