It is currently Thu Mar 28, 2024 2:29 am


The forum is READ ONLY. Please direct any future discussions to our Facebook page


 Page 1 of 1 [ 1 post ] 
Author Message
 Post subject: Database Update Program
PostPosted: Thu Oct 02, 2008 9:57 pm 
Developer
Developer
User avatar

Joined: Wed Feb 19, 2003 6:07 pm
Posts: 2930
I made a mistake in the database schema files. (Yes, I am human.)

Certain database tables use LONGTEXT fields and this can cause a the database to become quite slow over time with massive overhead. This also increases the CPU load.

I have included an update-database.zip file to correct this problem. Un-zip the file, upload the single PHP program, execute it and then delete the file.

This will convert all tables that use LONGTEXT fields to TEXT fields or VARCHAR fields based upon MySql version. This will reduce the overhead problem. A game reset is NOT needed.

We will also be making another update to the game that will take advantage of the VARCHAR update in MySql 5.0.3 and higher. These newer versions of MySql increase the maximum number from 255 to 65k characters. We will be checking on the version of MySql and using VARCHAR instead of TEXT fields in future versions. By using VARCHAR the database will be faster and use less CPU.


Attachments:
File comment: Update Database PHP File
update-database.zip [1.27 KiB]
Downloaded 1048 times

_________________
PJ's Annoyingly Useless Blog
ADOdb Lite
Template Lite
Offline
 Profile  
 
Display posts from previous:  Sort by  
 Page 1 of 1 [ 1 post ] 


Who is online

Users browsing this forum: No registered users and 7 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

cron