On Thu, 2005-05-19 at 11:32, Chuming Chen wrote: > Hi, all, > > If the client didn't close the connection explicitly, how long it will > be kept then closed by the server. Does this effect the performance? Until the TCP/IP timeout occurs, which is usually several hours. It only affects performance if there's a lot (like several hundred) dead connections laying around, or if there are so many you run out of connections and your app can't get to the database.