Hello!
I'd like to ask something. I've got a table in a db with more than 10000 rows. The rows are in a hierarchical id - parent_id structure. I'd like to use a hierarchical tree to put them on the screen. A have't found any javascript code which could handle it, because it needs lots of memory and processing on client side. (showing all the rows which isn't important)
I found on the web that the solution is pear dynamic nested tree with pear html_tree, but I couldn't find an example put them together. Could anyone show me an example or do You have a better solution?
Thanks
SzCs
huge tree
Moderator: General Moderators
I would think about breaking things down into seperate pages.. maybe 1000 entries per page at the most.
If you try and dump all of that information into one page the Browser will either crash or people won't hang around waiting for the page to load. I reckon you'll be looking at a page size of about 500K - 1MEG if you try and dump the whole lot to one page.
If you try and dump all of that information into one page the Browser will either crash or people won't hang around waiting for the page to load. I reckon you'll be looking at a page size of about 500K - 1MEG if you try and dump the whole lot to one page.
I do not need the entire tree to be displayed. I'd like to display only thoose parts of the tree which need to be showed. For example at the beginning the root and the first level, and if any node clicked then the second level of that node and so on..
I found that there is a solution, which is a nested tree (pear::tree), the dynamic solution, when only thoose parts of the tree loaded into the memory which is in use. In Oracle db you can also solve it easily with a special select statement.
My problem is, I can't found a solution to display this ever growing tree array/object . This display method needs to maintain that tree object in the memory, and needs to display it.
Hopefully you could understand my problem.
Thanks
SzCs
I found that there is a solution, which is a nested tree (pear::tree), the dynamic solution, when only thoose parts of the tree loaded into the memory which is in use. In Oracle db you can also solve it easily with a special select statement.
My problem is, I can't found a solution to display this ever growing tree array/object . This display method needs to maintain that tree object in the memory, and needs to display it.
Hopefully you could understand my problem.
Thanks
SzCs