Eric Haszlakiewicz wrote:
>> The log is misleading; the first statement is not really executed,
>> it is only prepared (parsed). If you set the log level to DEBUG2, it
>> will look like:
>
> Yes, but it's still incurring the overhead of sending the message to the
> server, isn't it?
Yes.
>> Mayb
>-Original Message-
>From: Albe Laurenz [mailto:laurenz.a...@wien.gv.at]
>Eric Haszlakiewicz wrote:
>> const char *SQL_text = "select * from foo"; (not always
>the same query)
>> exec sql prepare s_1ab from :SQL_text; < [*1]
>> exec sql declare c_1ab cursor for s_1ab;
>
>-Original Message-
>From: Albe Laurenz [mailto:laurenz.a...@wien.gv.at]
>>
>> const char *SQL_text = "select * from foo"; (not always
>the same query)
>> exec sql prepare s_1ab from :SQL_text; < [*1]
>> exec sql declare c_1ab cursor for s_1ab;
>> exec sql open c_1
Eric Haszlakiewicz wrote:
> I noticed a bit of a performance regression in embedded sql queries when
> moving from the client libraries in verison 8.2.4 to 8.3.7. My
> application does a whole lot of queries, many of which don't return any
> data. When we moved to the new libraries the time of ru
I noticed a bit of a performance regression in embedded sql queries when
moving from the client libraries in verison 8.2.4 to 8.3.7. My
application does a whole lot of queries, many of which don't return any
data. When we moved to the new libraries the time of running a query
(from the applicati
