JonnySnip3r Posted August 7, 2011 Share Posted August 7, 2011 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!! Quote Link to comment https://forums.phpfreaks.com/topic/244076-php-sql-speed-question/ Share on other sites More sharing options...
trq Posted August 7, 2011 Share Posted August 7, 2011 19 - 20 is nothing. We have applications where I work that make literally hundreds without issue. Quote Link to comment https://forums.phpfreaks.com/topic/244076-php-sql-speed-question/#findComment-1253516 Share on other sites More sharing options...
JonnySnip3r Posted August 7, 2011 Author Share Posted August 7, 2011 Thanks dude really appreciate that Quote Link to comment https://forums.phpfreaks.com/topic/244076-php-sql-speed-question/#findComment-1253518 Share on other sites More sharing options...
Philip Posted August 7, 2011 Share Posted August 7, 2011 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. Quote Link to comment https://forums.phpfreaks.com/topic/244076-php-sql-speed-question/#findComment-1253587 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.