My site is painfully slow. Help!

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
pastijalan
Forum Newbie
Posts: 10
Joined: Thu Oct 12, 2006 11:54 pm

My site is painfully slow. Help!

Post by pastijalan »

Hi Folks,

I am in the process of developing an online RSS aggregator site, http://www.kedoya.com . The site is currently in beta stage and is painfully slow due to large database. Due to its nature, Kedoya database grow by 10 MB everyday and will be 4 GB in size by the end of this year.


What is the best way to drammatically speed up my website other than restructuring the database design and indexes?

Thx a million!

Andy
User avatar
s.dot
Tranquility In Moderation
Posts: 5001
Joined: Sun Feb 06, 2005 7:18 pm
Location: Indiana

Re: My site is painfully slow. Help!

Post by s.dot »

APC can help with caching.
Use EXPLAIN on your select queries to see which queries may be going the slowest -- then update them.
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.
dhiraj
Forum Newbie
Posts: 12
Joined: Wed Apr 23, 2008 12:23 am

Re: My site is painfully slow. Help!

Post by dhiraj »

dear friends,

You Can use the crone job idea, which page have heavy data for showing to the user who visit the website define those pages on the crone job file like cronejob.php or cronejob.asp. Crone job file run automatically on the server so your website speed up

:) :lol:
geethalakshmi
Forum Commoner
Posts: 31
Joined: Thu Apr 24, 2008 10:38 pm

Re: My site is painfully slow. Help!

Post by geethalakshmi »

Hi,
Here are the few tips to speed up PHP code
http://hiox.org/index.php?id=193
Post Reply