MySQL issues
- Thread starter denizx13
- Start date
- Status
- Messages
- 5,609
- Reaction score
- 250
- Points
- 63
Where are you seeing an issue?
I don't believe outgoing SQL connections are allowed through the firewall, but I had only experienced that years ago.
PHPMyAdmin isn't going to help as your user credentials will not allow you to override the system limits.
I don't believe outgoing SQL connections are allowed through the firewall, but I had only experienced that years ago.
PHPMyAdmin isn't going to help as your user credentials will not allow you to override the system limits.
Thank You for your response. I know the firewall issue because I tried to use my own MySQL server here but could not connect.
Having said that the issue is sql queries are very slow. I am starting a new site that has many products and sorting them to serve on the website takes long time and visitors dont wait so no sales. I am trying to speed up the response time. I indexed most tables increased speed many folds but still slow .
with PHPMyAdmin I can only do so much.
Again thanks for your reply.
Having said that the issue is sql queries are very slow. I am starting a new site that has many products and sorting them to serve on the website takes long time and visitors dont wait so no sales. I am trying to speed up the response time. I indexed most tables increased speed many folds but still slow .
with PHPMyAdmin I can only do so much.
Again thanks for your reply.
- Messages
- 5,609
- Reaction score
- 250
- Points
- 63
Your website looks pretty quick to me, assuming I'm looking at the right thing. Have you tried benchmarking a query and making sure it's not something else? I get these JS errors on your site:
GET http://deniz.x10host.com/w.sharethis.com/button/buttons.js net::ERR_ABORTED 404 (Not Found)
(index):964 GET http://deniz.x10host.com/s.sharethis.com/loader.js net::ERR_ABORTED 404 (Not Found)
(index):963 GET http://deniz.x10host.com/w.sharethis.com/button/buttons.js net::ERR_ABORTED 404 (Not Found)
(index):964 GET http://deniz.x10host.com/s.sharethis.com/loader.js net::ERR_ABORTED 404 (Not Found)
(index):967 Uncaught ReferenceError: sharethis is not defined
at (index):967
(anonymous) @ (index):967
Your whole page loads in 53ms for me, except for the broken links.
GET http://deniz.x10host.com/w.sharethis.com/button/buttons.js net::ERR_ABORTED 404 (Not Found)
(index):964 GET http://deniz.x10host.com/s.sharethis.com/loader.js net::ERR_ABORTED 404 (Not Found)
(index):963 GET http://deniz.x10host.com/w.sharethis.com/button/buttons.js net::ERR_ABORTED 404 (Not Found)
(index):964 GET http://deniz.x10host.com/s.sharethis.com/loader.js net::ERR_ABORTED 404 (Not Found)
(index):967 Uncaught ReferenceError: sharethis is not defined
at (index):967
(anonymous) @ (index):967
Your whole page loads in 53ms for me, except for the broken links.
That is the old site. All html. I dont know why it is serving that.
New site is www.deniz.com it is PHP and MySQL. Open cart site.
That is the slow one.
New site is www.deniz.com it is PHP and MySQL. Open cart site.
That is the slow one.
- Messages
- 5,609
- Reaction score
- 250
- Points
- 63
Looking at some OpenCart threads, there are some settings that can affect it, and some known bugs. It's an older post, but maybe worth looking at.
https://forum.opencart.com/viewtopic.php?t=200411
https://forum.opencart.com/viewtopic.php?t=200411
- Messages
- 5,609
- Reaction score
- 250
- Points
- 63
- Status