BenchMark

For test I used 2 computers:

• PIII 866, 256 RAM,
  Oracle 8.1.7,
  Microsoft SQL 7
  both running in the same time.
  OS: Win XP
  
  
• PIII 900, 128 RAM,
  Zope 2.5.0,
  Apache Tomcat 4.0.3.
  OS: Win XP

Insert 10000 records.

Search for 'aa' string.

10 simultaneous requests:

• Zope-jsp on oracle: 115ms
• Tomcat on oracle: 103ms
• Zope-jsp on ms: 75ms
• Tomcat on ms: 67ms

---

Insert 1 000 000 records.

Search for 'aa' string.

1 request each time:

• Zope-jsp on oracle: 5012ms
• Tomcat on oracle: 4858ms
• Zope-jsp on ms: 3400ms
• Tomcat on ms: 3301ms

I'm not so good on Oracle to optimize the server,
but what I want here is to see difference between
Zope-jsp and Apache Tomcat.


The test file : bench.zexp

Download bench.zexp and import it from Zope into a JSP Folder.
Then create two databases (called dataweb on this benchmark)
one for Microsoft and one for Oracle.
Edit the scripts if you want; I let default SQL installed passwords.