Home » Forum Home » Development

Topic: Game database performance increase
Replies: 0   Views: 25,464   Pages: 1  

Search Forum

Back to Topic List Topics: [ Previous | Next ]
Replies: 0   Views: 25,464   Pages: 1  
dweebo

Posts: 1,032
Registered: Dec 16, 2001
From: Powell, OH
Age: 37
Home page
Game database performance increase
Posted: Sep 24, 2007, 5:36 PM

This weekend I made a few changes to the game database to greatly increase the speed of game searches. The positions most affected are the early ones. I noticed searching for K10,L9,N10 took forever, like 90 seconds.

After a few changes to the database indexes it is almost immediate now! It added another 200 mb's of data to the database to do it, but space isn't a big issue right now.

The improvements should help all results but if you are finding some searches are taking a long time, send me the specifics and I'll take a look. One thing that I know is very slow is to search for a position and choose to only search pente.org games, don't do it I will try to fix that someday.

-dweebo

Pente Rocks!
Replies: 0   Views: 25,464   Pages: 1  
Back to Topic List
Topics: [ Previous | Next ]


Powered by Jive Software