测试报告:Win2003下ASP(MSSQL2005/Access)和PHP(Mysql)性能对比
数据:有索引,查询七百万数据库的表:
ASP+MSSQL2005(IIS6):
Hit Count: 12509
Socket connects: 12509
Total Bytes Sent (in KB): 3055.48
Bytes Sent Rate (in KB/s): 50.93
Total Bytes Recv (in KB): 5449.13
Bytes Recv Rate (in KB/s): 90.82
ASP+Access(IIS6):
Number of hits: 1279
Socket Connects: 1279
Total Bytes Sent (in KB): 313.50
Bytes Sent Rate (in KB/s): 5.23
Total Bytes Recv (in KB): 555.82
Bytes Recv Rate (in KB/s): 9.26
PHP+MYSQL ( Apache 2.2 ):
Hit Count: 11400
Socket connects: 11400
Total Bytes Sent (in KB): 2170.90
Bytes Sent Rate (in KB/s): 36.18
Total Bytes Recv (in KB): 12807.67
Bytes Recv Rate (in KB/s): 213.47
得出结果:在数据量很大的时候,Mssql性能远远超过Access的查询性能,MSSQL2005和Mysql在Win2003平台下性能不相伯仲,我们在建立大型网站的时候,如果要考虑程序语言的选择,可以参考以上数据。