Re: Used memory is smaller by ActiveSync?

From: Kevin Collins \(MS - SQL Mobile\) (kevincol_at_online.microsoft.com)
Date: 10/22/04


Date: Fri, 22 Oct 2004 09:18:13 -0700

thanks for the clarification. I would post this questino to the
PocketPC/Activesync newsgroup to see if they are aware of memory consumption
issues with copying large files. I can't explain the behavior, outside of
that ActiveSync is using / utilizing cache memory on the device when copying
the database that is not utilized when moving the file directly to the SD
card. I am also confident that copying the file directly to the SD would be
a faster operation than copying it over USB via ActiveSync to the device.

"Khanh" <khanh@glassegg.com> wrote in message
news:b76c32be.0410211812.4ca76009@posting.google.com...
> 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



Relevant Pages

  • used memory of storage is smaller by ActiveSync?
    ... Valid area for storage: 90,40 MBs ... Used memory for storage: 77 MBs ... I intend to find out the best solution for deploying a lot of PDA, ...
    (microsoft.public.pocketpc.activesync)
  • Re: used memory of storage is smaller by ActiveSync?
    ... > Valid area for storage: 90,40 MBs ... > Free memory for storage: ... it'd better to synchronize database by 1 PDA ...
    (microsoft.public.pocketpc.activesync)
  • Re: anyone understand torvalds critique of freebsd?
    ... Mach manipulate the VM page table mappings to make that page visible in the process address space rather than copying the sequence of bytes manually via a message-passing paradigm. ... The former approach tends to be more efficient for small amounts of data, especially for things smaller than one page of memory; the latter approach tends to better for things which are bigger in size. ... On the other hand, Mach was the first or among the earliest platforms to support shared libraries, dynamic loading of objects into user processes and into the kernel, and has somewhat better scaling in the face of gigabytes of RAM and VM usage than most Unix flavors do. ...
    (freebsd-questions)
  • Bio & Biovec-1 increasing cache size, never freed during disk IO
    ... high disk IO (copying a lot of data between 2 machines): ... memory get filled up, until the full swap is used and the system must ... mca cmov pat pse36 clflush mmx fxsr sse sse2 syscall nx mmxext ...
    (Linux-Kernel)
  • Re: Im going crazy!! Random CRC?! Help me please
    ... Sounds like memory or mobo\cpu problem to me. ... I get random crc errors. ... I can test this by for example copying a rar archive. ... It also took me three tries installing windows before it wanted to run ...
    (microsoft.public.windowsxp.hardware)