| Caling package [message #225799] |
Wed, 21 March 2007 09:34  |
danijelv
Messages: 12
Registered: March 2007
|
Junior Member |
|
|
Hy,
I have problem with executing my package. I have two tables around each 1,000,000 records. When I join these two tables and use package to equal values execution time is 300% slower if i use statement without using package.
Sample with package:
select
package.equal(x.id,y.id) number
join ...
from ...
duration time: 17000hsec
Sample without package:
select
case when x.id=y.id then 0 else 1 end;
join ...
from ...
duration time: 400hsec
Of course I also tried with empty function in package it only returns 1; and also 300% slower.
How should i tune execution speed of package.
Best regards,
Dany
|
|
|
|
|
|
| Re: Caling package [message #225967 is a reply to message #225805] |
Thu, 22 March 2007 02:13  |
danijelv
Messages: 12
Registered: March 2007
|
Junior Member |
|
|
Yes by coding i lost meaing of program, same thing should be on one place. Packages are great solution.
I read about native compiling,' i tried with that.
Thanks a lot
Regards
Dany
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
