/    Sign up×
Community /Pin to ProfileBookmark

database question

Copy linkTweet thisAlerts:
Feb 13.2005

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:
[url]http://www.jeugdwerkrozenoord.nl/Schaak/Wit.html[/url]

any suggestions??
Thanks in advance!
Zeb

to post a comment
PHP

3 Comments(s) ↴

Copy linkTweet thisAlerts:
@ShrineDesignsFeb 14.2005 — 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
Copy linkTweet thisAlerts:
@BeachSideFeb 14.2005 — So does that mean that I should start using Innodb instead of MyISAM as my db type from now on?
Copy linkTweet thisAlerts:
@ShrineDesignsFeb 14.2005 — 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
×

Success!

Help @zebdaag spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 5.17,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...