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

If I understand you correctly, your fetching all rows via the network. Which means to me, that you do a transfer of 44 MB. Your 2nd query with only one col shows the effect of less network traffic. The question is: Is there a multi-user client-server application, which has to be capable to load 105365 rows in 34 secs? For me, this looks like a typical server-job, which should reside on the same machine than the DB-Server. Roland 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? > > 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