Hello:
1. I changed query but ut's the same.
> 2. Yes, there are ascending indexes.
> 3. Not very. The file is about 3Gb and op table has about 4,000,000
> records.
> 4. Executing stored procedure takes the same time. According to profiler it
> is Prepare method that takes most of the time.
> 5. IBExpert 2.0 seems to run query faster but I can be mistaken.
>
Coyuld you show us the code that is running the query, please ??
--
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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
