lol. I see now :)
While the approach for this "BannerMan" tag would work even with your
"categories" you would be using up some RAM. I would say that each "ad"
would require about 300-500 bytes so 1000 may be close to half a meg...
Pretty substantial ram usage just for an imge rotator :)
----- Original Message -----
From: "W Luke" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, June 30, 2001 1:12 PM
Subject: Re: Application Variables
>
>
> > "GetAdvert" sounds like it may be a query to collect a "random" ad from
a
> > database?
>
> Yes and no. If a user runs a search for, say, "furniture," this might
> retreive 15 adverts which would be using a query such as:
>
> <cfquery name="getadvert" datasource="#DSN#">
> SELECT * FROM advert_details
> WHERE body like '%furniture%'
> </cfquery>
>
> Another user might be browsing the Computer's category:
>
> <cfquery name="getadvert" datasource="#DSN#">
> SELECT * FROM advert_details
> WHERE cat = 156
> </cfquery>
>
> And so on. They use the same query name, and results are obtained by
> running a template which always uses <Cfoutput query="getadvert">
>
> I like the idea of stuffing them into an Application Var to speed things
up,
> but is it really plausible to put 1000+ Adverts into an App Var?
>
> Will
>
>
> >
> > One approach that worked very well for me was to run the query "once"
and
> > then store the ads in an application scoped array. This makes
retrieving
> a
> > "new" ad much quicker.
> >
> > You may want to take a look at this "Application" array here.
> >
> > http://cfhub.com/tutorials/BannerMan/customtag/pick.cfm
> >
> > On my
> > > site, a query called getadvert might get a record with an ID of 1987
for
> > > example. Another user at the site might be running the same query,
but
> > > getting a record of 981
> >
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
