Posted by Stefan Rybacki on 10/20/05 16:27

>...
> That's a possibility.

Then go ahead with it.

>
>
>>The problem if such a structure is the overhead on inserting new data.
>>And since he has a comment system, insertion could be very often. Don't
>>get me wrong I would prefer such a structure but I'm not sure whether
>>the OP get it to work or whether the insertion takes to long.
>
>
> There would be far more retrievals than inserts, so I think this could be
> the way to do it. Now to come up with some sort of cunning scheme...

Have a look at the nested set model.

>
> Of course, a good way to do it would have been with stored procedures to
> do all the leg work for the retreivals, using a simpler structure for
> faster inserts, but that's not possible with the antique version of MySQL
> I'm running.

yes, thats too bad, but the nested set model can handle it for you too.

>
> Anyway, thanks to all for the advice.
>
> Naich.

Regards
Stefan

[Back to original message]