Re: [Firebird-net-provider] performance-problem using .net-provider

2008-10-21 Thread Robert Krueger
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

Re: [Firebird-net-provider] performance-problem using .net-provider

2008-10-20 Thread Robert Krueger
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

[Firebird-net-provider] Antwort: Re: performance-problem using .net-provider

2008-10-20 Thread Robert Krueger
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

[Firebird-net-provider] Antwort: Re: performance-problem using .net-provider

2008-10-20 Thread Robert Krueger
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

Re: [Firebird-net-provider] performance-problem using .net-provider

2008-10-20 Thread Robert Krueger
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

[Firebird-net-provider] performance-problem using .net-provider

2008-10-16 Thread Robert Krueger
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 (