Let me clarify: I want to load the whole data set (about 500 bytes per record) into memory only long enough to fill the tree data structure. Then, I will immediately close down the data sert, not to be used again.
This is strictly a kludge to avoid loading many many SQL selects. I understand about all of the dangers that you all have mentioned. jamie --- In [email protected], "Jamie L. Mitchell" <[EMAIL PROTECTED]> wrote: > > 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/
