Home » SQL & PL/SQL » SQL & PL/SQL » Re: what is the fastest way to update a big table (50000rows*20columns)
Re: what is the fastest way to update a big table (50000rows*20columns) [message #36087] Sat, 03 November 2001 03:04
yilmaz
Messages: 4
Registered: September 2001
Junior Member
hi Todd, Sureys V and Suresh B,
thanks for your help.
Yeah at last i discovered that it was becasue of the trim function. After eliminating it , my procedure worked, this time each update process took only(!) 2 hours on average.At least it worked and my project finished.
Thanks for your help, otherwise i wouldn't think that a simple trim will cause so much trouble :)

----------------------------------------------------------------------
Previous Topic: Re: usage of temporary table in pl/sql procedure
Next Topic: Re: How to Retrieve CLOB withADODB Command Parameter...?
Goto Forum:
  


Current Time: Thu Mar 28 13:59:06 CDT 2024