The new one isn't public yet but will be soon. I had to write an article on how I did it and why (i.e. no recursion, etc.). Currently, the DB is on the same box as the webserver and it really doesn't matter which gets the hit, the result is the same. Though it's a whole lot easier to do it in CF. When the new SQL box is in then I'll think of following my rule of "let the DB do the work".
> Michael Dinowitz wrote: > > Lets put it this way, an archive thread can be 1 or more messages. Lets say that >for some threads, this is 50 messages. These have to be retrieved from the DB, sorted >using a maketree sort and then displayed. Now I have a new maketree sort that's fast >and smooth as hell, but it still takes time and processing. > > 1. Is that maketree public domain? > 2. How about offloading this to the DB by using a nested set model? > > Jochem > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
