Jump to content

 

hairsmize

Member Since 25 Sep 2013
Offline Last Active Apr 09 2014 09:06 PM
-----

Topics I've Started

Release Date For Cs-Cart 4.2?

04 March 2014 - 10:21 PM

Anyone know when they're planning on release version 4.2? Is it out already? Our site upgrade is only to 4.1.1.

We're desperately looking to use "non-unqiue" seo name in the 4.2 version... please help.

Cs-Cart Performance

19 February 2014 - 04:22 PM

We've had our ServInt folks take a look at our site to see why there's such a lag to the first byte. And they are now pointing their finger at CS-Cart... can someone help us?

-------------------------- This is what they came back with -------------------------

My reports show:

time_namelookup: 0.569
time_connect: 0.572
time_appconnect: 0.000
time_pretransfer: 0.572
time_redirect: 0.000
time_starttransfer: 2.099
----------
time_total: 2.144

starttransfer is the Time to First Byte as you've already determined. The causes for this can range from memory leaks, poor coding, slow queries, or lack or resources. I've tried optimizing MySQL using mysqltuner.pl, but it didn't help, and the memory and lack of resources are certainly not a problem on SolidFire.

This leads me to believe that something in your site's configuration or coding is causing a delay when the server goes to retrieve all of the resources necessary to send to the visitor.

Most of the time, it's a plugin or addon that is poorly coded and causes the server to generate a cache of sorts for every visit. Caching problems like this are common in my experience with CMS software. What happens if it's working properly is that the cached files are generated upon the first visit, then those same files are then served to all other visitors after that initial request. The initial request can be slow because it's doing more than collecting, it's creating the cache files. What I suggest checking on your end is whether those cache files are being generated each and every time someone visits the site, instead of already existing files being served.

From my research, this seems to be the case:

root@server [/home/hairsmiz/public_html/var/cache]# find ./* -type f -newermt "10 seconds ago" -exec ls -alht {} \;-rw-rw-rw- 1 nobody nobody 123K Feb 19 09:37 ./misc/statics/js/tygh/scripts-9dc0b275302b6592ecdf5a3967686ecb1392806559.js.gz
-rw-rw-rw- 1 nobody nobody 51K Feb 19 09:37 ./misc/statics/design/themes/basic/css/standalone.da1a42e4072ac28d1f939a816da4c1841392806559.css.gz
-rw-rw-rw- 1 nobody nobody 273K Feb 19 09:37 ./misc/1/theme_editor/standalone.da1a42e4072ac28d1f939a816da4c1841392806559.css

The above shows that within the /var/cache folder every time I visit the page, I get the following files generated instead of it serving me the already existing files.

You will need to contact the software developer at this point and report my findings. They should be able to make sure the caching plugin or feature in the software is configured properly or suggest a way to fix it.

------
xxxxxxxxx
ServInt MST

We exhausted all options... tried different tweaks and modules... and the easiest thing was to throw more money at it... upgraded out VPS package. Above findings are not very meaningful to us with our limited knowledge.. can someone translate it for us? Our site is at http://www.hairsmize.com (sitting behind cloudflare)

Database Performance And Site Slowness

18 February 2014 - 12:11 AM

We've launched our site a little prematurely and have been hit with some nasty performance issues. I am a MS SQL Server professional by trade but have been tasked to tune this MySQL database. As I understand MyISAM databases do not have row level locking and will lock up the entire table if you're editing data. Can someone please confirm or deny my assumptions....

We've spent a lot of money on Google Adwords and have been able to generate some "useless" traffic to the site... but at the same time, we have in house staff loading the site with new products throughout the day. In the evening when no one is inputting anything, I've seen the site load around 2-3 seconds.. but when there are people inputting, the load time drops to 8-9... sometimes 10+ seconds to load.

I've thought about changing the tables to InnoDB for a few months until we can get all our products added to the cart.. then switch back. Is this advisable?

Also, recently switched our cs-cart caching from "file" to "mysql".. this table, presumably, is also MyISAM.... can this impact performance as well since by nature you'll be writing to this table frequently.