Re: Used memory is smaller by ActiveSync?

From: Khanh (khanh_at_glassegg.com)
Date: 10/22/04

  • Next message: dna: "RDA Pull Error" 
    Date: 21 Oct 2004 19:12:56 -0700

    Hi,

    Sorry for my previous unclear post. Let me clear it up.
     
    It is not totally the same operations, PDA1 is synchronized with
    database server directly by Merge, PDA2 database file .SDF is copied
    via ActiveSync from PDA1 (of course through third desktop pc).

    2 PDA are also soft-reseted already, so it seems the memory which is
    used by SQL CE is freed.
    I've just rechecked this morning one more time:
    1. PDA1 is synchronized with database server, after soft-reseted for
    releasing memory:
        File size: 67,8 MBs (checked by file explorer)
        Valid area for storage: 90,40 MBs
        Used memory for storage: 77 MBs
        Free memory for storage: 13,40 MBs
    2. Copy this SDF file from PDA1 to PDA2 (ActiveSync, third desktop pc)
        File size: 67,8 MBs (checked by file explorer)
        Valid area for storage: 73,84 MBs
        Used memory for storage: 45,40 MBs
        Free memory for storage: 28,44 MBs

      I intend to find out the best solution for deploying a lot of PDA,
    and with this phenomenon, it'd better to synchronize database by 1 PDA
    and copy to other ones ?

    Any help would be very appreciated.
    Khanh

    "Kevin Collins \(MS - SQL Mobile\)" <kevincol@online.microsoft.com> wrote in message news:<eAgEN34tEHA.260@TK2MSFTNGP11.phx.gbl>...
    > It's not clear if you are doing the same operations on both devices. SQL
    > Server CE, along with .NET CF will use memory based on what operations have
    > been executed. If you are syncronizing the database, then the SQL Server CE
    > cache is growing in size to hold the temporary transaction database. If you
    > close down the application and restart, you should see the memory be
    > returned to the memory pool immediately. Also, SQL CE will release the
    > memory over time.
    >
    >
    >
    > "Khanh" <khanh@glassegg.com> wrote in message
    > news:b76c32be.0410210645.18f17e9d@posting.google.com...
    > > hi all,
    > >
    > > There is a weird phenomenon that i can't understand why.
    > > My PDA, PocketPC 2003, SQL Server CE, synchronizes master data with
    > > SQL Server 2000 by Merge Replication, and the local database file .sdf
    > > is about 70 MBs. In memory, I saw:
    > > Memory for program:
    > > Used memory: 77MBs
    > >
    > > Then I copied this sdf file to Desktop PC via ActiveSync, then
    > > copied to other PDA. The used memory size is smaller significantly!!!!
    > > Memory for program:
    > > Used memory: 45MBs
    > >
    > > File size is still the same on both PDA: 70 MBs, but used memories
    > > are various !!!!
    > > FYI, PDA is Fujitsu Loox FLX3AW, PocketPC 2003, Japanese version OS
    > >
    > > I would really like to know why. This can help my program having
    > > much free memory to run.
    > >
    > > Thanks,
    > > K

  • Next message: dna: "RDA Pull Error"

    Relevant Pages

    • 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)
    • Re: Memory leak in ASP.NET web site
      ... > I have a web app that makes many queries to the database on every page. ... > string to a method and I am passed a datareader or else individual values ... > There is a horrible memory leak in this application. ... > restored until SQL Server and IIS services are restarted. ...
      (microsoft.public.dotnet.framework.adonet)