Re: Gigabit ethernet cards

[William Lovaton <williama_lovaton coomeva com co>]

Hi Russell,

That would be true if that query were the only one.  Keep in mind that
there are lots (LOTS!) of other queries executing, aproximately 120
queries per second. That's an old value, today the load is much higher.


-William



El lun, 17-05-2004 a las 16:24, Russell Coker escribió:
> On Tue, 18 May 2004 07:07, William Lovaton <williama_lovaton coomeva com co> 
> wrote:
> > I can measure execution times and there are some queries that takes,
> > let's say 2 seconds executing and 10 seconds fetching the result sets.
> > In this case I can't reduce the number of records because I need the
> > all.  The number is not big though.
> 
> If your 100baseT network is working correctly then a 10 second delay 
> corresponds to 100MB of data being transferred.  Are you sure it's network 
> speed and not database server speed?  Maybe getting faster disks and/or more 
> RAM in the database server will give more benefit.