Re: Used memory is smaller by ActiveSync?
From: Kevin Collins \(MS - SQL Mobile\) (kevincol_at_online.microsoft.com)
Date: 10/22/04
- Next message: Nury Sword: "SQL CE size and performance advice"
- Previous message: Darren Shaffer: "Re: RDA Pull Error"
- In reply to: Khanh: "Re: Used memory is smaller by ActiveSync?"
- Next in thread: Khanh: "Re: Used memory is smaller by ActiveSync?"
- Reply: Khanh: "Re: Used memory is smaller by ActiveSync?"
- Messages sorted by: [ date ] [ thread ]
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
- Next message: Nury Sword: "SQL CE size and performance advice"
- Previous message: Darren Shaffer: "Re: RDA Pull Error"
- In reply to: Khanh: "Re: Used memory is smaller by ActiveSync?"
- Next in thread: Khanh: "Re: Used memory is smaller by ActiveSync?"
- Reply: Khanh: "Re: Used memory is smaller by ActiveSync?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|