非常缓慢的INSERT - 紧急 [英] Very slow INSERTs - URGENT

问题描述

DB2 V8.2 ICE Linux

应用程序在数据库A的表中加载大约600万行

（开发环境）。


相同的应用程序需要很长时间才能在数据库B中加载相同的表格

（UAT环境）。

数据库B应该更快，因为它分区。

它具有参照完整性（RI）和定义的索引。

这对INSERT有重大影响吗？


还有什么需要看的吗？


谢谢。


干杯，

San。

DB2 V8.2 ICE Linux
An application is loading around 6 million rows in a table in database A
(Development environment).

The same application is taking ages to load the same table in database B
(UAT environment).
Database B is supposed to be faster since it is partitioned.
It has Referential integrity (RI) and indexes defined on it.
Does this have a major impact on INSERTs?

Is there anything else that needs to be looked at?

Thanks.

Cheers,
San.

推荐答案

这是一份可能有用的白皮书：

http://www-128.ibm.com/developerwork .. .m-0403wilkins /


另外，仅仅因为数据库已经用DPF分区并不意味着

它会自动更快。您必须确保它具有所需的hw

资源。 hw配置非常重要。


Larry Edelstein


shsandeep写道：

Here is a white paper that may help:

http://www-128.ibm.com/developerwork...m-0403wilkins/

Also, just because a database has been partitioned with DPF doesn''t mean
it will automatically be faster. You have to ensure that it has the hw
resources that it needs. The hw configuration is very important.

Larry Edelstein

shsandeep wrote:

DB2 V8.2 ICE Linux

应用程序在数据库A的表中加载大约600万行

（开发环境）。

相同的应用程序需要花费很长时间才能在数据库B中加载相同的表格

（UAT环境）。

数据库B应该更快，因为它是分区。

它具有参照完整性（RI）和定义的索引。

这对INSERT有重大影响吗？


还有什么需要看的吗？


谢谢。


干杯，

San 。

DB2 V8.2 ICE Linux
An application is loading around 6 million rows in a table in database A
(Development environment).

The same application is taking ages to load the same table in database B
(UAT environment).
Database B is supposed to be faster since it is partitioned.
It has Referential integrity (RI) and indexes defined on it.
Does this have a major impact on INSERTs?

Is there anything else that needs to be looked at?

Thanks.

Cheers,
San.

谢谢Larry！

这正是我想要的......


干杯，

圣。

Thanks Larry!
This is exactly what I was looking for...

Cheers,
San.

San，


如果你有DPF生产你需要DPF开发的环境

环境。不必是相同数量的节点。但DPF它应该是
。


干杯

Serge

-

Serge Rielau

DB2解决方案开发

IBM多伦多实验室


IOD会议
http://www.ibm.com/software/data/ond ... ness / conf2006 /

San,

If you have a DPF production environment you need a DPF development
environment. Doesn''t have to be the same number of nodes. But DPF it
ought to be.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/

这篇关于非常缓慢的INSERT - 紧急的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！