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 7670
Re: Performance tuning tips

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 7670
Re: Detailed Product Purchased Report! (please add to open c

Shouldn't the SQL where clause on the order status be this:-

Code: Select all

WHERE o.order_status_id IN (1,2,3,5)
instead of this:-

Code: Select all

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 5603
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 7670
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 7670
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
  • Sun Aug 08, 2010 7:11 am
  • Replies 18
  • Views 7670
Re: [MOD] - Remove All Demo Data

Shouldn't oc_url_alias also be added to the list?

Rich

Jump to post
  • Fri Jul 02, 2010 11:01 pm
  • Replies 63
  • Views 197923

Page 1 of 1

Search found 7 matches