[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: SQLite for temp tables

  • Thread starter Thread starter jankeir
  • Start date Start date
Status
Not open for further replies.
J

jankeir

Guest
> not yet for 10 GbE. but i have done comparisons of 1 GbE network client-server with shared memory and for some cases they are nearly equal. We have used dedicated 10GbE links between appserver & db for a while while waiting for a new server that could handle all our load (that was with 11.3 and about 2 years ago.) After heavy tuning, including large package sizes in both TCP & ABL we managed to get queries that return large result sets to work as fast as shared memory, but like others have said, as soon as you have to do lots of find firsts the performance drops dramatically. As a result our appserver request duration on production workloads was about 3 times higher on the networked appserver compared to the shared memory appserver.

Continue reading...
 
Status
Not open for further replies.
Back
Top