OpenCart Community

Search found 7 matches

Page 1 of 1

Search found 7 matches

Re: Performance tuning tips

rich06 wrote:
In my case the products table is around 8.5 million rows now and sphinx performs really well so it is definitely worth using if you have a large product table.

Make that 12.5 million rows now....

Rich

Jump to post

Sat Sep 10, 2011 1:13 am
Replies 18
Views 9434

rich06

Hi Rich Are there any news/updates about your performance optimizing stuff? Is it possible to see how you integrated sphinx (or available as extension?). Just curious. bye Marcel Hi Marcel Well I downloaded and compiled Sphinx v0.9.9 http://sphinxsearch.com/downloads/release/ and I also installed t...

Jump to post

Sun Mar 20, 2011 1:01 am
Replies 18
Views 9434

rich06

Re: Detailed Product Purchased Report! (please add to open c

Shouldn't the SQL where clause on the order status be this:- WHERE o.order_status_id IN (1,2,3,5) instead of this:- WHERE o.order_status_id > '0' (admin/model/report/purchased.php) The latter will included cancelled, refunded etc orders right - or have I misunderstood? just my €0.02c Rich

Jump to post

Sun Oct 17, 2010 8:56 pm
Replies 15
Views 7543

rich06

Re: Performance tuning tips

Just an update on this OC install if anyone's interested... :) Once my data load process had finished the product/product_description tables have 7.1m records (a few million less than originally anticipated thankfully). Naturally the code/database hit many brick walls with this volume of data and I ...

Jump to post

Thu Sep 16, 2010 6:17 am
Replies 18
Views 9434

rich06

Re: Performance tuning tips

Thanks for the tips everyone..! The site will be an online bookstore and the client has subscribed to a data feed service that catalogs every book title published in the US and UK -- I have prepared a multi threaded database load script when the supplier provided some sample data but the real data w...

Jump to post

Mon Aug 09, 2010 5:43 pm
Replies 18
Views 9434

rich06

Performance tuning tips

Hi All I am preparing a OC (1.4.8) site that will have around 3-4000 categories and around 12 million products... just wondering if anyone has a similarly sized site and what (if any) performance issues were encountered...? FWIW I have already some issues with the categories (which are quite heavily...

Jump to post