| Index
» Projects
» phpMyEdit
» Forum
» The Software or the Hosting Company |
 |
Topshed
Joined: 04 Nov 2007
Posts: 20
Posted: 2007-12-13 16:08
Back to top
Reply with quote
|
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
| Quote: |
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
| Quote: |
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..
Is my hosting Co. correct, or are they yanking my chain.
Are these sort of problems the norm or is my Hosting Co. 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...
|
michal
Joined: 17 Jun 2003
Posts: 537
Location: Slovakia
Posted: 2007-12-18 09:16
Back to top
Reply with quote
|
there are two sql queries during list mode:
- get the number of records (to make the page count, dropdown box, etc)
- get the records (with limit 20,30). so only the displayed records are transfered from db to php.
what actual error does it show ?
|
Topshed9
Joined: 14 Jan 2008
Posts: 34
Posted: 2008-01-14 02:21
Back to top
Reply with quote
|
Thank you for all the help and suggestions.
It was all very helpful, but in the end my hosting company was also the major problem.
Since changing all my problems have gone away
Rind regards
Roy...
|
|
Post new topic
Reply to topic
|
|
|
|
Login
Registration
Slovak
