Re: small table takes more time as compared to bigger table
From: bhonaker <bhonaker_at_gmail.com>
Date: Wed, 18 May 2011 05:14:22 -0700 (PDT)
Message-ID: <92b0b284-a076-4a3b-8f03-ef610afef629_at_l14g2000pro.googlegroups.com>
On May 18, 4:55 am, MadhavC <choudhar..._at_gmail.com> wrote:
> The 16000 times query is not at the same time.These queries are fired
> as and when the application passes through this area of the code. I am
> gathering the cumulative timings for these queries.
Date: Wed, 18 May 2011 05:14:22 -0700 (PDT)
Message-ID: <92b0b284-a076-4a3b-8f03-ef610afef629_at_l14g2000pro.googlegroups.com>
On May 18, 4:55 am, MadhavC <choudhar..._at_gmail.com> wrote:
> The 16000 times query is not at the same time.These queries are fired
> as and when the application passes through this area of the code. I am
> gathering the cumulative timings for these queries.
So you are running a query 16000 times against a table with 5 million rows and the process completes in milliseconds? Does not compute... Received on Wed May 18 2011 - 07:14:22 CDT