CRE Loaded Community



Board index » CRE Loaded 6.2 » Install & Config

All times are UTC - 5 hours




Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: Site Is Running Crazy Slow....Any Way to Speed up MYSQL?
PostPosted: Mon Feb 01, 2010 10:40 am 
Offline
CRE Newbie

Joined: Tue Jan 12, 2010 12:06 pm
Posts: 4
Hi,

I've still been having some major speed issues with the site and was wondering if there were ways to speed up the database. I'm currently running 6.2PRO [5]. The site is also heavily modified, so I can't really upgrade to another contribution at this point.

The site offers about 15,000 items all which have about 4 different sizes listed through the database, so all and all there's about 60,000 usable entires, with another 5,000 that have no use, but still sit in the database... The site doesn't list any manufacturers, and since i sell relatively high ticket items there aren't a ton of orders that go through to be stored...

My questions are:
1. Are there any ways to speed up or optimize the database?
2. If deleting those 5,000 entries or so, would have a large effect on speed, and if so, how would I do so?
3. Is there anything else I can do to speed up my site?

What I've Done:

1. Optimized for both Google Accellerator and YSlow
2. Optimized all images to take up less space
3. Installed MagneticOne's Performance Tool
4. Installed ePHPAcellerator on the server....

Thanks!


Top
 Profile  
 
 Post subject: Re: Site Is Running Crazy Slow....Any Way to Speed up MYSQL?
PostPosted: Mon Feb 01, 2010 1:50 pm 
Offline
CRE Addict
User avatar

Joined: Wed Sep 16, 2009 10:47 am
Posts: 218
Location: Indiana, USA
What are page parse times? Tells you how fast the page is drawn.

What host are you using? Sites that size don't do well on cheap shared hosts.

_________________
Jody
Easy Store Sites
Specializing in Affilate Marketing
& Drop Shipping Websites


Are you a Help Vampire? Learn how to tell...


Top
 Profile  
 
 Post subject: Re: Site Is Running Crazy Slow....Any Way to Speed up MYSQL?
PostPosted: Mon Feb 01, 2010 4:37 pm 
Offline
CRE Newbie

Joined: Tue Jan 12, 2010 12:06 pm
Posts: 4
Hi,

How do I check the parse times?

I am currently on a VPS right now, and because of all the changes all my other smaller sites are flying.

If you want to check it out, the site is www.ownapainting .com


Top
 Profile  
 
 Post subject: Re: Site Is Running Crazy Slow....Any Way to Speed up MYSQL?
PostPosted: Mon Feb 08, 2010 10:05 am 
Offline
CRE Newbie

Joined: Tue Jan 12, 2010 12:06 pm
Posts: 4
how do I check this? Any ideas?


Help!


Top
 Profile  
 
 Post subject: Re: Site Is Running Crazy Slow....Any Way to Speed up MYSQL?
PostPosted: Mon Feb 08, 2010 1:03 pm 
Offline
CRE Addict
User avatar

Joined: Wed Sep 16, 2009 10:47 am
Posts: 218
Location: Indiana, USA
Admin >> Configuration >> Logging you'll find parse times. If you enable it and show it then you'll see it at the bottom of your pages.

I'm out of time for evals but your reverse DNS is incorrect. You need to fix that or you'll have serious email delivery problems. Most big ISPs block all emails from sites without rDNS.

Best regards,

_________________
Jody
Easy Store Sites
Specializing in Affilate Marketing
& Drop Shipping Websites


Are you a Help Vampire? Learn how to tell...


Top
 Profile  
 
 Post subject: Re: Site Is Running Crazy Slow....Any Way to Speed up MYSQL?
PostPosted: Mon Feb 08, 2010 1:12 pm 
Offline
CRE Addict
User avatar

Joined: Wed Sep 16, 2009 10:47 am
Posts: 218
Location: Indiana, USA
Sorry forgot the link

http://www.intodns.com/ownapainting.com

_________________
Jody
Easy Store Sites
Specializing in Affilate Marketing
& Drop Shipping Websites


Are you a Help Vampire? Learn how to tell...


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 

Board index » CRE Loaded 6.2 » Install & Config

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
It is currently Fri Jul 30, 2010 12:02 pm
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group

Login

Top Listing

1. Credit Card with CCV
    Category: Payment Modules
    
2. CC7333_ATS
    Category: Templates
    
3. Points & Rewards PLUS!...
    Category: Add-Ons
    
4. One Page Checkout...
    Category: Fixes
    
5. Configuration Server...
    Category: Fixes
    
Show more...

Follow Us on Twitter

@likeOMGitsFEDAY we do offer a wiki and other resources at www.creloaded.org
@smellgoodslady 6.2 is old code, we are at 6.4 now. come and get the latest.
@smellgoodslady what version/release are you running?
CRE Secure in the news: Payment News Article about Hosted Payment Pages reducing PCI friction - http://is.gd/ba0CH
@smellgoodslady yes it should work for 6.2 as well. let me know of you have any issues.

CRE Loaded Community Chat hosted by CRE Loaded.

Join now


Chat about what's on your mind. More about public chats.


© CRE Loaded is a product of Chain Reaction Ecommerce, Inc. Usage & Privacy Policy