Re: Help! My applications run very slow if running over the network!

jwhite@arrowshirt.com wrote: > > We've got a DB server and an application server. > My 4gl programs run much faster on the DB server than on the application server. > > Here's a test I ran: > > I've got a long, wide table (Rowsize: 426 bytes. Number of Rows: 105365. Table size: 44MB.) > I wrote a 4gl program to time how long it took to walk through the table with a select * cursor. > I wrote a second program to walk the same table, but just select 1 column - a smallint - from each row. > I ran each program on both the DB and application server. On the DB server I ran each program twice, > once using the shared memory socket and once using the network socket (local loopback). > > Here's the timing results: > > DBSRVR (shared mem) DBSRVR (local network loopback) APPSRVR > select * 34.14 52.00 142.14> select 1col 26.47 26.46 26.55 > > Results are in seconds. Each result is the average of three consective tests. I was the only user on the DB. > > Can anyone tell me just what the heck is going on here? Better yet, can anyone tell me how to make this > network bottleneck go away? You're shipping 44M of data plus the overhead of putting it in packets, listening for space on the net, backing off and retransmitting after collisions, etc. I'm not sure what other result you could reasonably expect! How to make it go away? - Only transmit what you need! By the way, did you measure other network traffic, collisions, etc? How long does it take to FTP 44M over your network? Ian Goddard