[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

Re: Gigabit ethernet cards



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.

-- 
http://www.coker.com.au/selinux/   My NSA Security Enhanced Linux packages
http://www.coker.com.au/bonnie++/  Bonnie++ hard drive benchmark
http://www.coker.com.au/postal/    Postal SMTP/POP benchmark
http://www.coker.com.au/~russell/  My home page



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]