[Tom Nixon]
I am in the process of evaluating Zope and so far it looks great.
I have one question about Zope's database: How does it compare in performance to a relational database server? I am think about a scenario such as a recruitment site with a large database of jobs and candidates. Would the Zope database manage it OK or is it normal to run a database server such as mySQL alongside it for the heavy-duty stuff?
Yes, it is feasible and normal to use a relational database with Zope. Zope gives you very good support for working with relational databases. You can use ODBC or various database-specific database drivers. Zope will manage transactions for you.
Is it possible to build complex queries on the Zope database?
The Zope database doesn't have an extensive query language comparable to SQL, and there is no native join-like construction as best I understand things. Cheers, Tom P