RDA question

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
ubmit.. ) ?
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
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/lib...sionlevel.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
> 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
>
>
|||thanks Darren.
"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/lib...sionlevel.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...
>