Running a recursive cte against a table with about 1600 rows from my program
needs the same time so I think it's providers issue.
Here is source code:
FbCommand cmd = BuildCommand(DbCommand);
cmd.Parameters.AddWithValue("@from", From);
cmd.Parameters.AddWithValue("@to", To);
cmd.Parameters.AddWithValue("@code", Code);
try
{
cmd.Connection.Open();
//This needs 0.028 seconds.
return cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
This code is in a separate function and is called about 2000 times.
On Tue, Sep 30, 2008 at 1:16 PM, Carliños <[EMAIL PROTECTED]> wrote:
> 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 <http://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
>
>
-------------------------------------------------------------------------
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
