building tree is slow

  • Thread starter Thread starter Max
  • Start date Start date
M

Max

We want to implement assigning permissions to web pages
using a tree like view. The text below illustrates what
the page would look like. Each of the items in the boxes
are types of permissions (i.e. A = Add, M = Modify). If a
user has permissions the box is green, if not red. When an
administrator clicks the box it changes colors. Also if
you click the boxes on the menu it automatically applies
this to all pages underneath.

Administration Menu |A|M|D|V|P|
Admin Page 1 |A|M|D|V|P|
Admin Page 2 |A|M|D|V|P|
Admin Page 3 |A|M|D|V|P|
Another Menu |A|M|D|V|P|
Another Page 1 |A|M|D|V|P|

The tree is built using three tables that build our menus
and are as follows( only including fields that matter for
discussion):

Menus
Menuid identity
Pages
Pageid identity
PageName nvarchar(100)
MenuItems
MenuItemID identity
Menuid int
Pageid int

Permissions are stored in a table that uses one field for
the permissions.

All of this to say. any ideas on how to do this in .Net.
We have this working in asp but as you might suspect is a
tad slow. We are hoping to find a better way to do this.
In ASP we use VB com components for building the tree
(create html) and java script to change colors of boxes.

Any ideas on a better way to approach the problem would be
great. Thanks!
 
we did something very similar on a project using the microsoft custom
treeview control (.net 1.0 and IE only), and it was pretty straightforward -
loading in large nested trees, each node of which was permissioned, could
take a while, so we 'chunked' our UI display to read only n-nodes deep at a
time. there's a fair number of custom treeview controls on the market now
though - i'd have a look at these.

r.
 
Back
Top