Topshed Posted December 14, 2007 Share Posted December 14, 2007 Hello, I have been putting in tickets to my Hosting Company because I am getting repeated time out's with this error "phpMyEdit error: could not connect to SQL" Now I am looking at a table of some 10000 records but I am filtering the record set down so the total I am dealing with is rarely above 50 and I am only putting 20 on screen at a time when in edit / update mode typically this is a small sample of my log 14:18 error (first time I decided to log the occurance) 14:22 ended session 16:30 start session 16:38 error 17:10 ended session 19:45 start session 19:52 error 20.00 error 20:02 error 20:18 ended session Also the time taken for the system to update a single record is 6 to 9 seconds every time. The latest reply from my Hosting company is quoted below I tried to go to several do your 512 pages you have and did the same on many but did not face any issues. However You have more then 10000 records being fetched only thing is its not displayed in one page. So these are there somewhere in memory if i am correct. And that will have its own consequences, getting all in one go is not a good way to do on shared hosting where everything is shared. However you can give some suggestion and we shall see what can be done. Now I need some opinions here being new to POHP/mySql.... Is my Hosting Co. correct, or are they yanking my chain. Are these sort of problems the norm or is my Hosting Company Cr*p. I am thinking about changing my Hosting Co. with all that entails IF I can get better results elsewhere Your comments and suggestion would be most welcome Regards & Thanks Roy... Quote Link to comment Share on other sites More sharing options...
Sulman Posted December 14, 2007 Share Posted December 14, 2007 It's hard to say if they are right or wrong. They are claiming that you are in fact fetching all 10,000 rows in a single query yes? Post one of your snippets of code so we can see if this is correct. In my experience the hosts are nornally right and it is me that has done something wrong! Quote Link to comment Share on other sites More sharing options...
Topshed Posted December 15, 2007 Author Share Posted December 15, 2007 Thanks for the reply, I am in fact using PHPMyEdit and I pointed out to my hosting company that The software is very flexible, so I first filter my record set and the resultant list is rarely more than 50 records in size. I only have 20 records on screen at any one time and only the current record on screen when I am updating it. So I update ONE record from a page of 20 from a record set of 50 and the update takes 6 to 9 seconds EVERY time, plus the time outs when I am selecting 1 of 20 to update This does not sound like a memory or sharing problem to me, the numbers involved are far too small I would have thought. But apart from keep telling me to try it now with no visable improvement, statments like that above go unanswered and the timeout errors continue Regards Roy... Quote Link to comment Share on other sites More sharing options...
AndyB Posted December 17, 2007 Share Posted December 17, 2007 I've used phpMyEdit for years on tables larger than yours and never have a responses anywhere near that slow (and I'm on shared hosting). Sounds to me like your server is grossly under-powered or grossly over-loaded. Quote Link to comment Share on other sites More sharing options...
Topshed Posted January 24, 2008 Author Share Posted January 24, 2008 HI, Thanks for all the input, it was my Hosting company, I changed companies and it fixed it Regards Roy 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.