I was trying to compare the performence between JSP/ASP with some benchmark
tests, and when come across database benchs, there are something very
interesting.
The JDBC driver provided by Microsoft (jar files dated around 4/19/2002)
providedslower access time then SUN's JDBC-ODBC driver. Another one is,
prepared statments runs slower on SQLServer when connected under SUN's
JDBC-ODBC driver.
The test system is a 128Mg AMD Duron 800, 20G of HD space.
AT first JDBC-ODBC was not even considered in the test. After the test we
were stunned by the bad performence of the MS JDBC driver (1/3 of the ASP
ODBC) even when I used correct getXXX methods, prepared statments and
connection polling. Since ASP uses ODBC with a COM wrapper, we dicided to
give JDBC-ODBC a try and found JDBC-ODBC is the same speed as ASP/ODBC.
I think the reason for the slow prepared statment is that it is not
implemented in the buildin COM wrappers, so Microsoft just ignored it.
The results and test script are available at:
http://www.utdallas.edu/~gxz014000/websrv/bench/dataBench/dataBench.html
For other bench marks:
http://www.geocities.com/gzhangx/websrv/bench.html
Hope the information is of some help
Gang
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
