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] Link to comment https://forums.phpfreaks.com/topic/189565-return-time-out/ 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. Link to comment https://forums.phpfreaks.com/topic/189565-return-time-out/#findComment-1000575 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] Link to comment https://forums.phpfreaks.com/topic/189565-return-time-out/#findComment-1000582 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. Link to comment https://forums.phpfreaks.com/topic/189565-return-time-out/#findComment-1001266 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.