| Author |
 Topic  |
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
 Posted - 01 November 2001 : 09:10:01
|
I'm faced with a delema, either put 5 Memo fields in a database to hold 5 separate banner codes (degrading performance, but being compatible), or using FSO to be able to put unlimited banner codes using text files, but sacrificing compatibility with all servers... Any Idea's, suggestions?
---------------
-Da_Stimulator |
|
|
Kat
Advanced Member
United Kingdom
3065 Posts |
Posted - 01 November 2001 : 09:18:06
|
I would go for the database. I beleive it will be more efficient than the FSO for that. I may be wrong. Just my opinion. 
KatsKorner
|
 |
|
|
heptite
Average Member
USA
547 Posts |
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 01 November 2001 : 11:26:56
|
is this column holding the actual url where the banner is located? Look at some of the other banner programs (http://www.aspin.com/home/webapps/admanage) and see what type of field they store it in. I would not use FSO, but would use the database because you want it to be more compatable so that way more people will want, and will use your program.
Brad |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 01 November 2001 : 12:00:27
|
You should take another look at your database design if you're considering separate columns for each banner.
I suspect performance wouldn't be any better with using FSO to create/delete/edit files, there is overhead in using the server filesystem too.
======
Doug G
====== |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 01 November 2001 : 12:30:04
|
quote:
is this column holding the actual url where the banner is located? Look at some of the other banner programs (http://www.aspin.com/home/webapps/admanage) and see what type of field they store it in. I would not use FSO, but would use the database because you want it to be more compatable so that way more people will want, and will use your program.
Brad
No, this is going to hold entire HTML banner code, support for flash banners etc... thats why they are memo. This is for a TopSites program, I'm not going to use any banner rotation scripts, I'm writing my own. If I decide to go the database route, there is going to be a separate table for banners, with an outline something like the following:
Banner1Switch - Int
Banner1Code - Memo
Banner2Switch - Int
Banner2Code - Memo
Banner3Switch - Int
Banner3Code - Memo
Banner4Switch - Int
Banner4Code - Memo
Banner5Switch - Int
Banner5Code - Memo
If banners are turned on (an option in the config table), then I will call the switches only, depending on what switches are 'on', then I will call the related BannerCode column, in an attempt to make it faster..
---------------
-Da_Stimulator
Edited by - da_stimulator on 01 November 2001 12:31:07 |
|
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 01 November 2001 : 12:46:28
|
Couldnt you just have a table like...
Banners
Banner_ID int
Banner_Switch int
Banner_Code memo
Then this way you can have unlimited banners? You might have to have one other column depending on how everything is linked together.
Brad |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 01 November 2001 : 12:48:38
|
you know I think that guy was right yesterday... he said 'you gonna hurt your foot?' I said 'no I got steeltoes' - he said 'oh, thought you had steel brains'
Great Idea brad, I was thickheaded and neglected to even think of that.
---------------
-Da_Stimulator |
|
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 01 November 2001 : 12:54:05
|
everyone needs a good swift kick in the head sometimes to get the brain working. i know i do. just when you get rich of this, remember the one who said, hey do it this way...
Brad |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 01 November 2001 : 12:55:42
|
I doubt I'll get rich off it.... Free download while in beta, and it will probably be in beta forever LOL
---------------
-Da_Stimulator |
|
|
| |
Topic |
|
Topic Locked
