Re: Memory problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I am having this exact same problem. I don't know for sure whether it is my
selects, though it could be. How do you know how much free memory you have
left, and how can you tell what calls are causing the leaks?

I am getting Out Of Memory exceptions after an hour or so of running. If a
select from SQL CE causes memory leaks I can't fix, what am I supposed to
do?


"S. Berwanger" <S.Berwanger@xxxxxxxxxx> wrote in message
news:um1Vj%23T4FHA.268@xxxxxxxxxxxxxxxxxxxxxxx
> 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: Same question - Why use a DataTable in ASP .NET?
    ... really need read-only access to the data, some developers prefer DataTables ... closed - thereby leaking connections to the database. ... When a good deal of memory is consumed, the web server starts ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: dataset Performence Issue
    ... Microsoft that a DataSet is okay to abuse as a DataBase. ... Managed Code can never be as fast and as optimized ... very good for 90% of the situations i.e. normal memory usage, ... Merge/GetChanges - and oh lets not forget keeping your disconnected cache ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: To Normalize or not ??
    ... The problem is that when you run a split database, ... save a word document (it is in memory, and thus does not get saved). ... ms-access is different then excel or word. ... database server. ...
    (microsoft.public.access.formscoding)
  • Re: TimesTen and In Memory Databases.....
    ... I have been assigned to evaluate the TimesTen in memory database ... Please note I am not a DBA but I do have quite a bit of systems ... This can hurt TimesTen performance (and Oracle ... Right - link Times Ten into your application memory, ...
    (comp.databases.oracle.server)
  • Re: Can I Trust Pointer Arithmetic In Re-Allocated Memory?
    ... and leaving the database in an undefined state. ... memory and leave data it arrived unchanged. ... have already allocated with a null pointer. ... SOME people have to clean up in that fashion. ...
    (comp.lang.c)