dannster2010 Posted January 23, 2010 Share Posted January 23, 2010 Hi all I'm asking the Admin CP of my site to pull data from my MySQL database but because of the amount of data it's taking a while (10-15 mins a time to return the data I request). I've attached a screen shot of it loading and it stays in this state for 10-15 mins. I'd like to, if possible, speed this process up somehow? Please can someone tell me if it is possible and how to go about doing it please? phpMyAdmin - 2.11.9.5 MySQL client version: 4.1.22 Server version: 5.0.67-community-log Cheers, Dan [attachment deleted by admin] Quote Link to comment Share on other sites More sharing options...
agrant Posted January 23, 2010 Share Posted January 23, 2010 what's your sql code look like for this? could be a number of issues... missing joins, missing indexes, etc. Quote Link to comment Share on other sites More sharing options...
dannster2010 Posted January 23, 2010 Author Share Posted January 23, 2010 I've attached a screen capture of the data it pulls, I hope this is what you're asking for? I must stress that the guy who normally works on this is away for a few weeks and I have close to no experience with this stuff so apologies in advance. [attachment deleted by admin] Quote Link to comment Share on other sites More sharing options...
fenway Posted January 25, 2010 Share Posted January 25, 2010 We're going to need at least the query itself, and the EXPLAIN output. Quote Link to comment 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.