Gaetano, > Of course your are speaking about the "worst case", I aplly in scenarios like > this on the rule 80/20: 80% of connection will perform a sort and 20% will allocate > memory for the sort operation in the same window time:
Well, I suppose it depends on how aggresive your connection pooling is. If you minimize idle connections, then 300 connections can mean 200 concurrent queries. And since Paul *is* having problems, this is worth looking into. -- -Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])