database question

[zebdaag]

Hi I made a chess game where the chess pices are saved(in a database) where they are put every time they are moved. To people can play chess against each other over a long period this way.
I worked very well but know the chess game developes it is getting more problems with loading information from the database. So it seems that everytime the database gets updated one more time it's getting more slow to read from is this a commen thing and how can I solve this problem??

this is the link:
http://www.jeugdwerkrozenoord.nl/Schaak/Wit.html

any suggestions??
Thanks in advance!
Zeb

[ShrineDesigns]

if you are using mysql, change the table types from myisam to innodb, innodb preforms better than myisam when you continuously update/delete a table

further information: http://dev.mysql.com/doc/mysql/en/innodb-overview.html

[BeachSide]

So does that mean that I should start using Innodb instead of MyISAM as my db type from now on?

[ShrineDesigns]

depends on your needs or usage i guess, i uses innodb because i can insert, update, and/or delete rows without slowing down any other database queries that may be going on at the same time, for tables that i don't update very often i use myisam