Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-05 : 10:41:54
|
Aravind writes "I have a set of members who have a referrer. This is to be represented as a multilevel tree. I implemented this in the frontend using asp. The main problem started when the database grew.I have nearly 1 lakh records & the asp page goes for a toss whenit tries to display the tree structure upto 6 levels.I have tried using cursors(as suggested in one of the replies inthe forum) but this also takes a lot of time nearly(1hr 20 mins for 1 lakh records) . I'll be happy if you could help me in this matter.the table has following structure:memberid | name | email | referrer-----------------------------------1 | xxx | ......| 02 | xxx | ......| 13 | xxx | ......| 14 | xxx | ......| 25 | xxx | ......| 5 the tree structure is not binary,it is a general treeThank you in advance" |
|
|
|
|
|
Tree Representation