Home » SQL & PL/SQL » SQL & PL/SQL » Function calling (Oracle 9i)
Function calling [message #282084] Tue, 20 November 2007 16:38 Go to next message
Messages: 32
Registered: November 2007
Can anybody help me taking a decision?
I have to write a job, which will run once a day. The job will insert the whole work done in last 24 hours into a History table. Then do some "Business calculations" on that History table. On an average the number of works per day is 50K - 60K. Now the problem is, wheather I will call a function to do the "business calc." for each of those 50000 works, or do an update to do the same task?? Confused My ONLY concern is the overhead or the performance. Though I will run it at a time when last users are connected, but still I want your help on this.....

Thanks in advance
Re: Function calling [message #282085 is a reply to message #282084] Tue, 20 November 2007 16:49 Go to previous messageGo to next message
Messages: 24958
Registered: January 2009
Location: SoCal
Senior Member
Only YOU can really answer the question about which is better by benchmarking all alternatives & selecting the best one.
Re: Function calling [message #282094 is a reply to message #282085] Tue, 20 November 2007 20:00 Go to previous message
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
See if this helps

Ross Leishman
Previous Topic: Adding Range Partitions to existing non-partition tables
Next Topic: Disable Constraints from Parent and Child tables
Goto Forum:

Current Time: Sun Oct 23 03:39:48 CDT 2016

Total time taken to generate the page: 0.08442 seconds