Re: X-Cart Speed Optimization Service
 

You'd have to be a bit more specific as to which portion of the core as I have large numbers of code changes that have been made.

Re: X-Cart Speed Optimization Service
 

I have not yet launched my site, so I do not know exactly where it will bottleneck yet; however, I have a large number of products and categories. Also, I plan to have a highly active newsletter system. If you could share anything that you think would yield the best results with that knowledge or any tips that you think would improve any x-cart, I would greatly appreciate it.

Re: X-Cart Speed Optimization Service
 

Unfortunately I cannot help you much on the newsletter aspect as we handle all our email campaigns via CampaignerPro. As for categories and products those are mostly SQL bottlenecks mainly due to bad SQL joins (or missing indexes). Your best bet is to go into top.inc.php and set the following:


This will help you identify where a large number of bottlenecks are (anything in red for memory or time means something is wrong). The backtrace will let you know where exactly in the code it's at (these are available in the table's row for that entry so you'll need to use firebug inspection to see it)

Re: X-Cart Speed Optimization Service
 

Thanks for the tip. Do you happen to have any experience with x-affiliate?

Re: X-Cart Speed Optimization Service
 

Unfortunately I do not, all our affiliate tracking is also handled by a 3rd party called LinkConnector.

Re: X-Cart Speed Optimization Service
 

Ok, thanks. Just to be sure, the two 3rd party groups you referred to are http://www.campaigner.com and http://www.linkconnector.com, correct?

Re: X-Cart Speed Optimization Service
 

Yup that is correct