[PHP-MSSQL] Need help..

[Sv@ike]

hello,
i need some help/advices withy rankings in site.
I inserted rankings in my site, and to get info site every time connects to mssql, that makes server laggy a little bit.. Maby i can set some settings in php or apache to make less connections to database? The best thning it would be script that would connect to mssql every 5 minutes etc and would update info in site.. anyone got idea how to make this?

thx

 

[FragFrog]

Use smarty and turn on caching. Smarty : Template Engine

Or write some damn decent functions, a simple select query shouldn't hog your resources.

 

[Sv@ike]

how to use smarty chaching corectly?

just enable:

var $caching         =  1;

and that is all? (or should i use cache in cache file ?)

i mean do i need to insert someting to php script

(sry, i am noob trying to learn...)

 

[FragFrog]

What do YOU think? Now go and actually READ the link I posted.

 

[username1]

Do note that SQL supports queries that are executed at a specific time.