Post by parkookk » Tue Jul 09, 2019 11:37 pm

Hi, I have other domains with OpenCart and all is fine, however, I have installed OC3.0.3.1 last month on bachatakiss.co.uk and only have a few pages with only one product. Recently I wanted to export the bachatakiss.com database from phpMyAdmin and it was very slow, so I asked my shared hosting company and got the below response. I would appreciate if someone can help me out to speed up the database? Many Thanks
====================
This seems to be a problem related with only the database "BachataKiss_DataBaseName" where there are lots of rows which must be exported:

oc62_session 7,311
oc62_google_base_category 5,427
oc40_zone 4,108
oc62_zone 4,108

New member

Posts

Joined
Thu Jan 17, 2013 11:56 pm
Location - london

Post by thekrotek » Tue Jul 09, 2019 11:43 pm

Zone's table is definitely not an issue. Try to clean the sessions table and see, how it works. But in general 5-6K rows isn't that much.

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com


User avatar
Expert Member
Online

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by letxobnav » Wed Jul 10, 2019 9:25 am

slow is an opinion, so quantify what you consider slow.

Crystal Light Centrum Taiwan
“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.


Active Member

Posts

Joined
Fri Aug 18, 2017 4:35 pm
Location - Taiwan

Post by paulfeakins » Wed Jul 10, 2019 5:16 pm

A lot of shared hosts deliberately slow down things like that for performance reasons.

You should use this instead of phpMyAdmin, it's super fast: https://www.adminer.org/

For quick, professional OpenCart support please email info@antropy.co.uk


User avatar
Expert Member

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - Reigate, Surrey, United Kingdom

Post by ostechnologies » Wed Jul 10, 2019 6:33 pm

Try to export the database from the terminal.

Opencart Expert | sales[at]ost.agency
Skype - manish.osuniverse | Gtalk - manishmt

Extensions for Opencart @ https://www.ost.agency/product/product- ... extensions
ost.agency - ecommerce website design, development and digital company


User avatar
Active Member

Posts

Joined
Mon Apr 06, 2015 1:30 pm

Post by thekrotek » Wed Jul 10, 2019 6:39 pm

paulfeakins wrote:
Wed Jul 10, 2019 5:16 pm
You should use this instead of phpMyAdmin, it's super fast: https://www.adminer.org/
And super ugly :-)

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com


User avatar
Expert Member
Online

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by paulfeakins » Thu Jul 11, 2019 5:48 pm

thekrotek wrote:
Wed Jul 10, 2019 6:39 pm
And super ugly :-)
No way! It's beautiful when you experience how fast and efficient it is!

For quick, professional OpenCart support please email info@antropy.co.uk


User avatar
Expert Member

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - Reigate, Surrey, United Kingdom

Post by thekrotek » Thu Jul 11, 2019 5:53 pm

paulfeakins wrote:
Thu Jul 11, 2019 5:48 pm
No way! It's beautiful when you experience how fast and efficient it is!
Tried it and couldn't stand the ugliness and over all "blast from the past" feeling. Still using PHPMyAdmin :-)

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com


User avatar
Expert Member
Online

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by parkookk » Fri Jul 19, 2019 10:35 pm

letxobnav wrote:
Wed Jul 10, 2019 9:25 am
slow is an opinion, so quantify what you consider slow.
It takes around 1-5 minutes for a 1.96 MB database!!!

New member

Posts

Joined
Thu Jan 17, 2013 11:56 pm
Location - london

Post by parkookk » Fri Jul 19, 2019 10:39 pm

ostechnologies wrote:
Wed Jul 10, 2019 6:33 pm
Try to export the database from the terminal.
I use to export all my databases from the terminal in the past, however, when I needed to import them after a database error it didn't work. I was lucky I had another one exported from phpmyadmin which worked.

New member

Posts

Joined
Thu Jan 17, 2013 11:56 pm
Location - london

Post by letxobnav » Sat Jul 20, 2019 5:28 am


Crystal Light Centrum Taiwan
“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.


Active Member

Posts

Joined
Fri Aug 18, 2017 4:35 pm
Location - Taiwan
Who is online

Users browsing this forum: thekrotek and 42 guests