"prefect" <uykusuz@uykusuz.com> wrote in message
news:%23UGi%23GRHGHA.240@TK2MSFTNGP11.phx.gbl...
>i am using a combination of PULL and SubmitSql to synchronize data between
> PPC and back-end Server.
> I save the INSERT/UPDATE clauses in the PPC to send with SubmitSql
> later. Clients use GPRS. I am thinking to send the SQL scripts partially.
> it seems that sending one by one would be costly and is not prefered.
> What is the ideal number of clauses to send
> considering performance , bandwidth and
> limitations related to RDA (such as the size of the sql script to
> bmit.. ) ?
>
> In my tests , submitsql causes 3-4 Kb transfer between Server and PPC.
> There are routine
> requests independent from the size of the SQL script. i think , each
> clause would add about extra 100 - 200 bytes to data traffic.
>
> thanks so much
> Yener
>
>
>

"Darren Shaffer" <darrenshaffer@discussions.microsoft.com> wrote in message
news:e1YSRaSHGHA.3700@TK2MSFTNGP15.phx.gbl...
> you're really not going to get a quality response to this - there has been
> very little
> published regarding RDA tuning. there is a configurable compression level
> you
> can play with, but other than that, you are going to have to run some
> tests
> on your particular network/device/database to find the sweet-spot in terms
> of how many scripts to submit with each RDA round trip.
>
> Compression Level can vary from 0 to 3. Please refer to SQL Mobile Books
> Online page for RDA.CompressionLevel @
> http://msdn2.microsoft.com/en-us/library/system.data.sqlserverce.sqlceremotedataaccess.compressionlevel.aspx
>
> --
> Darren Shaffer
> .NET Compact Framework MVP
> Principal Architect
> Connected Innovation
> www.connectedinnovation.com
>
> "prefect" <uykusuz@uykusuz.com> wrote in message
> news:%23UGi%23GRHGHA.240@TK2MSFTNGP11.phx.gbl...
>>i am using a combination of PULL and SubmitSql to synchronize data
>>between
>> PPC and back-end Server.
>> I save the INSERT/UPDATE clauses in the PPC to send with SubmitSql
>> later. Clients use GPRS. I am thinking to send the SQL scripts partially.
>> it seems that sending one by one would be costly and is not prefered.
>> What is the ideal number of clauses to send
>> considering performance , bandwidth and
>> limitations related to RDA (such as the size of the sql script to
>> mit.. ) ?
>>
>> In my tests , submitsql causes 3-4 Kb transfer between Server and PPC.
>> There are routine
>> requests independent from the size of the SQL script. i think , each
>> clause would add about extra 100 - 200 bytes to data traffic.
>>
>> thanks so much
>> Yener
>>
>>
>>
>
>