Sorry 4 multiple postings, our mail-server had problems and cached the
mails for 2 days.
Still need some ideas here how to find the cause for my performance
mismatch.
SICK Engineering GmbH - Sitz: Ottendorf-Okrilla - Handelsregister: Dresden
HRB 3435
Geschäftsführer: Dr. Volker Herrmann - Fr
Yes I'am sure, I used "Execute and Fetch all", If I just use "Execute"
the query is finished in 47ms revealing only 30 records.
Hello:
Testquery:
SELECT * FROM RECORDED_FLOAT_VALUE WHERE FK_MEASUREMENT_RECORDING IN
([some id's like 91, 92, 93...])
If i run this query in ibexpert-consoleit
Yes I'am sure, I used "Execute and Fetch all", If I just use "Execute"
the query is finished in 47ms revealing only 30 records.
Carlos <[EMAIL PROTECTED]>
16.10.2008 17:57
Bitte antworten an
"For users and developers of the Firebird .NET providers"
An
"For users and developers of the Fir
Yes I'am sure, I used "Execute and Fetch all", If I just use "Execute"
the query is finished in 47ms revealing only 30 records.
Carlos <[EMAIL PROTECTED]>
16.10.2008 17:57
Bitte antworten an
"For users and developers of the Firebird .NET providers"
An
"For users and developers of the Fir
Yes I'am sure,
I used "Execute and Fetch all", If I just use "Execute" the query is
finished in 47ms revealing only 30 records.
Carlos <[EMAIL PROTECTED]> schrieb am 16.10.2008 17:57:20:
> Hello:
> Testquery:
> SELECT * FROM RECORDED_FLOAT_VALUE WHERE FK_MEASUREMENT_RECORDING IN
> ([some id
I am using firebird-embedded 2.1 and latest stable
firebirdsql.data.firebirdclient.dll.
I have investigated the poor database-query performance in my program.
I have a simple table RECORDED_FLOAT_VALUE with 4 Columns:
FK_VALUE_DEFINITION (integer)
FK_MEASUREMENT_RECORDING (integer)
ELAPSED_TIME (