Re: dbaccess faster than ESQL/C ?
Are you using the same network facility in ESQL as with dbaccess?
WHich di you run first? The reason I ask is because whichever is
running second has the benefit of the data being cached (unless
you bounce the engine in between runs).
The only things I see that can make a difference in your C code
are the following:
You're using a cursor WITH HOLD. dbaccess probably in not using
a HOLD cursor. This is a long shot. I'd really be interested if
you found such a performance hit with HOLD cursors - so let me now.
-Bill
}
} Hi all,
}
} I am using a SLIP connection to run a query using ESQL/C and dbaccess.
} Both client and server are HP9000/7xx machines using HP-UX 9.05 and ppl
} to establish the IP connection. I am running Informix ESQL/C 7.10 UD1 on
} the client and a SE of the same version on the server.
} When I am running a simple select query returning 74 hits 6 Bytes each
} on the informix demonstration database, it takes dbaccess 2-3 seconds to
} put the result to a file. Using a simple ESQL/C program the same query
} takes 15 seconds only to read the data.
} Analysing the ppl-logfiles showed that the query using dbaccess
} transmitted 26 IP-packets while ESQL/C needed 90 IP-packets.
} I tried to increase the size of the Fetchbuffer, but it showed no
} result.
}
} TIA for your help
} Robert
}
} --------------------------------------------------------------------
} Here is the sourcecode:
}
} dbaccess:
}
} select stock_num, unit
} from stock;
}
}
} ESQL/C:
}
} #include <time.h>
} EXEC SQL INCLUDE sqlca;
}
}
} int getDataFromStores()
} {
} int anz_rows=0;
} int fehler=0;
} EXEC SQL BEGIN DECLARE SECTION;
} char statement[512];
} char s_unit[8];
} short s_num;
} EXEC SQL END DECLARE SECTION;
}
} sprintf(statement, "select stock_num, unit from stock");
} EXEC SQL prepare s5 from :statement;
} EXEC SQL declare s_cur5 cursor with hold for s5;
} EXEC SQL open s_cur5;
} for(;;)
} {
} EXEC SQL fetch s_cur5 into :s_num, :s_unit;
} if(SQLSTATE[0]!='0' || SQLSTATE[1]!='0')
} {
} if(strncmp(SQLSTATE, "02", 2)!=0 || anz_rows==0)
} fehler=-1;
} break;
} }
} anz_rows++;
} }
} EXEC SQL close s_cur5;
} EXEC SQL free s_cur5;
} EXEC SQL free s5;
} if (fehler==-1)
} return(0);
} else
} return(anz_rows);
} }
}
}
} int main()
} {
} int liste;
} time_t start, ende;
}
} FetBufSize=10000;
}
} EXEC SQL CONNECT TO "stores7";
}
} start=time(NULL);
} liste = getDataFromStores();
} ende=time(NULL);
}
} printf("%d rows read in %d seconds\\n", liste, ende-start);
} EXEC SQL DISCONNECT ALL;
} return 1;
} }
}
--
Bill Ennis Voice: 312-474-7516
SSA Fax: 312-474-7460
500 W. Madison email: ennis@ssax.com ennis@accesschicago.net