CSC-SY

أرجو ممن لديه أفكار عن طريقة تخزين الـ TreeView في الـ Database

حاولت بطريقة الـ recursion, عن طريق جدول يحتوي رقم الـ Node و رقم الـ Parent

لكن هذه الطريقة كلفت وقت كلما كبر حجم الـ Tree و تتطلب مرور كبير على الـ database

أرجو المساعدة

You can store the data in the databse, but after making a trigger that palancing the data as a tree and referring for each node(row) to its parent and if it's on the right or left branch. there is such implementation free on internet. anyway it's a common way to extract fast reports in some financial systems, and if your databse had been built on this scheme then it's perfect for partioning on non-periodical factor, but you must be carefull because this implementation will slow down your transaction.

thank you all
I found many idea that speak like (as_els)

I will try to implement a trigger that manipulate the path on every insert

thanks

I advise you to try ORDBMSs like Oracle , i.e. to try the object-orientation in Oracle for example. Or to try an OODBMS (ODBMS) fully relying on the OOP theory, like O2, db4objects or Versant.
I mean : try some thing different from the traditional "Relational" model(which most popular DBMSs rely on) like Access, MySQL.... Oracle.