and return all records at once as raw data. Use ColdFusion to regain
hierarchy, for ex. using structures and arrays, and you will have the
highest performance available.
It is all about minimizing database calls :-)
_____
From: Dick Applebaum [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 02, 2004 2:40 PM
To: CF-Talk
Subject: Re: Recursive function and Hierarchical navigation
Yeah!
Play with it in a SQL GUI until you get it the way you want it, then
enclose it within <cfquery>...</cfquery> tags.
Most of these (Celko's) techniques are quite fast -- seems a little odd
at first, but it compensates for RDBMS's inherent weakness when
handling hierarchical data.
I suggest you include lotsa' comments to explain what & why.
HTH
Dick
On Jun 2, 2004, at 5:28 AM, Nicholas Watson wrote:
> How do you return a record set like this back to ColdFusion? Do you
> just use a cfquery tag? I tried the example, and it's much faster than
> what we are currently doing, but how do I handle it on the ColdFusion
> side?
>
> >This is SQL-Server specific:
> >
> >http://vyaskn.tripod.com/hierarchies_in_sql_server_databases.htm
> >
> >If you want some general discussions on the topic google for
> >celko and trees or hierarchical or nested sets
> >
> >HTH
> >
> >Dick
> >
> >
> >On Jun 1, 2004, at 11:22 PM, Paul Wilson wrote:
> >
> >>
>
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
