>> 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.
SQL functions are stored prepared, so there is less per-call query
planning overhead. I'm not sure there'd be much advantage to doing them
in C...
Chris