Why SQL Server 7 Enterprise Manager is so slow? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Why SQL Server 7 Enterprise Manager is so slow?

Why SQL Server 7 Enterprise Manager is so slow?# Database - 数据库

i*s2099-12-18 08:12

1 楼

Comrades,
Recently I upgrade my SQL Server 6.5 to 7, and is
surprised to find that both the ISQL and Enterprise
Manager is very, very slow.
In 6.5 MS still use DB-Library & Net-Lbirary for these
two tools, but in 7.0 MS changed to ADO+OLE DB provider.
But its performance is really so bad?
Who can tell me why? My configuration?

a*e2099-12-18 08:12

2 楼

"If it is from Microsoft, it must be slow." (tm)
no offense, but I just cannot help it :)

【在 i**s 的大作中提到】

: Comrades,
: Recently I upgrade my SQL Server 6.5 to 7, and is
: surprised to find that both the ISQL and Enterprise
: Manager is very, very slow.
: In 6.5 MS still use DB-Library & Net-Lbirary for these
: two tools, but in 7.0 MS changed to ADO+OLE DB provider.
: But its performance is really so bad?
: Who can tell me why? My configuration?

b*e2099-12-18 08:12

3 楼

i thought i read a benchmark somewhere the sqlserver 7
is now the fastest db

【在 a*****e 的大作中提到】

: "If it is from Microsoft, it must be slow." (tm)
: no offense, but I just cannot help it :)

a*e2099-12-18 08:12

4 楼

If not a coincident, my friend telling me he switched from sqlserver 7
to mysql just because the sqlserver could not deliver the speed for
querying tables of 300k rows.

【在 b****e 的大作中提到】

: i thought i read a benchmark somewhere the sqlserver 7
: is now the fastest db

b*e2099-12-18 08:12

5 楼

i don't know about that.. but it's very likely that your friend
didn't configure things properly..
anyway.. in optimized situations.. here's what i found:
SQL Server Sets World Record for All Platforms with TPC-C Benchmark
SQL Server 2000 Enterprise Edition running on Microsoft Windows2000 Advanced Server and using native Windows 2000 COM+ transaction support as the transaction processing monitor, set a new world record for the TPC-C benchmark, an industry-standard test
measuring transaction pro