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: 25571
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: 3727
Registered: October 2005
Location: Melbourne, Australia
Senior Member
See if this helps

Ross Leishman
Previous Topic: Need help on SQL statement ..
Next Topic: pl/sql anonymous block
Goto Forum:
  


Current Time: Sat Aug 19 21:23:37 CDT 2017

Total time taken to generate the page: 0.37686 seconds