Hi Pugdog,
I have started mucking around making a PHP/MySQL banner program, and I feel that storing the banners outside of MySQL is going to be about the same speed - but it just makes it easier and more convienient to store them outside of MySQL.
Another suggestion, keep going with the Cron Job idea to manage which ads are still valid. Ads need to be dished out fast, and it is vital to be able to just pull out a banner and show it as fast as possible. In the one I am writing, I am just going to set a 5 or 10 min cron to switch the valid field to what it should be - Probably have it run every 2 hours or so on my site, which doesn't get that much traffic.
Anyway - These things are hard to develop, but will be worth it in the end ;-)
Discuss webhosting at
The Webhost Area Forums!
http://www.webhostarea.com/forums/
I have started mucking around making a PHP/MySQL banner program, and I feel that storing the banners outside of MySQL is going to be about the same speed - but it just makes it easier and more convienient to store them outside of MySQL.
Another suggestion, keep going with the Cron Job idea to manage which ads are still valid. Ads need to be dished out fast, and it is vital to be able to just pull out a banner and show it as fast as possible. In the one I am writing, I am just going to set a 5 or 10 min cron to switch the valid field to what it should be - Probably have it run every 2 hours or so on my site, which doesn't get that much traffic.
Anyway - These things are hard to develop, but will be worth it in the end ;-)
Discuss webhosting at
The Webhost Area Forums!
http://www.webhostarea.com/forums/
