Re: [Zope-DB] Closing idle DCoracle2 Connections?

2005-10-21 Thread Matthew T. Kromer
However, a colleague found out that for his (probably special kind of) setup, "cxOracle" was much slower than DCOracle2 (by about a factor of 4). heh, well I like to write FAST code when I can ;) However, the Zope DA/RDBMS machinery slows the db conection down enormously -- like 9x if

Re: [Zope-DB] Closing idle DCoracle2 Connections?

2005-10-21 Thread Dieter Maurer
Chris Withers wrote at 2005-10-21 16:27 +0100: > ... >Well, it depends, there can be a need for lots of infrequently used DA's >connecting to the same database. What prevents to replace these DA's by a single instance? Looks much easier than a sophisticated connection pool management... >Having

Re: [Zope-DB] Closing idle DCoracle2 Connections?

2005-10-21 Thread Dieter Maurer
Cynthia Kiser wrote at 2005-10-20 19:09 -0700: > ... >I am pretty sure there is a bug in DCOracle2. If you can, try using >DCOracle2 from the python prompt and close the connection. Now, can >you still talk to the database? It seemed to me that I could when I >tried that. > >For my particular circ

Re: [Zope-DB] MySQL

2005-10-21 Thread Chris Withers
Dario Antonelli wrote: Grazie michele, When I try to execute MySQL-python.exe-1.2.0.win32-py2.4.exe I receive a message Box saying: "...MSVCR71.dll not found" Zope doesn't run with Python 2.4, try downloading the right file ;-) The nasty bit of the dance is that to use the windows installers f

Re: [Zope-DB] Closing idle DCoracle2 Connections?

2005-10-21 Thread Chris Withers
Dieter Maurer wrote: Usually, there is not need for a sophisticated connection management. Just do not create unnecessary DA instances. Yes, this is the most common mistake... Bugs should be fixed and not worked around with more complex software (complex connection management). Well, it dep

Re: [Zope-DB] Closing idle DCoracle2 Connections?

2005-10-21 Thread Chris Withers
Cynthia Kiser wrote: open. FYI just closing the database connection via the ZMI does not release the idle connections Oracle still sees. Yes, that button actually does nothing ;-) Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk

Re: [Zope-DB] MySQL

2005-10-21 Thread Michele Marcionelli
When I try to execute MySQL-python.exe-1.2.0.win32-py2.4.exe I receive a message Box saying: "...MSVCR71.dll not found" (I receive a message in italian..) Thanks Dario I'm sorry, but I don't live in the Windows world... With a quick google-search I found: ".NET Framework SDK Version 1.1:

[Zope-DB] MySQL

2005-10-21 Thread Dario Antonelli
Grazie michele, When I try to execute MySQL-python.exe-1.2.0.win32-py2.4.exe I receive a message Box saying: "...MSVCR71.dll not found" (I receive a message in italian..) Thanks Dario Dario Antonelli - SYREA srl via Archimede, 10 20129 Milano - ITALY e-mail: [EMAIL PROTECTED] web: www.syrea.it t

Re: [Zope-DB] MySQL

2005-10-21 Thread Michele Marcionelli
Ciao Dario, I want to use MySQL in my Zope Installation. But I'm not able to install software (I don't really understand what shall I use and what shall I do...) I'm using Zope: 2.8.1 MySQL 4.1 Windows XP You have to install "MySQL for Python": http://sourceforge.net/projects/mysql-pyt

[Zope-DB] MySQL

2005-10-21 Thread Dario Antonelli
I want to use MySQL in my Zope Installation. But I'm not able to install software (I don't really understand what shall I use and what shall I do...) I'm using Zope: 2.8.1 MySQL 4.1 Windows XP Thank you Dario ___ Zope-DB mailing list Zope-DB@zope.org