Re: NT speeds-ups?

Greg <greg@cyberramp.SPAMCHOKER.net> wrote: :This is your lucky day, we just finished overhauling our client :(Powerbuilder based...), to improve network throughput among other :things. The net result is that we improved response by a factor of 20 :(thats right, twenty...). The client is screamin' fast now, looks like :the server is right under your desk. : :My Recommendations: :1. Set the FET_BUF_SIZE environment variable on both client (INet) and :server. We found 8192 to be pretty optimal, though I suggest playing :with it. The difference is HUGE!! The defaults are atrocious, and you :send lots of mostly empty packets. We tested a couple of ODBC :solutions, but they weren't even close. Could you please tell us what ODBC solutions you tested? We are about to do this same thing (not with PB, but still) and for many reasons prefer to use ODBC. Would be realy interested in some input. :2. In PB, don't use dynamic cursors, always use data stores / data :windows. Much faster. :3. Look for anyplace you can minimize data transfer, we were being :horribly wasteful. Use VARCHARS for big character columns where :appropriate. : :Let me know how it turns out, I'm pretty giggly about our results. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org