X-Cart:Performance tips - Revision history

Mouse at 13:45, 22 July 2020

2020-07-22T13:45:22Z

Dohtur: /* Use Content Delivery Networks like MaxCDN */

2017-11-30T10:21:25Z

‎Use Content Delivery Networks like MaxCDN

Dohtur at 09:37, 30 November 2017

2017-11-30T09:37:10Z

Dohtur: /* Cron-based scheduling of SQL table optimization tasks for X-Cart versions 4.6.0 and later */

2013-06-05T10:42:04Z

‎Cron-based scheduling of SQL table optimization tasks for X-Cart versions 4.6.0 and later

Dohtur: /* Optimizing SQL tables */

2013-06-05T10:41:01Z

‎Optimizing SQL tables

Dohtur: /* Cron-based scheduling of SQL table optimization tasks for X-Cart versions 4.6.0 and later */

2013-06-05T10:38:39Z

‎Cron-based scheduling of SQL table optimization tasks for X-Cart versions 4.6.0 and later

Dohtur: /* Cron-based scheduling of SQL table optimization tasks for X-Cart versions 4.6.0 and later */

2013-06-05T10:37:18Z

‎Cron-based scheduling of SQL table optimization tasks for X-Cart versions 4.6.0 and later

Dohtur: /* Cron-based scheduling of SQL table optimization tasks for X-Cart versions 4.6.0 and later */

2013-06-05T10:09:54Z

‎Cron-based scheduling of SQL table optimization tasks for X-Cart versions 4.6.0 and later

Dohtur: /* Optimizing SQL tables */

2013-06-05T10:08:43Z

‎Optimizing SQL tables

Seyfin: /* Miscellaneous */

2013-02-22T05:59:06Z

‎Miscellaneous

@@ Line 187: / Line 187: @@
 === Installing Zend Optimizer===
-[http://www.zend.com/ Zend Optimizer] is a free application that runs the files encoded by the Zend Encoder and Zend SafeGuard Suite, while enhancing the running speed of PHP applications. Many scripts require that you have Zend Optimizer installed, so can run them on your server while decrypting and running them on-the-fly while increasing the runtime performance.
+[https://www.zend.com/ Zend Optimizer] is a free application that runs the files encoded by the Zend Encoder and Zend SafeGuard Suite, while enhancing the running speed of PHP applications. Many scripts require that you have Zend Optimizer installed, so can run them on your server while decrypting and running them on-the-fly while increasing the runtime performance.
 === Install additional Apache modules (optional)  ===
@@ Line 197: / Line 197: @@
 A more graceful solution is to use mod_gzip, one of the many additional modules available for Apache. We consider it to be one of the overlooked gems for designing a high-performance Web server. This module compresses files of certain types after they've been processed by all the other Apache's modules and before they are sent to the browser. The compressed data reduces the number of bytes transferred to the browser, without any loss in the structure or content of the original, uncompressed document.
-You may ask your hosting administrators to install the necessary compression module: <tt>[http://httpd.apache.org/docs/2.0/mod/mod_deflate.html mod_deflate]</tt> (Apache 2.0.x) or <tt>[http://sourceforge.net/projects/mod-gzip/ mod_gzip]</tt> (Apache 1.3.x).
+You may ask your hosting administrators to install the necessary compression module: <tt>[https://httpd.apache.org/docs/2.0/mod/mod_deflate.html mod_deflate]</tt> (Apache 2.0.x) or <tt>[https://sourceforge.net/projects/mod-gzip/ mod_gzip]</tt> (Apache 1.3.x).
 === Slow down SE crawlers===
@@ Line 214: / Line 214: @@
 (Thank you, Jon, for contributing articles for X-Cart Knowledge Base!)
-What is MaxCDN  - [http://marketplace.x-cart.com/Marketing/MaxCDN-for-X-Cart see here]
+What is MaxCDN  - [https://marketplace.x-cart.com/Marketing/MaxCDN-for-X-Cart see here]
 Setting up a CDN for your medium to large X-Cart site will help improve its loading times across the world by delivering static content from the MaxCDN server located closest to your customer. Google uses site loading times as a factor in search engine ranking so for sites with steady sales and traffic we recommend implementing a CDN like MaxCDN.

@@ Line 271: / Line 271: @@
+}
 </pre>
 === Performance improvement patches for X-Cart===

@@ Line 304: / Line 304: @@
 You can further assess the effect made by adjusting certain settings on the page load rate using ''Firebug'', a FireFox extension. For more information on installing and using this tool, please visit [http://getfirebug.com/wiki/index.php/Net_Panel#Timeline Firebug website].
-[[Category:Troubleshooting]]
+==See also==
-[[Category:X-Cart user manual]]
-[[Category:Troubleshooting]]
+* [[X-Cart:X-Cart_Benchmark_report_tool|X-Cart Benchmark report tool]]
-[[Category:X-Cart user manual]]
 [[Category:Troubleshooting]]
 [[Category:X-Cart user manual]]

@@ Line 145: / Line 145: @@
 will launch the optimization routine at 2:00, 3:00 and 4:00 a.m. on weekends.
-The above examples are for console users; if you are using a control panel like cPanel or Plesk, the cron job schedule can be easily set up using the standard web interface.
+The above examples are for console users; if you are using a control panel like cPanel or Plesk, the cron job schedule can be easily set up using the standard control panel interface.
 When deciding on the schedule for SQL optimization tasks on your site, be sure to choose the times when your site has the least number of visitors.

@@ Line 118: / Line 118: @@
 '''In X-Cart v.3.5.x and 4.0.x:'''
-Execute the following SQL query for each X-Cart table
+Execute the following SQL query for each X-Cart table (<table_name> needes to be replaced with the actual name of the table):
 <pre>
@@ Line 124: / Line 124: @@
 </pre>
-where replace <table_name> with the name of a table. You can get the list of X-Cart tables by executing the following SQL query:
+You can get the list of X-Cart table names by executing the following SQL query:
 <pre>

@@ Line 141: / Line 141: @@
 The following crontab configuration:
 <pre>
-2,3,4 * * 6,7
+2,3,4 * * 6,7 (cd full_path_xcart_web_dir/tools;<php_bin_path>/php maintenance_jobs.php)
 </pre>
 will launch the optimization routine at 2:00, 3:00 and 4:00 a.m. on weekends.

@@ Line 133: / Line 133: @@
 If your store is based on X-Cart 4.6.0 or later, it is recommended to set up a cron job to automatically launch the MySQL table optimization routine on a regular schedule.
-For example, the following crontab configuration:
+For example, the following crontab configuration (full_path_xcart_web_dir needs to be replaced with the actual path to your X-Cart directory as seen from the Web, <php_bin_path> - with your actual php binary path):
 <pre>
 2,3,4 * * * (cd full_path_xcart_web_dir/tools;<php_bin_path>/php maintenance_jobs.php)
@@ Line 144: / Line 144: @@
 </pre>
 will launch the optimization routine at 2:00, 3:00 and 4:00 a.m. on weekends.
 When deciding on the schedule for SQL optimization tasks on your site, be sure to choose the times when your site has the least number of visitors.

@@ Line 129: / Line 129: @@
 SHOW TABLES;
 </pre>
 === Optimizing CSS ===