Post by carollz » Tue Apr 16, 2019 9:24 pm

Hello,

I have a 3.0.3.2 opencart version I use Journal 3 and Lightning module. Have about 13.000 products and my search take about 7-20 seconds to show the products after I press "enter" I looked for extensions but all just do "live ajax search" and seems not improve the search time, there is a easy way to speed it up or you guys know a extension that will for sure speed the search loading time ?

My store its in maintence mode but I can take off so you guy can try it, just let me know

This is killing me, with lightning the product page open in less than 1second and the search takes 20 seconds to show....

Thanks for your time :)
Last edited by carollz on Fri Apr 19, 2019 12:22 am, edited 1 time in total.

Newbie

Posts

Joined
Tue Apr 16, 2019 9:17 pm

Post by IP_CAM » Tue Apr 16, 2019 10:23 pm

Try this on first, to speed up Category Caching:
https://gist.github.com/weismannweb/8ad ... 8d751281b2
Ernie

I am no longer active at the OC Forum, to reach me, contact: jti@jacob.ch
My latest free Opencart LIGHT 1.5.6.5 Source is available on demand: http://www.opencart.li/dark/
900+ FREE OC Extension-Repositories - from OC v.1.5.x up, on the
world's largest OC-related Github Site: https://github.com/IP-CAM
Image


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by letxobnav » Tue Apr 16, 2019 10:38 pm

well, product as well as category pages are easily cached, searches not so much, better look at DB indexes first.

Crystal Light Centrum Taiwan


Active Member

Posts

Joined
Fri Aug 18, 2017 4:35 pm

Post by IP_CAM » Tue Apr 16, 2019 10:45 pm

One could try, if ATOMIX famous DB Indexer still works with OC-3, it's one of
the best tools ever created, to achieve full indexing as well as InnoDB switching.
Ernie
viewtopic.php?f=191&t=157984#p602699

I am no longer active at the OC Forum, to reach me, contact: jti@jacob.ch
My latest free Opencart LIGHT 1.5.6.5 Source is available on demand: http://www.opencart.li/dark/
900+ FREE OC Extension-Repositories - from OC v.1.5.x up, on the
world's largest OC-related Github Site: https://github.com/IP-CAM
Image


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by letxobnav » Wed Apr 17, 2019 11:36 am

Apart from innodb conversion that ATOMIX only adds indexes for columns with "_id" in their name and columns you manually add to the script, better do an additional manual walk-through based on your "where clauses", "on clauses" and sort orders in your queries on those tables.

Crystal Light Centrum Taiwan


Active Member

Posts

Joined
Fri Aug 18, 2017 4:35 pm

Post by thekrotek » Wed Apr 17, 2019 1:21 pm

letxobnav wrote:
Wed Apr 17, 2019 11:36 am
better do an additional manual walk-through based on your "where clauses", "on clauses" and sort orders in your queries on those tables.
No, it's not better than indexing, because indexing is much easier to commence and it GREATLY increases the speed of ALL queries while having zero side effects.

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


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by letxobnav » Wed Apr 17, 2019 1:50 pm

you should read before you reply.

Crystal Light Centrum Taiwan


Active Member

Posts

Joined
Fri Aug 18, 2017 4:35 pm

Post by thekrotek » Wed Apr 17, 2019 2:00 pm

letxobnav wrote:
Wed Apr 17, 2019 1:50 pm
you should read before you reply.
You should think before you post.

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


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by paulfeakins » Wed Apr 17, 2019 5:27 pm

Now now, please play nicely :)

This may solve your issue:
https://www.antropy.co.uk/blog/opencart ... very-slow/

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 carollz » Wed Apr 17, 2019 8:20 pm

Hello thanks for all the answers.

I installed this:
"
Try this on first, to speed up Category Caching:
https://gist.github.com/weismannweb/8ad ... 8d751281b2
Ernie
"
-----------
And I made this:
"
This may solve your issue:
https://www.antropy.co.uk/blog/opencart ... very-slow/
"
When I did this one could not find those tables:

`oc_product_tag`
`oc_url_alias`

so I deleted then and moved on, but just 3 was successful the others ones show this "Note: #1831 Duplicate index" I think that was already indexed, in journal3 panel have a "Database Indexes" on performance tab.

So the search still take 10 seconds or more sadly....

This:
"
One could try, if ATOMIX famous DB Indexer still works with OC-3, it's one of
the best tools ever created, to achieve full indexing as well as InnoDB switching.
Ernie
viewtopic.php?f=191&t=157984#p602699 "

I did not try this because I don't think I have enough experience

Anyone have any suggestions ? Or I should put this in commercial support ?

Thanks again

Newbie

Posts

Joined
Tue Apr 16, 2019 9:17 pm

Post by IP_CAM » Thu Apr 18, 2019 2:15 am

I did not try this because I don't think I have enough experience
Well, it does not require any experience, to upload a PHP File into the Shop Directory,
call it by it's name in the browser, and then click one button first, and then the other
one, after the first button has been doing it's job. :D

But I really wonder, that not one of the Dev's found some free time yet, to confirm,
that it works with latest Version OC ... :'(
Ernie

I am no longer active at the OC Forum, to reach me, contact: jti@jacob.ch
My latest free Opencart LIGHT 1.5.6.5 Source is available on demand: http://www.opencart.li/dark/
900+ FREE OC Extension-Repositories - from OC v.1.5.x up, on the
world's largest OC-related Github Site: https://github.com/IP-CAM
Image


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by carollz » Thu Apr 18, 2019 2:43 am

IP_CAM wrote:
Thu Apr 18, 2019 2:15 am
I did not try this because I don't think I have enough experience
Well, it does not require any experience, to upload a PHP File into the Shop Directory,
call it by it's name in the browser, and then click one button first, and then the other
one, after the first button has been doing it's job. :D

But I really wonder, that not one of the Dev's found some free time yet, to confirm,
that it works with latest Version OC ... :'(
Ernie
I did this now, show the page and apparently was successful, but sadly the slow continues, and not just the search, the filters and change category pages its very slow too, all three situations takes 10 ~20 seconds to show results, I think this is a more complex problem :(

Newbie

Posts

Joined
Tue Apr 16, 2019 9:17 pm

Post by IP_CAM » Thu Apr 18, 2019 3:03 am

Well, as long as no-one can find out, i.E., by checking your Site
on gtmetrix.com, it's more like an esoteric discussion. 8)
Ernie

I am no longer active at the OC Forum, to reach me, contact: jti@jacob.ch
My latest free Opencart LIGHT 1.5.6.5 Source is available on demand: http://www.opencart.li/dark/
900+ FREE OC Extension-Repositories - from OC v.1.5.x up, on the
world's largest OC-related Github Site: https://github.com/IP-CAM
Image


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by carollz » Fri Apr 19, 2019 12:19 am

Hello everyone, the problem was with journal filter and iWatermark, on lightning extension show the diagnosis of every pages, and each one took about 3 seconds to run and a total of 6500 Real queries once I disable the watermark module and journal filter the search show the results in 2 seconds and the number dropped to 60 Real queries! I will contat the isense labs for a solution for watermark extension and I will look for another filter module, you guys recommend one ?

Thanks everyone, I'm sure the solutions you guys offered somehow helped me to speed up my site anyway :D

Newbie

Posts

Joined
Tue Apr 16, 2019 9:17 pm
Who is online

Users browsing this forum: No registered users and 19 guests