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
dasgupta.amitava@gmail
Messages: 32
Registered: November 2007
Member
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
Amitava........
Re: Function calling [message #282085 is a reply to message #282084] Tue, 20 November 2007 16:49 Go to previous messageGo to next message
BlackSwan
Messages: 25036
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
rleishman
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 Dec 04 12:41:47 CST 2016

Total time taken to generate the page: 0.07607 seconds