From: giorgi giorgi [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2008 12:02
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] ExecuteReader is slow
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.
[PM] Have you heard about ‘Prepare once, run many!’ ?
You prepare your statement ONCE and run many times with different parameters!
I doubt the SP can run faster!!!!
Regards,
Paul
-------------------------------------------------------------------------
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
