This is a multi-part message in MIME format.
------=_NextPart_000_0017_01C05ACB.7FC19D70
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hey Guys:
I am building a web site that randomly pulls 4 different categories from =
a database and displays the sub categories in them, with links to each =
of those categories. Picture the Yahoo! homepage, cause its the same =
thing.
Right now I have a database query that finds all of the top level =
categories and randomly picks four to be selected. It then querries for =
all of the sub categories of those four categories and then lists the =
data in the same format as Yahoo! I cache the querries for 1 day since =
this is placed on the homepage so it will be needed every time someone =
goes to the site.
I was wondering though if it would be easier to say have a script run at =
3am and generate files for each root category with its sub categories =
and then just randomly select four of those files instead of having to =
use cached querries at all. Does anyone know if this would decrease or =
increase performance or not make much of a difference. Any other =
solutions.
Thanks is Advanced,
Greg Wolfinger
Certified Uncertified ColdFusion Developer
------=_NextPart_000_0017_01C05ACB.7FC19D70
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3103.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hey Guys:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>I am building a web site that randomly =
pulls 4=20
different categories from a database and displays the sub categories in =
them,=20
with links to each of those categories. Picture the Yahoo! =
homepage, cause=20
its the same thing.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Right now I have a database query that =
finds all of=20
the top level categories and randomly picks four to be selected. =
It then=20
querries for all of the sub categories of those four categories and then =
lists=20
the data in the same format as Yahoo! I cache the querries for 1 =
day since=20
this is placed on the homepage so it will be needed every time someone =
goes to=20
the site.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>I was wondering though if it would be =
easier to say=20
have a script run at 3am and generate files for each root category with =
its sub=20
categories and then just randomly select four of those files instead of =
having=20
to use cached querries at all. Does anyone know if this would =
decrease or=20
increase performance or not make much of a difference. Any other=20
solutions.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks is Advanced,</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Greg Wolfinger</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Certified Uncertified ColdFusion=20
Developer</FONT></DIV></BODY></HTML>
------=_NextPart_000_0017_01C05ACB.7FC19D70--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
