Andreas Jung wrote:
--On 20. November 2006 15:27:39 +0000 "Robert (Jamie) Munro" <jamie@textmatters.com> wrote:
Is it possible to get to the python Database API through a database connector in zope? I'd like to use things like cursor.executemany(sql,seq_of_parameters) to make lots of queries run a lot faster.
If you want to use the Python DB API inside Zope then better deal directly with the database by using the Python DB API directly instead of misusing the Zope DAs.
The trouble is that I want to use a mixture of normal ZSQL for most things, and python DBI executemany etc. for the speed critical parts, on the same database in the same zope site on different pages. If I change the database adaptor to point at another DB (e.g. for testing), I want it to change the DB pointed to by my python scripts as well. Robert (Jamie) Munro