Home » SQL & PL/SQL » SQL & PL/SQL » Deletion too slow
Deletion too slow [message #21260] Sun, 21 July 2002 20:40 Go to next message
bharath
Messages: 30
Registered: November 2000
Member
hai,
I am having a table with nearly 2 lakhs of rows.
it is taking nearly 5 min to delete 1000 rows.
How can i improve this.
thanks in advance
bharath

Report message to a moderator

Re: Deletion too slow [message #21263 is a reply to message #21260] Mon, 22 July 2002 00:24 Go to previous message
Vikas Gupta
Messages: 115
Registered: February 2002
Senior Member
Make sure you are not comiting too often. It gives better performance if you have only one commit.

Regards,

Vikas.

Report message to a moderator

Previous Topic: Trigger created with compilation errors
Next Topic: Strange Problem in decode function
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 21:31:44 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.