database connection problem (halting Zope)
Hello everybody, I started to play with Zope in order to use it as intranet platform. For this I need database access. I tried odbc and MySQL and got it working fine. However we have some existing warehouse queries which take minutes to complete. When I set up ZODBC connection and ZSQL method to access such query, it halts all other Zope activities until it finishes. I tried this both with NT Zope and Linux Zope, ODBC and MySQL DAs. As long as the query runs, no other requests are serviced. I understand that long query blocks database connection, but I thought Zope is threaded, so it should run other requests not using this database connection just fine, no? Could it be that the python binary used is not compiled for threading? I spent yesterday afternoon and this morning looking for solution to this problem on the net, but with no luck yet. Can anybody enlighten me why is that? And what can I do to fix this. Otherwise I like Zope a lot. Easy, featured, just great. Thanks in advance and Best regards, Petr Hrasky -------------------------------------------- IT Department BNP-Dresdner Bank (CR), a.s. +420-2-57006474
+-------[ Hrasky Petr ]---------------------- | Hello everybody, Hi.. | I understand that long query blocks database connection, but I thought | Zope is threaded, so it should run other requests not using this | database connection just fine, no? You are correct, that should be the case. | Could it be that the python binary used is not compiled for threading? Perhaps, but, I think Zope will fail to start if your python does not support threading. | I spent yesterday afternoon and this | morning looking for solution to this problem on the net, but with no | luck yet. | | Can anybody enlighten me why is that? And what can I do to fix this. It might be that the ODBC driver for MySQL is serialising all accesses to MySQL (i.e. the MySQL ODBC driver is not threaded). This is a bit of a guess though. -- Totally Holistic Enterprises Internet| P:+61 7 3870 0066 | Andrew Milton The Internet (Aust) Pty Ltd | F:+61 7 3870 4477 | ACN: 082 081 472 ABN: 83 082 081 472 | M:+61 416 022 411 | Carpe Daemon PO Box 837 Indooroopilly QLD 4068 |akm@theinternet.com.au|
Could it be that the python binary used is not compiled for threading? I spent yesterday afternoon and this
Count on it. That's why the install instructions explain that python isn't compiled with threads by default. -- Tim Cook -- Cook Information Systems | Office: (901) 884-4126 8am-5pm CDT * It's easy to stop making mistakes. Just stop having ideas. * FreePM Project Coordinator http://www.freepm.org OSHCA Founding Supporter http://www.oshca.org
participants (3)
-
Andrew Kenneth Milton -
Hrasky Petr -
Tim Cook