External function and performance

From: Krzysztof Ku¶nierz <kkrzysiek_at_supra.com.pl>
Date: Sat, 23 Mar 2002 23:23:12 +0000
Message-ID: <a7iv8s$j1t$2_at_news.tpi.pl>

[Quoted] I have Oracle 9.0.1 working on RedHat Linux 7.2. I have noticed that the following statement:

SELECT external_function(column) FROM table

is 10 times slower than:

SELECT column FROM table

where:
- external_function is empty C function (it only returns its parameter)

• shared library containig function on the same machine; communication via IPC

Is it normal? If not, what can I do to improve performance?

Thanks in advance.
External function and performance Received on Sun Mar 24 2002 - 00:23:12 CET