Do it not so many times...

It's better this:


A)
- One Insert with 10 Lines
- Commit

B)
IF A) it's impossible it's better

- 10 insert with one line each
- Commit at the end

C)
- IF A) & B) are impossible... You have the worst case... A lot off calls...


But 10ms it's a good time!!!


Regards,


LG


-----Original Message-----
From: joemellors
[mailto:oracledba-ezmlmshield-x48578375.[Email Address Removed] zyDBA.com]
Sent: quinta-feira, 7 de Abril de 2005 16:41
To: LazyDBA Discussion
Subject: Need to speed up an insert statement


Hiya everyone,

I am a developer who could do with some help and I'd
appreciate any advice you can give. I've got an
insert statement in a stored proc called by a Windows
service. The problem is we need it to run a lot
faster than it does, as it is currently the major
bottleneck in our system. It is currently taking
approx 10ms per round trip but it needs to be called
so many times during our process that there is no
real point focusing on any other area currently!

Does anyone have any suggestions?

If the tnsping time from the machine with the Windows
service to the database is 10ms, does that indicate
that there is not a lot wrong with the statement?
(and that the 10ms is mostly the network).

Also, we are using label security; could this be an issue?

Thanks in advance for any help,

Joe



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page