Re: dbaccess faster than ESQL/C ?

Bill Ennis wrote: > > 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). Yes, I am using exactly the same network facility in both cases. I created a test environment with two modems on our companys internal telephone net. No other programs or net traffic went over the SLIP connection. I tested the query several times, so both ESQL/C and dbaccess could use cached data. I think the big time difference results of the number of SLIP packets and the overhead of the IP packets with only a few bytes data. > 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. Good idea! I will try this and let you know the result. Robert