Torquemada
Joined: 14 Sep 2004 Posts: 11
|
Posted: Tue Jan 11, 2005 8:19 pm Post subject: Optimising Tree Display from Database |
|
|
Using COOLjsTreePRO, we read the node information from an Access database, just like in the provided example (db_tree_nodes.asp).
I made one optimisation, which is to read the nodes sequentially instead of via the recursive function. This gave a big improvement.
But now we have a thousand or so nodes, the performance is slow, and I want to try to improve it by only reading from the database when necessary. In other words, I want to only read the visible nodes from the database.
Has anyone developed an algorithm for doing this? Or can anyone suggest other optimisations? |
|