Hello all: I am working with what will likely become a very large data set and a Virtual Tree (TVirtualStringTree.) The attractive thing about this VT is that it may have hundreds of thousands of nodes, but it only loads the nodes with data at the point in time that it is needed - usually. Due to the hierarchical structure of the tree, and the just-in-time loading of the nodes throughout the hierarchy, I have a variety of SQL Select statements, each filtered to bring in just the node data that is needed.
Unfortunately, there may be times that the user may decide to load the whole tree at once. Such times include using the short-cut keys (Ctrl-Shift-Plus) to load the whole tree, or when the user wants to do a search through the entire tree looking for specific data. If a full load is triggered, and there is a large number of nodes, it is possible that the app will run thousands of separate queries against the data base during the load. This - to be mild - is a huge time waster. I would like to take the special case where a full load is going to happen and load the entire data set into memory and then run the queries against the data in memory. I figure this should reduce the network time and reduce load time by a huge amount. I am looking for an example where a data set is fully loaded into memory and then used as a basis for subsequent queries. Anyone do this? I am using Delphi 5, Adonis ADO, and both Access and SQL Server back ends (I assume really large installations will be SQL Server.) Thanks jamie ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
