OpenCart is slow with many categories – 2013 Edition

As an update to my 2012 post on OpenCart being slow with many categories, there have been many discussions, 2 , 3. There have been a few solutions offered, all of which have been rejected by the OpenCart developers for some strange reason.

i don’t believe this. i think you have mis understood something.

you shoudl be using indexes and not making new primary keys!

@ChrisAtomix has released OpenCart Turbo. A run-once script that speeds up your OpenCart store, applying the fixes I discussed in 2012 and few other speed up changes.
I’d recommend running this on any OC site, not just sites that are slow right now.

Author: Kieran Barnes

Kieran is a PHP developer with 15 years commercial experience. Specialist in WordPress, CakePHP, CubeCart and all things PHP.

10 thoughts on “OpenCart is slow with many categories – 2013 Edition”

  1. Just installed OC and loaded over 7,000 products. Site was so slow it actually timed out more often than it came up. Ran ChrisAtomix’s and your engine and index fixes. Ha, comes up in less than a second. I saw the dialog at Github with the OC developers. Talk about closed minds!!!!!

  2. Hi, I am very grateful to have found this information, however I am just concerned about how safe this script is to run on a OC website, I have allot of extensions and hope this wouldn’t break the site, can you please advise how this update will influence my tables and how other extensions would react after this update have run on the tables.
    Best Regards,
    Lloyd

  3. How about if this bombs my site… what would I have to do to recover? I would guess I restore the database from backup?

    Thank you,
    Mike

  4. Hi, my site is running slow. I would like to try on “OpenCart Turbo”. There are 2 steps in the script:

    1. Convert MySQL DB Storage Engine from MyISAM to InnoDB
    2. Add indexes to all foreign keys (columns ending with ‘_id’)

    My not familiar with MySQL DB Storage Engine. Just in case, is there any issue if I would like to revert the setting of MySQL DB Storage Engine from InnoDB to MyISAM later? All I need to do is to run the query below, right?

    ALTER TABLE t1 ENGINE=InnoDB;

    Thank you.

  5. I am trying to use the open cart turbo, it says: “Follow the on screen instructions” but on the second step (Add Database Indexes) it gets stuck in loading loading….. and doesnt does anything,,,, should i only use the first fix (Convert Database Engine), anythings happense if I keep trying to Add Database Indexes?
    thanks a lot for your article! 🙂

  6. Dude, you ROCK and I mean it… RESPECT 🙂 Worked like a charm I must admit that I was lazy enough to pay attention to a such elementary stuff like optimizing DB. Anyhow once again YOU ROCK Dude. 🙂

    Regards.

Leave a Reply

Your email address will not be published. Required fields are marked *