5 messages in com.mysql.lists.win32Re: Server returns query slower than ...| From | Sent On | Attachments |
|---|---|---|
| Greg Quinn | 14 Jan 2005 06:24 | |
| matt_lists | 14 Jan 2005 06:31 | |
| Daniel da Veiga | 14 Jan 2005 06:56 | |
| matt_lists | 14 Jan 2005 07:19 | |
| Daniel da Veiga | 14 Jan 2005 07:41 |
| Subject: | Re: Server returns query slower than desktop |
|---|---|
| From: | Daniel da Veiga (dani...@gmail.com) |
| Date: | 01/14/2005 07:41:39 AM |
| List: | com.mysql.lists.win32 |
Configuring Windows for fast TCP/IP performance is not simple, each network has its own personal optimal config, there is an easy formula to calculate the optimal window packet size for Windows operating system... The problem for me was that the Windows default setting was not the best for my network architeture (it happens a lot, the system can't have defaults for every net config)... I changed it from 16 to 24.
Here you can find an easy way, described by Neil Carpenter... http://blogs.msdn.com/neilcar/archive/2004/10/26/247886.aspx
You can use the information on this site: http://www.psc.edu/networking/projects/tcptune/ to tune your settings.
There are lots of free software that allows you to change this settings, do some research and you may get a 10 to 20% faster tcp/ip performance.
PS: ALWAYS BACKUP YOUR CONFIG before doying any changes!
Best regards,
On Fri, 14 Jan 2005 10:19:49 -0500, matt_lists <matt...@xotech-llc.com> wrote:
Daniel da Veiga wrote:
Packet fragmentation used to bother me too, but with some router and software configuration (packet sizes and TTL) it was fixed.
There's soemthing that has not come up often
any sugestions on size & ttl settings?
-- Daniel da Veiga Computer Operator - RS - Brazil