Hi! Thanks for the discussion. It certainly make sense to discuss with DB programmers. On Thu, 20 Jan 2000, Anthony Baxter wrote:
More importantly, this _won't_ scale. If I have 20 users, that will be 20 connections held open. Yuk. And say I want to open 2 or 3 connections per user, to remove the single-threaded nature of it, and it's way way worse.
I asked, and he replied: "I don't care about 20, even 200 connections". He works with Oracle at least 3-4 years, and I worked for about a week, so I better do not give him any advice :)
&c &c &c. Aside: if you're using ZOracleDA to talk to Oracle, and for some reason your Oracle connection gets trashed - restart Zope. Don't bother trying to just close and re-open the connection, I've found that leads to a world of pain. It sometimes works. And other times it makes bad things happen.
Bad news :( Thanks.
(I'm also somewhat unconvinced that Oracle's all that secure - would you expose an Oracle server to the internet? I don't think so... :)
Certainly NO! Oleg. ---- Oleg Broytmann Foundation for Effective Policies phd@phd.russ.ru Programmers don't die, they just GOSUB without RETURN.