Next Webinar: Maximizing Magento - Get the Most out of Promotions. Register Today!

Magento

Open Source eCommerce Evolved

Magento Forum

   
Speed
 
Xionicfire
Member
 
Total Posts:  38
Joined:  2008-05-07
 
Crucial - 12 May 2008 12:30 AM

Xionicfire - 11 May 2008 09:51 PM
Server is:
Dell PowerEdge R900
FOUR Quad-Core Intel Xeon X7350 2.93GHz CPUs w/8MB (2x4MB) L2 cache
16GB ECC DDR2-667 SDRAM
2x Raid 0, 73GB 15,000 RPM SAS Raid hard drives

Something definitely isn’t configured right. We run very similar servers:

Quad core, dual proc, Intel Xeon (E5450) Harpertown 3.0 GHz
16GB ECC FB-DIMM DDR2
1000Mbps port uplink
Disk setup in either iSCSI or local RAID-10 depending on the server
RHEL 5 with Parallels Virtuozzo

The numbers you posted are amazingly high for the machine you have, leaving me scratching my head becuase we’re getting 1-2 second load times with store data and the longest process is adding an item to the cart (4 seconds).

Have you done any tweaks to the system at all (e.g. MySQL, PHP, opcode caching, mod_deflate, etc.)? Is anything else running on the server? Even that wouldn’t make sense if you had a blank, default setup. The machine is powerful enough that with no tweaks it still shouldn’t be running like that.

Could this possibly be because of Windows? I have absolutely no experience with Magento on Windows but can’t imagine that it would make such a big difference since we’re still dealing with the same underlying technology (PHP, MySQL, etc).

Interested to hear your progress/comments on this...and I’m still scratching my head

Im preety sure its due to windows and some settings not tweaked for magento..... i could almost bet you are running your servers on linux :/

Im aware linux probably runs a lot faster. but well the problem is its only magento that runs slow on this server, all other scripts run fine, im also sure that having windows doesnt exactly help this but still it shouldnt take that long to load i messed with some stuff and i obught the load times down like 5-6 secs but that was best i could do, even setting the MySQL cache to 2 gigs ram.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Xionicfire
Member
 
Total Posts:  38
Joined:  2008-05-07
 

and yeah i havnt gotten into the tweaks part yet this is a blank out install… and test, then again.. i wasnt expecting it to be that slow loading....even untweaked.

i was using:

http://tools.pingdom.com/fpt/

to test the load times.

as i mentioned i did some small tweaking and got it down 5-6 secs less but still takes painstakingly long on the admin pages, (at least now is barely bareable)

Ill start doing some more tweaks as i find them, if you have a list of good tweaks i should watch for, it would be greatly apreciated as im totally clueless as to how the innards of magento work or where should i start looking for tweaks (other than these forums, theres a nice post with some stuff which i already did and got the 6 sec speed buff)

And yeah server is blank completely no apps but windows, all service packs/security updates and XAMPP

Im guessing since all linux to windows software ports are basically that, ports, they end up being less efficient while running than their linux counterparts, not to mention windows loads a billion files/services/other that it needs to run that linux doesnt, im sure that hits the performance as well.

either way, i hope theres some way to make magento run faster “out of the box” so to speak.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Crucial Web Host
Sr. Member
 
Avatar
Total Posts:  189
Joined:  2007-11-08
Phoenix, AZ
 

Dont use pingdom - it’s a flawed and useless tool.

Try this instead - it’s a far better measurement utility.

http://internetsupervision.com/scripts/urlcheck/check.aspx?checkurl=http://demo.magentocommerce.com

You’ll get measurements from 10 different locations around the world. 

Hope this helps

 Signature 

Crucial Web Hosting
We provide hosting for Magento in shared, semi-dedicated, and dedicated configurations.
Our Containers include free features like Magento support from Varien, SSL certificate, McAfee Secure, and hourly backups.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Xionicfire
Member
 
Total Posts:  38
Joined:  2008-05-07
 

One of the things that scares me is this:

our customer wants around 12,000 products in the store....

we did some testing as to how long it takes to add a product (the ultra configurable interface is really nice but it takes a big hit when you are trying to speed-add stuff to your store)

And we found out that its around this:

20-30 seconds entering product data
5-10 seconds to recheck/visually verity whats been entered.
click save
13-18s to “save” the product to DB

Total:
38-58 Secs per product.
Total Time to enter all Products into the database: 126.6 - 193.3 HOURS to enter all products in.
Total cost paid to someone to do this (at minimum wage of 8 bucks an hour)
$1012.8-$1546.6

On other shopping cards (ill admit without the flexibility of this one)
20-30 seconds entering FIRST product data (5-8 seconds to modify differences on items thereafter)
2-5 seconds to check. (less info to verify since most was already entered in)
2-3 seconds to save to db

Total time:
24-38s first product of set
9-16s ones there after
Total Time to enter all Products into the database: 50.4 - 85.3 HOURS to enter all products in.
Total cost paid to someone to do this (at minimum wage of 8 bucks an hour)
$403.2-$682.2

See where im going with this? we need more SPEEEEEEEEEEEED when its this slow it starts causing problems.

other cards pre-fill similar products so you just make small mods, which saves you 15-20 seconds off these 20-30in those cases)

 
Magento Community Magento Community
Magento Community
Magento Community
 
Xionicfire
Member
 
Total Posts:  38
Joined:  2008-05-07
 
Crucial Web Host - 12 May 2008 05:51 PM

Dont use pingdom - it’s a flawed and useless tool.

Try this instead - it’s a far better measurement utility.

http://internetsupervision.com/scripts/urlcheck/check.aspx?checkurl=http://demo.magentocommerce.com

You’ll get measurements from 10 different locations around the world. 

Hope this helps

lemme try your host and see if it gets any better.

thanks for that tip

 
Magento Community Magento Community
Magento Community
Magento Community
 
Crucial
Guru
 
Avatar
Total Posts:  505
Joined:  2007-11-07
Phoenix, AZ
 
Xionicfire - 12 May 2008 05:45 PM

i was using:

http://tools.pingdom.com/fpt/

to test the load times

Aah, well there’s your problem. I thought you were giving me actual load times from what you were seeing when bringing up the store. As the other Crucial mentioend, don’t use Pingdom. That’s why you’re getting such high results. I was wondering why none of this was making sense! I can stop scratching my head now :D

 Signature 

Crucial Web Hosting
We provide hosting for Magento in shared, semi-dedicated, and dedicated configurations.
Our Containers include free features like professional Magento support, SSL certificate, McAfee Secure, and hourly backups.

 
Magento Community Magento Community
Magento Community
Magento Community
 
DavidONE
Jr. Member
 
Total Posts:  5
Joined:  2008-01-30
 
Crucial Web Host - 12 May 2008 05:51 PM

Dont use pingdom - it’s a flawed and useless tool.

Try this instead - it’s a far better measurement utility.

http://internetsupervision.com/scripts/urlcheck/check.aspx?checkurl=http://demo.magentocommerce.com

That also looks flawed and useless - all it appears to be measuring is download of the HTML which is why it reports ‘25Kb’.  It’s ignoring the other 410Kb of graphics, CSS, JS, etc. on the home page and any other delay caused by the server.

I’m on an 8Mbps (which maxes at ~6) connection in England.  Most USA sites are instant, Magento demo always takes ~7 seconds on first load.  Subsequent pages views are much quicker (~3 seconds).  Adding a product to cart took ~8 seconds followed by ~10 seconds for bringing up checkout page.  It all adds up to a slow user experience - and this is on a demo site with hardly any active visitors.

 
Magento Community Magento Community
Magento Community
Magento Community
 
DavidONE
Jr. Member
 
Total Posts:  5
Joined:  2008-01-30
 
Xionicfire - 12 May 2008 05:42 PM

Im preety sure its due to windows and some settings not tweaked for magento....

It seems that way.  I’ve just clean installed Magento with no products to localhost on my Ubuntu box - backend + frontend are nearly instant.

Any suggestions on what to do to improve speed on a WinXP box?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Moshe
Magento Team
 
Avatar
Total Posts:  1771
Joined:  2007-08-07
Los Angeles
 

If you disable EAV cache - how does it affect the performance?

 Signature 

- I would love to change the world, but they won’t give me the source code -

 
Magento Community Magento Community
Magento Community
Magento Community
 
Xionicfire
Member
 
Total Posts:  38
Joined:  2008-05-07
 

pardon the noobness but what is EAV cache and where do i find it lol…

(i havnt been getting much sleep entering all the products)

 
Magento Community Magento Community
Magento Community
Magento Community
 
Moshe
Magento Team
 
Avatar
Total Posts:  1771
Joined:  2007-08-07
Los Angeles
 

Admin > System > Cache Management, uncheck checkbox in the same line with text “EAV”, make sure everything else in same fieldset is checked, click Save button.

 Signature 

- I would love to change the world, but they won’t give me the source code -

 
Magento Community Magento Community
Magento Community
Magento Community
 
ryanb
Sr. Member
 
Total Posts:  83
Joined:  2008-02-15
 

Just wondering—why are you asking about disabling EAV cache? Do you have a theory that it should increase performance if it is disabled?

Moshe - 14 May 2008 04:42 PM

If you disable EAV cache - how does it affect the performance?

 
Magento Community Magento Community
Magento Community
Magento Community
 
ryanb
Sr. Member
 
Total Posts:  83
Joined:  2008-02-15
 

Also for those of us who have APC installed, should be also be enabling caching in the Magento software under System>Cache Management?

How much does it improve performance to enable the options in System>Cache Management?

 
Magento Community Magento Community
Magento Community
Magento Community
 
jcoleman
Jr. Member
 
Total Posts:  4
Joined:  2008-05-15
 

I know I am late to the party as I have just (very thankfully) stumbled upon Magento late last week, but I am seeing serious speed issues too.  I am hosted at Mosso now (claimed “infinite real-time scaling” clustered solution), and the Magento performance ranges from 5-10 seconds for page loads (behind 1.5 Mb DSL, caching enabled in Magento) to nearly 30 seconds to simply display the cart contents on a fresh install, empty store (and, nearly a full minute to display the admin landing page after logging in). For a demo of the installation (this is just on a dummy site), here is the URL of the dummy store: http://www.shift-paradigm.com/magento.

The feature set of Magento practically makes me fall out of my chair, in that this seems like a “dream come true” platform.  However, I cannot imagine customers enduring the wait times of the current version of the software.  As such, I am really curious how much of the page wait issues are the hosting solution (especially since the database is not on the same “box” as the web server), and what are issues I might be able to attribute to the Magento platform.

If anyone has been able to find ways to significantly speed up load times, I would love to hear how it was done (ideally without changing host as we have a lot of business built around the Mosso platform).  My current project is VERY customer experience focused, and although I would love to use Magento as the ecommerce platform (since feature-wise it is absolutely incredible), but as things are now, the load times will just be a deal-killer.

A big part of me hates to beat on this issue, mainly due to the ambitiousness and sheer awesomeness of the Magento platform, but if page loads take more than 3-5 seconds, frustration can start to build, the web experience gets diluted, and PPC advertising gets put at risk (due to people clicking away before the page loads, thus wasting the paid-for click).

Anyway, any assistance would be sincerely appreciated, and thank you to the Magento team for a product with such potential.

 
Magento Community Magento Community
Magento Community
Magento Community
 
ryanb
Sr. Member
 
Total Posts:  83
Joined:  2008-02-15
 

You should make all of the changes they go over in the blog post on performance. It helped us a lot.

I agree though—still could be better speed, but its only 1.0 and they seem to be doing a great job so far so I am sure some more performance improvements will come down the road.

http://www.magentocommerce.com/blog/comments/performance-is-key-notes-on-magentos-performance/

jcoleman - 15 May 2008 06:55 PM

I know I am late to the party as I have just (very thankfully) stumbled upon Magento late last week, but I am seeing serious speed issues too.  I am hosted at Mosso now (claimed “infinite real-time scaling” clustered solution), and the Magento performance ranges from 5-10 seconds for page loads (behind 1.5 Mb DSL, caching enabled in Magento) to nearly 30 seconds to simply display the cart contents on a fresh install, empty store (and, nearly a full minute to display the admin landing page after logging in). For a demo of the installation (this is just on a dummy site), here is the URL of the dummy store: http://www.shift-paradigm.com/magento.

The feature set of Magento practically makes me fall out of my chair, in that this seems like a “dream come true” platform.  However, I cannot imagine customers enduring the wait times of the current version of the software.  As such, I am really curious how much of the page wait issues are the hosting solution (especially since the database is not on the same “box” as the web server), and what are issues I might be able to attribute to the Magento platform.

If anyone has been able to find ways to significantly speed up load times, I would love to hear how it was done (ideally without changing host as we have a lot of business built around the Mosso platform).  My current project is VERY customer experience focused, and although I would love to use Magento as the ecommerce platform (since feature-wise it is absolutely incredible), but as things are now, the load times will just be a deal-killer.

A big part of me hates to beat on this issue, mainly due to the ambitiousness and sheer awesomeness of the Magento platform, but if page loads take more than 3-5 seconds, frustration can start to build, the web experience gets diluted, and PPC advertising gets put at risk (due to people clicking away before the page loads, thus wasting the paid-for click).

Anyway, any assistance would be sincerely appreciated, and thank you to the Magento team for a product with such potential.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top
 
Sales: Call 877.832.5289 (North America) 310.295.4144 (International)
© Copyright 2008 Varien. Magento is a trademark of Irubin Consulting Inc. DBA Varien
Privacy Policy|Terms of Service
Magento Community Count
41085 users|824 users currently online|87750 forum posts