In my last post, I mentioned an article that deals with Nested Set Heirarchical data in MySQL. I'm at this point trying to design a business layer / data layer class around the concepts in this article.
I've run into a big wall in trying to develop a scheme in which I can get the most amount of data into the class with the fewest amount of hits to the database. The other problem is that I'd not only like my data to be heirarchical, but the objects in my class as well. Maybe that's wishful thinking.
I've got my solution for simple category navigation. But, I've got to come up with something else for category maps.
Print | posted on Wednesday, November 09, 2005 2:13 PM