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
My site is painfully slow. Help!
Moderator: General Moderators
-
pastijalan
- Forum Newbie
- Posts: 10
- Joined: Thu Oct 12, 2006 11:54 pm
Re: My site is painfully slow. Help!
APC can help with caching.
Use EXPLAIN on your select queries to see which queries may be going the slowest -- then update them.
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.
Re: My site is painfully slow. Help!
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

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
-
geethalakshmi
- Forum Commoner
- Posts: 31
- Joined: Thu Apr 24, 2008 10:38 pm