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

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.14select 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? These are both 4 processor HP 9000 K220s with 1G of memory and running HP-UX 10.01. Our network cards are 10BaseT. Each machine hangs directly off a 100BaseT cut-through switch. John White Sysadmin and DBA Cluett-Peabody jwhite@arrowshirt.com