Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

Re: Banner Rotation, AdvertPro, and Links SQL

Quote Reply
Re: Banner Rotation, AdvertPro, and Links SQL In reply to
Things seem to have died off on a number of fronts (these forums not withstanding!)

I've taken a good hard look at AdCycle (even in his code he regrets some of the initial hard-coding) and I have played with AdvertPro trying to integrate that with Links, and with a couple of other programs.

I have a few questions that I'd like a little feedback on.

Is there a preference for banners stored in MySQL, or stored on disk? I'm not sure what the performance difference would be (this had been discussed a long while ago), but management features would be somewhat easier if the blob was stored in the database, rather than all over the disk.

Is there a limit to what sort of data serving that can be don with blobs?

I've looked at most of the programs out there, and I'm ready to start finalizing some sort of database structure, so input would be appreciated!

After looking at this problem for several months, I still think proper database design will eliminate a lot of the problems showing up in other programs, and allow for significantly less overhead in the banner calling routines.


PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://postcards.com/FAQ


Subject Author Views Date
Thread Banner Rotation, AdvertPro, and Links SQL pugdog 5475 Oct 26, 2000, 2:20 PM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
qango 5373 Oct 27, 2000, 5:08 AM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
pugdog 5365 Oct 27, 2000, 11:34 AM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
pugdog 5372 Oct 27, 2000, 6:55 PM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
Stealth 5359 Oct 27, 2000, 9:33 PM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
pugdog 5350 Oct 27, 2000, 10:07 PM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
pugdog 5351 Oct 27, 2000, 10:12 PM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
Stealth 5352 Oct 27, 2000, 10:22 PM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
pugdog 5361 Oct 27, 2000, 11:59 PM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
qango 5362 Oct 28, 2000, 6:59 AM
Post Re: Banner Rotation, AdvertPro, and Links SQL
pugdog 5275 Nov 1, 2000, 3:42 PM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
pugdog 5280 Nov 1, 2000, 4:29 PM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
pugdog 5279 Nov 1, 2000, 9:57 PM
Post Re: Banner Rotation, AdvertPro, and Links SQL
Michael_Bray 5262 Nov 1, 2000, 10:50 PM