|
Home > Archive > SQL Anywhere Mobile > October 2005 > Mobilink is downloading slower than PB Pipeline
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Mobilink is downloading slower than PB Pipeline
|
|
|
| Mobilink is downloading slower than PB Pipeline.
I am running
ASA 9.0.2 DB, mobilink client & mobilink server all on the same m/c
ase 12.5.3 in the server.
The initial download of 300K+ records when done using pipeline downloaded
within 5 minutes, whereas the mobilink took 20 minutes & the remote server
download (created a proxy table name for the server table) also took the
same time.
The reason why the pipeline is faster is that it commits the records in
increment of 1000 & so it is faster. Also it is going through cache files
where it is being written.
Is there a way to do this in mobilink to commit at intervals of records
during download rather than waiting for the whole transaction.
also how to stop using the cache file
thanks in adavance.
vsv
ps: also the log file for pipeline insert is smaller than when i use
mobilink.
| |
| Greg Fenton 2005-09-15, 3:24 am |
| vsv wrote:
> Is there a way to do this in mobilink to commit at intervals of records
> during download rather than waiting for the whole transaction.
No there is not.
> ps: also the log file for pipeline insert is smaller than when i use
> mobilink.
That's very interesting...I cannot fathom why that would be. Can you
translate the log file after each approach and compare the SQL of both
approaches to see what the difference is in approaches?
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
| user@domain.invalid 2005-10-27, 8:21 am |
| Can you please tell me what is the PB Pipeline?
Greg Fenton wrote:
> vsv wrote:
>
>
>
> No there is not.
>
>
>
> That's very interesting...I cannot fathom why that would be. Can you
> translate the log file after each approach and compare the SQL of both
> approaches to see what the difference is in approaches?
>
> greg.fenton
|
|
|
|
|