Multiple result sets and memory usage

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 56
Joined: Mon 26 Mar 2007 01:25

Multiple result sets and memory usage

Post by yeohray » Wed 09 May 2007 14:46

I have a query that returns 3 large result sets. I need to display all 3 result sets in 3 different grids. How can I do this, using the minumum amount of memory?

Currently, I am opening each result set, copying the data to a memory table, which then hooks up to a grid. This consumes a lot of memory at the beginning (2x the memory used by the 3 result sets).


Ray Mond

Posts: 512
Joined: Thu 26 Jan 2006 10:06

Post by Jackson » Fri 11 May 2007 14:20

SDAC doesn't support multiple active local result sets.
Use several TMSQuery components to avoid copying of data.

Post Reply