PHP & SQL Speed Question

[JonnySnip3r]

Hi Guys,

 

This is just a quick question. I have been doing php for a fair while now, but up until now I have never really made a query intense php application. Im currently creating a app that makes allot of database requests each time the page is loaded (as the stats needed need to be updated pretty much all the time) I'm using OOP techniques and refining my queries to only select info needed etc. I'd say it makes around 13 request each page load but some of the methods inside a class make a couple more requests + calculations etc. all in all around 19 - 20.

 

Other than looking into database caching techniques should I be doing anything else to help minimise the server load? Or am I being paranoid? I' closing connections when finishing with queries etc.

 

BTW to clear confusion i'm not yet using db caching techniques.

 

Any help will be much appreciated. Thanks!!

[trq]

19 - 20 is nothing. We have applications where I work that make literally hundreds without issue.

[JonnySnip3r]

Thanks dude really appreciate that

[Philip]

19 - 20 is nothing. We have applications where I work that make literally hundreds without issue.

 

I'm guessing the servers are optimized to handle this & the queries are also optimized.