40
Complex UI Tree – V1
BRIM UI Tree (like TOAD)
uTrying to support a complex tree navigation structure
uFollowed conventional wisdom to the letter. 
ØEverything was placed in the middle tier. 
ØAll queries were stored on the application server
ØNo code was placed in the database. 
uQueries spun off child queries which in turn spun off other child queries (7 levels deep), and a single tree refresh took 12 minutes.
ØSince then, the tree control has been rewritten a few times.
ØEach time more and more logic was moved into the database. 
ØViews that flattened the hierarchical database structure were created.
ØUI design was refactored.
ØTree refresh executes with sub-second response.