Help Sql Queries In Fixed Times

[Gam3Master]

So I added custom community board on my own, added top pvp, pk , grandboss and raidboss statistics. top pvp-pk uses sql query to get information and show result on board. and as i know on live aerver it will cause problems. Can you tell me how to make information update every 30 minutes and not any time people opens board.

[vampir]

thats copy paste from my ranking page: http://pastebin.com/XCV6qzGz

[Sdw]

Just cache the data and save from time to time

[Gam3Master]

any exmple or manual?

[Elfo]

It won't cause problems but in this case go for premature optimization and cache the data as Sdw said.

 

Basically run a task which will populate your vars, Lists, Maps or whatever you use and give it an interval of 30 minutes.

[xxdem]

  On 6/5/2016 at 6:21 PM, .Elfocrash said:

It won't cause problems but in this case go for premature optimization and cache the data as Sdw said.

 

Basically run a task which will populate your vars, Lists, Maps or whatever you use and give it an interval of 30 minutes.

 

 

I cache the whole HTM I find it easier faster and ofc dumber

[Elfo]

  On 6/5/2016 at 7:08 PM, xxdem said:

I cache the whole HTM I find it easier faster and ofc dumber

Yeah the website way. It is actually pretty smart.

[xxdem]

  On 6/5/2016 at 7:14 PM, .Elfocrash said:

Yeah the website way. It is actually pretty smart.

 

You basically avoid all the String concatenation when the player requests the HTM, and you just send it ready to go, the code is uglier ofc but its a good shortcut