Re: Memory problem



Hallo Ilya,

thank's for your reply.
My real application works with a Webservice for data exchanging with a SQL
Server database. I only transfer changed rows back to the database, because
there are some other WinCE devices which can change the data too.
A other function of the WS reads the hole data from the database and merges
then the datatables from device and from the server.

When I let run the program until there is no more free memory then a
messagebox is displayed for aborting a running program.


Meanwhile I have found the statement which produces the memory leak: I call
the Select function from the datatable for receiving the changed rows. Then
I creat a new datatable and copy the rows returned from the select call.
When I do not use this select function then the free memory remains
constant.
I have found that using the select function produces memory laeks generally.
It isn't a big problem for me to replace the call at this position, but I
use the select function on many places and in more complicated cases in the
program. I need a real solution.



.



Relevant Pages

  • Re: dataset safety?
    ... It is up to you how many times you update the database, ... changed rows are updated, not a complete dataset. ... I am currently looking at re-writing a payroll/timesheet application that ... Up till now I have been experimenting and using strongly typed datasets as ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Low performance with only one trusted program
    ... Microsoft MVP [Windows] ... | all of them run the database application smoothly, well, not all. ... | while executing the database application. ... | much more free memory available in the system but it doesn't take it; ...
    (microsoft.public.win2000.general)
  • Low performance with only one trusted program
    ... center of primary atention. ... all of them run the database application smoothly, well, not all. ... while executing the database application. ... much more free memory available in the system but it doesn't take it; ...
    (microsoft.public.win2000.general)
  • Re: update datagrid
    ... updates, connection to the database? ... do you have an snippet I can see how this is done? ... Im' not using a typed dataset, ... update only the changed rows to the database? ...
    (microsoft.public.dotnet.framework.aspnet)
  • ES80 with loads of memory paging out processes
    ... Why do processes page out if there is plenty of ... see if the process exists and notify me - I beefed it up a bit to notify ... long-running database query. ...
    (Tru64-UNIX-Managers)