X-Cart forums

[Jon]

For those interested we now have an x-cart speed optimization service available. Here's some results from our most recent optimization:

http://www.websitecm.com/images/D/x-cart-speed-optimization-results.gif

[Pyro]

This seems interesting. I notice on your store page you say "You'll see a speed increase √ we guarantee it! If you don't see an improvement in before and after page load times we'll refund your money."

What does your guarantee cover exactly? If the performance technically has an increase, but it is not noticeable at all, would that be covered? For example, the increase in speed is only .00001%. Sure its an increase, but you would be very hard pressed to notice it in real world use.

Either way, good idea for a service.

[Jon]

While it's hard to make a concrete guarantee we're pretty reasonable. Given the methods we use the only way our optimization wouldn't help substantially is if the optimization had already been done.

[iBorg]

Hi Jon, mind sending me more details & pricing for this service? Thanks.

[exsecror]

I know a way you can get those department page render times even lower (especially if they contain products). There's a few bottlenecks in X-Cart's core I discovered (especially with Special Offers enabled since we have up to 1200 defined at any given time). Ours render in less than 0.7 seconds on the new version of our site we're launching in a few weeks. Same goes with the product pages.

[cflsystems]

Originally Posted by exsecror

I know a way you can get those department page render times even lower (especially if they contain products). There's a few bottlenecks in X-Cart's core I discovered (especially with Special Offers enabled since we have up to 1200 defined at any given time). Ours render in less than 0.7 seconds on the new version of our site we're launching in a few weeks. Same goes with the product pages.

You wanna share?

[exsecror]

Originally Posted by cflsystems

You wanna share?

Yeah I'll post the SQL schema and PHP code fixes later this afternoon when I'm done with my other fun projects today (stupid PDFs)

[exsecror]

Jon contact me today as I totally forgot to post the code by accident. Unfortunately further inspection showed a majority of the improvements were actually made to the Special Offers code concerning at that area (sorry for the misleading post :\). In any case here is the code changes I made:

modules/Special_Offers/calculate_prepare.php:

Find:

PHP Code:

$avail_offers = func_get_applicable_offers($products, $customer_info, $provider_for); 


Replace with:

PHP Code:

foreach ($products as $product) {
    $_product_list[] = $product['productid'];
  }

  $_avail_offers = func_get_offers_productid($_product_list);

  if (is_array($_avail_offers)) {
    foreach ($_avail_offers as $_offer) {
      $avail_offers[] = func_get_offer($_offer[0], true, false);
    }
  }
  else {
    $avail_offers = array();
  } 


This drastically improves a good portion of Special Offers response time (especially on the cart)

[exsecror]

Here are some indexes that should exist but don't that cause joins without indexes problems:

CREATE INDEX offers_offer_name_idx USING BTREE(offer_name) ON xcart_offers
CREATE INDEX offers_offer_idx USING BTREE(offerid, offer_avail) ON xcart_offers
CREATE INDEX offers_offer_dates USING BTREE(offer_start, offer_end) ON xcart_offers
CREATE INDEX offer_bonus_params_idx USING BTREE(bonusid,param_id,param_type) ON xcart_offer_bonus_params
CREATE INDEX ccprocessors_processor_idx USING BTREE(processor, use_preauth, has_preauth) ON xcart_ccprocessors
CREATE INDEX ccprocessors_paymentid USING BTREE(paymentid) ON xcart_ccprocessors

[Pyro]

exsecror: Thanks for sharing! Do you happen to have any improvements for the core x-cart?