Re: [PERFORM] speeding up a select with C function?

[David Teran]

Hi,

On 08.03.2004, at 02:29, Christopher Kings-Lynne wrote:

explain analyze select
((t0.int_value-t1.int_value)*(t0.int_value-t1.int_value))
from job_property t0, job_property t1
where t0.id_job_profile = 5
and t1.id_job_profile = 6
and t1.id_job_attribute = t0.id_job_attribute
and t1.int_value < t0.int_value;
Don't bother with C function, use SQL function instead.  You could get 
a 50% speedup.

Is this always the case when using SQL instead of the C API to get 
values or only the function 'call' itself? We are thinking to use C 
functions which are optimized for the G5 altivec unit.

regards David

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])