Re: OnLine 5.0 ESQL/C Query timing problems

cwakins@leia.alloys.rmc.com (Clem Akins) wrote: >> Running the same query from the command line always takes about 8 >> seconds. We cannot reproduce the problem on our development system, >> even when using the same data. It only occurs on the customers >> machine. >This is the key. I'm just taking a wild guess, here, but I'd bet your >development box does not recieve the same updates (constantly) as the >customer's. This constant addition to tables could cause your symptoms, >as each addition locks rows. Do your tables have row locking or page? >Do you allow dirty reads (and would that help? Is anybody reading?) Thanks Clem. I think you may be right in that it is the constant updating that is occurring of the live machine that is causing the delays. However, the table has row locking (I wish Informix would make that the default :) and the process doing the select is doing a dirty read. I cannot think of anything else to try, and cannot understand why dbaccess queries are consistently about 8 seconds, cf the ESQL/C queries of 12 to 120 seconds.