Speed optimisations

[Matty]

Ive been trying to speed up my game engine, so that when launched it is as fast as possible.

Before I started optimising:

Page load time - 0.014744 seconds.

I started to do the following...

 

• Cleaned up my pages, removed unnecessary pieces of code, deleted pointless line breaks and re-structured some of my work, basically I took the file size down as much as possible. I managed to cut between 7-4KB from each file.
   
  
• I normalized my database, this was pretty time consuming but would be worth it in the long run, whilst normalizing I added the proper indexes to my tables. I also removed half of my fields from this, after re-structuring, i found that most fields i didn't need, or I was using when I really didn't need to.
   
  
• Reduced queries on my pages, made better use of joining tables, which was needed after normalizing my database. This almost cut the amount of queries on my pages by half.

 

My page load timer, now averages out at around : Page load time - 0.000749 seconds. Which is considerably less, I also believe I can make this faster.

Truth be told that most coders should be doing that anyway, I didn't because I wanted to get the main bulk of code coded before I cleaned up. Mccodes' file sizes are pretty small anyway, so if your experience speed issues try re-structuring your database and queries. The moral is that you can improve the speed of your game, without changing server.

[GoldenZero]

Re: Speed optimisations

ya, I was also planning on doing this, but it takes sooooo long, ill do it when I have the time :D

[MaKaVeLi]

Re: Speed optimisations

I agree Matty, you get tons of coders that just "add a new field" to the users table when trying to make new features, blocks etc. Many really need to learn how to create and join tables.