TDataSet memory occupation

Thread View: borland.public.cppbuilder.database.ado

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by luca Fri, 28 Oct 2005 16:39

#623

Author: luca
Date: Fri, 28 Oct 2005 16:39

5 lines
902 bytes

opening a TDataSet connected to a big table (40MB) the memory occupation of
the process grows of the same quantity.
is possible to avoid this?

luca

Re: TDataSet memory occupation

#624

Author: Giuliano
Date: Fri, 28 Oct 2005 17:17

28 lines
1777 bytes

On Fri, 28 Oct 2005 18:39:43 +0200, "luca" <lct@tele2.it> wrote:

>opening a TDataSet connected to a big table (40MB) the memory occupation of
>the process grows of the same quantity.
>is possible to avoid this?
>
>luca
>

You can try to use a "server side" cursor.  

A server side cursor fetches only one row 
(or a little number of rows) at each call.

By contrast, a "client side cursor" it makes 
the attempt to fetch all the rows of the 
relation/table. If the cardinality of the 
retrieved set is large, you can have a huge 
memory requirement.

The steps to obtain the desired behaviour
they depends on the technology you are using  
(i.e. if you are using ADOExpress, IBExpress, 
dbExpress,  etc etc).    

Regards    

Giuliano

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads