[Wolf1994]

Hello!

I need an advice from the experienced MySQL developer.

There's a chess online game. And it has MySQL table with 10.000+ records. These records always in use. Each time any player makes a move - this table affected.

Question. Is it wise to make small size table for current games only? And after the game is over transfer it to huge table and remove from current? Is there a differece between having an "UPDATE / SELECT BY id" table with 100 records and the same table with 10.000?

[End User]

Don't sweat it- 10,000 rows is nothing. I have mySQL tables with over a million (1,000,000) rows in them and they work fine, update quickly, no problems. Seriously, 10K rows is a very small table. I doubt you'd notice any difference in doing updates on tables with 100 rows or 10,000 rows without using a profiler. Most of the cost in doing a query is in setting up the connection and then tearing it down, not in the update, insert, delete, or select activity.

[Wolf1994]

Thank you for help. Question is closed.