Re: NT speeds-ups?

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. 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. Greg Adrian Blakey wrote: > > We have a client running on NT and an Online 7.2 server running on UNIX > over a slow WAN. We need to squeeze every bit of performance we can out > of the communications link. We are doing the obvious things to ensure > the database runs fast and trying to move some processing into stored > procedures. Replication is not an option due to support and maintenance > cost and purchase expense of additional equipment, and culture of > centralized data management. > > Therefore, has anyone got any tips about: > > 1) Reducing the latency in the client/server connection. > 2) Packing more bits into the same space on the line? > > Things we have thought of: > > 1) Larger TCP/IP buffers on NT. -- Can this be done? how? > 2) Using more compact datatypes. > 3) Ensuring we are doing select col1...coln and not select *. > > Any other ideas? and successful results that can be shared?