Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Page 1 of 2
Quick and easy way to speed up magento
 
sdb
Sr. Member
 
Avatar
Total Posts:  223
Joined:  2007-11-13
coastal California, USA
 

I can’t stress this enough: always backup everything before you do anything.

I doubt this will work for all of you, but I just noticed a big difference in speed after a quick and easy item i stumbled upon today
It is probably only useful to my host, but i’m sure many of you have some kind of similar options

See the attached images

1: log into your webhost’s control panel
2: use mysql management
3: select the database you use with magento
3: check it
4: repair it (if necessary)
5: OPTIMIZE it

made the frontend quicker and it took no time flat to do it.

Image Attachments
1.jpg2.jpg
 
Magento Community Magento Community
Magento Community
Magento Community
 
Crucial Web Host
Guru
 
Avatar
Total Posts:  364
Joined:  2007-11-08
Phoenix, AZ
 

Great information SDB and equally important and applicable for all hosts.

Database optimization is very important to having an optimized database wink and can be performed a variety of ways including the method you’ve shown using Direct Admin control panel.  This option is also available via CPanel, phpMyAdmin and shell commands -

Be sure to ALWAYS keep fresh backups of your data or your just one disaster away from disaster.

 
Magento Community Magento Community
Magento Community
Magento Community
 
lotusseedsD
Mentor
 
Avatar
Total Posts:  1144
Joined:  2007-08-31
 

I just did that in client’s cpanel (hostgator), I don’t notice any difference though - the speed is already good with hostgator, though I was hoping I could make it even better LOL

But good to know the tips. Thank you so much for sharing.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Gman2005
Member
 
Total Posts:  40
Joined:  2008-02-16
 

How do you do this in phpMyAdmin?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Crucial Web Host
Guru
 
Avatar
Total Posts:  364
Joined:  2007-11-08
Phoenix, AZ
 

Here’s a nice write up on using phpMyAdmin for table optimization for you.

http://www.webkeydesign.com/26/optimize-your-mysql-databases/

 
Magento Community Magento Community
Magento Community
Magento Community
 
AnnaM
Guru
 
Avatar
Total Posts:  325
Joined:  2008-01-29
San Francisco
 

I did this in standalone phpMyAdmin. Can’t say I saw any difference in speed, but I have the APC cache code insalled so it runs pretty fast anywya. But I am glad to learn about this feature. I didn’t know you could do it, and its good to know, so thanks for the info.  I wonder how oftern it s/b done? Once a week? Once a month? Any ideas? What exactly does it do?  Thanks again for the info.

 
Magento Community Magento Community
Magento Community
Magento Community
 
vary
Member
 
Total Posts:  60
Joined:  2008-12-15
China,Hongkong
 

I did it as your method in my c-panal,but it shows,
=================================================
note : The storage engine for the table doesn’t support repair
=================================================
if anything wrong with it?

 
Magento Community Magento Community
Magento Community
Magento Community
 
MageAustralia
Member
 
Total Posts:  37
Joined:  2008-08-23
Sydney, Australia
 

Magento is getting quite reasonable on speed these days, so it’s becoming less painful but I have written quite a detailed post on my blog a while back on How to Speed up Magento.  It goes into quite some depth and deals with most stages of optimisations. I hope it helps people.

 
Magento Community Magento Community
Magento Community
Magento Community
 
kneemahp
Sr. Member
 
Total Posts:  116
Joined:  2008-08-07
 

this sped up my site. it’s much faster. i’m on westhost if that matters.

 
Magento Community Magento Community
Magento Community
Magento Community
 
czukoman20
Jr. Member
 
Total Posts:  4
Joined:  2010-03-09
 

I LOVE YOU Thanks!

I freakin.. have been searching for speed up solutions for magento for 3 months… JESus and they were are all hard and never worked.
It worked in 2 min… God!

thanks again!

 
Magento Community Magento Community
Magento Community
Magento Community
 
joshgeake
Jr. Member
 
Total Posts:  11
Joined:  2011-05-12
 

I found this guide, it’s pretty damn good and the support guy is good too. Well worth $3. http://www.geakeit.co.uk/configurations-customisations/speed-up-magento-the-complete-guide-to-making-magento-1-5-faster.html

 
Magento Community Magento Community
Magento Community
Magento Community
 
avanoire
Jr. Member
 
Avatar
Total Posts:  3
Joined:  2010-06-05
 

@Mageman
Hi!  I tried the .htaccess and gzip/deflate method ( that you describe in your blog ) and my page load time went from 18 seconds ( I have some heavy images on the front page ) to 3 seconds , it worked like a charm =)

Thanks

/Jessica

 
Magento Community Magento Community
Magento Community
Magento Community
 
kentutz
Jr. Member
 
Total Posts:  3
Joined:  2011-07-25
 
MageAustralia - 29 August 2009 03:33 AM

Magento is getting quite reasonable on speed these days, so it’s becoming less painful but I have written quite a detailed post on my blog a while back on How to Speed up Magento.  It goes into quite some depth and deals with most stages of optimisations. I hope it helps people.

Optimizing phpMyAdmin works like a charm!
The above link is very useful as well, but I did came across major issues when trying to shrink JS and CSS files. The site is much faster as it is.. thanks a bunch!

Now time to shrink my log files.

 
Magento Community Magento Community
Magento Community
Magento Community
 
frano8
Jr. Member
 
Total Posts:  8
Joined:  2009-11-04
 

I just tried this and certainly had an effect on our magento site, thanks for the tip.

Still not as quick as I would like but getting better.

 
Magento Community Magento Community
Magento Community
Magento Community
 
dr_watson
Jr. Member
 
Total Posts:  12
Joined:  2012-08-28
 

Thanks for the tip! It did make a difference! I also used this thread http://www.magentocommerce.com/boards/viewthread/193317/. Really came in handy, cause the slow speed was driving me crazy.
Now it’s way much better!

 
Magento Community Magento Community
Magento Community
Magento Community
 
dr_watson
Jr. Member
 
Total Posts:  12
Joined:  2012-08-28
 

Thanks for the tip! It did make a difference! I also used this thread http://www.magentocommerce.com/boards/viewthread/193317/. Really came in handy, cause the slow speed was driving me crazy.
Now it\’s way much better!

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top
Page 1 of 2