Page 1 of 1

My site is painfully slow. Help!

Posted: Wed Apr 23, 2008 11:48 pm
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

Re: My site is painfully slow. Help!

Posted: Wed Apr 23, 2008 11:57 pm
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.

Re: My site is painfully slow. Help!

Posted: Thu Apr 24, 2008 12:04 am
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:

Re: My site is painfully slow. Help!

Posted: Fri May 02, 2008 12:47 am
by geethalakshmi
Hi,
Here are the few tips to speed up PHP code
http://hiox.org/index.php?id=193