This website requires Javascript to function properly. Please go to the setting of your web browser and enable Javascript for this website.

Ad by

最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。

Ad by

最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。

check this

ivy_sh(呼吸着的青草)

The goal of using cursor locks is to ensure separate applications don't interfere with one another. Multiuser database applications encounter concurrency problems whenever several users try to access or update the same information at the same time. Concurrency has to do with separate processes, running at the same time, trying to use the same item. With pessimistic cursor locks, you can temporarily prohibit either read access or changes by other applications. With optimistic cursor locks, you expect no concurrent changes and do not prohibit access or changes by other applications

(#1339668@0)
Last Updated: 2003-8-20
This post has been archived. It cannot be replied.

Report

Replies, comments and Discussions:

工作学习 / IT技术讨论 / 哪位DX有什么好的办法用VB快速插入数据到DB2中?谢谢! -helenintor(吃吧吃吧吃了就不结巴); 2003-8-20 (#1339528@0)

ADO.Create your ODBC for your DB2, then use ADO -ivy_sh(呼吸着的青草); 2003-8-20 (#1339579@0)

I am using ADO,but it is slow -helenintor(吃吧吃吧吃了就不结巴); 2003-8-20 {78} (#1339588@0)
when insert bulk data, cost too much time.how to speed up the insert?
Thanks!

of cause insert is slower than select. 1)create reasonable index in your table(that's the common way to speed up),2)check your lock type. 3)If you not insert every field,put fields name in into(....) -ivy_sh(呼吸着的青草); 2003-8-20 (#1339618@0)

what is the locktype should be made in ADODB connection for bulk insert? -helenintor(吃吧吃吧吃了就不结巴); 2003-8-20 (#1339629@0)

I am not sure is Pessimistic or Optimistic for bulk insert(maybe first one).You can do some research online. Check what's the default.If it not what you want,change it. -ivy_sh(呼吸着的青草); 2003-8-20 (#1339661@0)

thank you very much,i'll keep trying. -helenintor(吃吧吃吧吃了就不结巴); 2003-8-20 (#1339688@0)

check this -ivy_sh(呼吸着的青草); 2003-8-20 {587} (#1339668@0)
The goal of using cursor locks is to ensure separate applications don't interfere with one another. Multiuser database applications encounter concurrency problems whenever several users try to access or update the same information at the same time. Concurrency has to do with separate processes, running at the same time, trying to use the same item. With pessimistic cursor locks, you can temporarily prohibit either read access or changes by other applications. With optimistic cursor locks, you expect no concurrent changes and do not prohibit access or changes by other applications

If you want to speed up the insertion for large bulk of data , you'd better drop the indexes before inserting and recreate them after the insertion is done. -yangn(Raymond); 2003-8-20 (#1339679@0)

that's what i'm think now. i'll test it later. Thank you, guys! -helenintor(吃吧吃吧吃了就不结巴); 2003-8-20 (#1339695@0)
Yes,index will slow insert,that's why I said reasonable index.Also I don't think it's the best way to drop index before do insert,'cause that will allow invalid or duplicate records inserted. -ivy_sh(呼吸着的青草); 2003-8-20 {35} (#1339705@0)
I like keep tables structure stable

1. There is no so called reasonable indexes to speed up the insertion at all . The existance of any index will always slow down the insertion. . -yangn(Raymond); 2003-8-20 {320} (#1339724@0)
Index is beneficial for select and sometimes for update/delete to some degree
2. Even without index , it is still possible to prevent the invalid records from being inserted with some sort of contraints. In other words. the main purpose of index is not for the validation of data but for the performance of retrieval.

@Calgary

check this

Replies, comments and Discussions:

More Topics