Re: Low performance due high network latency - batching ?

2009-10-21 Thread Johan De Meersman
Well, it's not exactly a clean approach, but if those are the limits you have to work within, so be it :-) I suspect you could gain some more performance by using MySQL's multiple select syntax. It's rougly like this: insert into *table* (*field*, *field*, *field*) values (*value*, *value*, *

Re: Low performance due high network latency - batching ?

2009-10-21 Thread Dan Nelson
In the last episode (Oct 20), Bermejo, Rodrigo (GE Infra, Aviation) said: We are facing a preformance issue with a desktop application which connects remotly to a Mysql / DB ( ping times 300-800ms). We do not have time to invest in modifications to create a 2-tier ... Web application The

Low performance due high network latency - batching ?

2009-10-20 Thread Bermejo, Rodrigo (GE Infra, Aviation)
Hola List /. We are facing a preformance issue with a desktop application which connects remotly to a Mysql / DB ( ping times 300-800ms). We do not have time to invest in modifications to create a 2-tier ... Web application The initial plan was to implement a Client cache or a local DB (mysql