OpenCart Community

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

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

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

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

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.

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.

you should read before you reply.

letxobnav wrote: ↑

Wed Apr 17, 2019 1:50 pm

you should read before you reply.

You should think before you post.

Now now, please play nicely

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

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

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.

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

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.

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

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.
Ernie

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

Thanks

Thanks a loT