Re: [Firebird-net-provider] ExecuteReader is slow

Hello: > ExecuteReader() takes 0.029 seconds. > Read() takes 0.026 seconds. What is the amount of data being fetched ?? remember that Read will fetch rows in packs of 200, by default, when working against the classic/superserver firebird server ( subsequents reads will work agsint the fetched ro

Re: [Firebird-net-provider] ExecuteReader is slow

Guys, please, can you do some proper quoting. The HTML garbage is not neccessary here. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - This SF.Net email is sponsored by th

Re: [Firebird-net-provider] ExecuteReader is slow

There are three separate indexes. I reorganized my select command, and created stored procedures for them instead of calling them directly. Here are my timing results: ExecuteReader() takes about 0.02 seconds. Read() takes 0.4 seconds which is really much. However, when I run those queries from m

Re: [Firebird-net-provider] ExecuteReader is slow

Hi Giorgi, If this is a routine you are calling many times, I would think that keeping a connection open would be far greater improvement to your performance. If you aren't using connection pooling, you should. Furthermore, it might be wiser to pass the connection into the routine being ca

Re: [Firebird-net-provider] ExecuteReader is slow

From: giorgi giorgi [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2008 12:23 To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] ExecuteReader is slow Running a recursive cte against a table with about 1600 rows from my program

Re: [Firebird-net-provider] ExecuteReader is slow

From: giorgi giorgi [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2008 09:41 To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] ExecuteReader is slow Hello, I am using 2.1 version of firebird. Fb.NEt provider version is 2.0.1.0

Re: [Firebird-net-provider] ExecuteReader is slow

-provider] ExecuteReader is slow Well, it is fast if you call it once but for 2000 class it's about one minute. It's taking about 85% of the whole action. On Tue, Sep 30, 2008 at 11:16 AM, Steve Faleiro <[EMAIL PROTECTED]> wrote: IMHO, 0.028 seconds seems to be pretty quick. That

Re: [Firebird-net-provider] ExecuteReader is slow

> -Original Message- > From: Steve Faleiro [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 30, 2008 11:29 > To: For users and developers of the Firebird .NET providers > Subject: Re: [Firebird-net-provider] ExecuteReader is slow > > > 1. Did you try to opt

Re: [Firebird-net-provider] ExecuteReader is slow

giorgi giorgi wrote: > Hello, > > I am developing an application that uses firebird database and I use > firebird provider for ado.net The application makes > many calls to ExecuteCommand method of FbCommandClass. According to .net > performance provider it is the slowest metho

Re: [Firebird-net-provider] ExecuteReader is slow

There are three separate indexes. I reorganized my select command, and created stored procedures for them instead of calling them directly. Here are my timing results: ExecuteReader() takes about 0.02 seconds. Read() takes 0.4 seconds which is really much. However, when I run those queries from m

Re: [Firebird-net-provider] ExecuteReader is slow

giorgi giorgi wrote: > 2. Yes, there are ascending indexes. Is it three separate indexes, or is it one index for all of them? The problem is your SQL statement, it's not the data provider. You can use the SET PLAN (or SET PLANONLY) commands in isql to work out which indexes (if any) the optimizer

Re: [Firebird-net-provider] ExecuteReader is slow

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

Re: [Firebird-net-provider] ExecuteReader is slow

On Tue, Sep 30, 2008 at 11:23 AM, giorgi giorgi <[EMAIL PROTECTED]> wrote: > This code is in a separate function and is called about 2000 times. To be true, this code is rubbish. Think about (at least) preparing your command, as Paul Mercea said. Maybe some better object handling and/or connection

Re: [Firebird-net-provider] ExecuteReader is slow

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.AddWi

Re: [Firebird-net-provider] ExecuteReader is slow

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. I

Re: [Firebird-net-provider] ExecuteReader is slow

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 index

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. 5. IBExpert 2.0 seems to

Re: [Firebird-net-provider] ExecuteReader is slow

1. Did you try to optimize the query? I know Firebird has an optimizer that optimizes every query but sometimes a Instead of: > "SELECT SUM(nsum), card FROM op WHERE > smth >= @from AND smth<= @to AND > bal = @code group by card" Try: > "SELECT card, SUM(nsum) FROM op WHERE > smth >=

Re: [Firebird-net-provider] ExecuteReader is slow

Well, it is fast if you call it once but for 2000 class it's about one minute. It's taking about 85% of the whole action. On Tue, Sep 30, 2008 at 11:16 AM, Steve Faleiro <[EMAIL PROTECTED]> wrote: > IMHO, 0.028 seconds seems to be pretty quick. That is 3/10ths of a > second. What were you expecti

Re: [Firebird-net-provider] ExecuteReader is slow

IMHO, 0.028 seconds seems to be pretty quick. That is 3/10ths of a second. What were you expecting? --- giorgi giorgi <[EMAIL PROTECTED]> wrote: > Hello, > > I am using 2.1 version of firebird. Fb.NEt provider version is > 2.0.1.0Connection string looks like this: > "User=SYSDBA;Password=masterk

Re: [Firebird-net-provider] ExecuteReader is slow

giorgi giorgi [mailto:[EMAIL PROTECTED] > *Sent:* Monday, September 29, 2008 12:53 > *To:* firebird-net-provider@lists.sourceforge.net > *Subject:* [Firebird-net-provider] ExecuteReader is slow > > > > Hello, > > I am developing an application that uses firebird database

Re: [Firebird-net-provider] ExecuteReader is slow

From: giorgi giorgi [mailto:[EMAIL PROTECTED] Sent: Monday, September 29, 2008 12:53 To: firebird-net-provider@lists.sourceforge.net Subject: [Firebird-net-provider] ExecuteReader is slow Hello, I am developing an application that uses firebird database and I use firebird provider for

[Firebird-net-provider] ExecuteReader is slow

Hello, I am developing an application that uses firebird database and I use firebird provider for ado.net The application makes many calls to ExecuteCommand method of FbCommandClass. According to .net performance provider it is the slowest method and takes about 0.028 seconds to execute. Why does