好像偶的Oracle到了极限？ - 未名空间MITBBS历史存档

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

Redian新闻

>未名空间

>Database - 数据库

好像偶的Oracle到了极限？

好像偶的Oracle到了极限？# Database - 数据库

q*z2001-04-10 07:04

1 楼

每秒大约200 个 'Insert '，每个也就几十个byte的数据， CPU
usage 就超过90%了！再多反映就有明显延迟了。这是到了极限了吗
？
偶用的是 DELL Server, PIII 600, Win2k Server, Oracle 8i
自己写的 ADO program.

a*a2001-04-10 07:04

2 楼

I hate Oracle but I guess you can check these:
1. your threading model, STA/MTA/Free threading/Neutral?
2. do you enable connection pooling?
3. your number of CPUs/Memory?
4. Written in VB or VC? VC is 40%-50% faster than VB. (in
PCWeek Test (Nile), VB/COM+ runs at 1981 TPC, VC/ISAPI at
3441, Oracle8i/Solaris at 1039).
For more about performance tips on Windows, check
http://msdn.microsoft.com/library/techart/docu2kbench.htm#do
cu2kbench_topic2.

【在 q*z 的大作中提到】

: 每秒大约200 个 'Insert '，每个也就几十个byte的数据， CPU
: usage 就超过90%了！再多反映就有明显延迟了。这是到了极限了吗
: ？
: 偶用的是 DELL Server, PIII 600, Win2k Server, Oracle 8i
: 自己写的 ADO program.

q*z2001-04-10 07:04

3 楼

不知道阿, 这些都是什么东东？
有一个一直开着的 Connection Object
1 CPU, 768MB
VC++ 6.
BTW, does anybody know oo4o (Oracle Object for Ole)? Will it
help ?
Thanks!

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

: I hate Oracle but I guess you can check these:
: 1. your threading model, STA/MTA/Free threading/Neutral?
: 2. do you enable connection pooling?
: 3. your number of CPUs/Memory?
: 4. Written in VB or VC? VC is 40%-50% faster than VB. (in
: PCWeek Test (Nile), VB/COM+ runs at 1981 TPC, VC/ISAPI at
: 3441, Oracle8i/Solaris at 1039).
: For more about performance tips on Windows, check
: http://msdn.microsoft.com/library/techart/docu2kbench.htm#do
: cu2kbench_topic2.

s*s2001-04-10 07:04

4 楼

If you care about turn about time (reponse time), try to
create some
index if your insert statment has "where" clause.
If you just loading a lot of thing into oracle table, try to
using bulk loading,
like sqlldr, or direct path loading.
The proformance is heavily depends on your hard ware and
software setting.
If you are DBA, try to increase the memory size.
If you care about the total thoughtput, it is another
picture. I believe,
there is a "oracle tuning" secion in oracle document. You
can tr

【在 q*z 的大作中提到】