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"
<[email protected]>
An
"For users and developers of the Firebird .NET providers"
<[email protected]>
Kopie
Thema
Re: [Firebird-net-provider] performance-problem using .net-provider
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 needs 13,4s to give over 600.00
results.
Are yoiu sure IBExpert is returning all the rows at the same time ??
--
Carlos Guzmán Álvarez
Vigo-Spain
http://carlosga.wordpress.com
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's
challenge
Build the coolest Linux based applications with Moblin SDK & win great
prizes
Grand prize is a trip for two to an Open Source event anywhere in the
world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
SICK Engineering GmbH - Sitz: Ottendorf-Okrilla - Handelsregister: Dresden
HRB 3435
Geschäftsführer: Dr. Volker Herrmann - Frank Knöfel
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
