>> Woops, I forgot to say that of course I use a connection pooling. >> Just 5 connections are pooled. >>> How many http connections per second are you getting? >> 200 > > Uh, so all of those http connections have to wait till one of the five > database connections is free? Maybe that's your bottleneck. Try > increasing the number of DB connections to something consistent with > the traffic level. Oddly, increasing the number of connections pooled doesn't increase performance and if I create too much connections (e.g. 15 or 20, performance decrease). I don't know why... because all my queries try to access to the same table and sometime the same record (a problem with the lock ??) Thanx. Guillaume
