Home » RDBMS Server » Server Administration » slow in insertion
slow in insertion [message #374863] Sun, 08 July 2001 09:24
T. MohanDoss
Messages: 1
Registered: July 2001
Junior Member
In a stored procedure iam using a cursor in which
a insert query is used.
The no. of rows in that cursor is approximately
300 to 500.
So for insertion of all that 300 to 500 rows it is
taking 3 minutes to 5 minutes.
How can i optimize that time?

Report message to a moderator

Previous Topic: selecting N rows from a table
Next Topic: configuring the COntext Option in oracle
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Mar 13 09:00:42 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.