Ed Grimm wrote: > First, I'll suggest that there are hopefully other areas you can look at > optimizing that will get you a bigger bang for your time - in my test > environment (old hardware), it takes 7.4 ms per > disconnect/reconnect/rebind and 4.8 ms per rebind. Admittedly, I'm > dealing with LDAP instead of SQL, and I've no idea how they compare.
Connecting to Oracle can take 30 seconds on a busy system. It doesn't usually take that long, but it often takes a second or two. It is a very important optimization to hold the connection. Postgres may not be as bad, but it's common for SQL systems to have slow connection times. There are databases that allow you to change the current user without reconnecting. In fact someone posted a module to do this a while back, but I can't remember which database it was for. Seems like it was Sybase or Informix. - Perrin
