Hi all, My database has an SQL function. The result comes in 30-40 seconds when i use the SQL function. On the other hand; The result comes 300-400 milliseconds when i run the SQL statement. Any idea ?? My database is Postgresql 8.1.2.. Function is below : CREATE OR REPLACE FUNCTION fn_online_seferler_satis("varchar", date, int4, "varchar", "varchar")
RETURNS SETOF record AS
$BODY$
SELECT (S.KALKIS_YERI||' '||S.VARIS_YERI||' '||S.SAAT)::varchar AS SEFER_BILGI,
sum((i.bilet_ucreti + coalesce(i.police_ucreti,0)) - coalesce(i.int_artik_ucret,0)) as top_satis,
count(1)::int4 as top_koltuk
FROM T_KOLTUK_ISLEM I,
T_KOLTUK_SON_DURUM SD,
T_LOKAL_PLAN LP,
W_SEFERLER S
WHERE I.FIRMA_NO = SD.FIRMA_NO
AND I.HAT_NO = SD.HAT_NO
AND I.SEFER_KOD = SD.SEFER_KOD
AND I.PLAN_TARIHI = SD.PLAN_TARIHI
AND I.BIN_YER_KOD = SD.BIN_YER_KOD
AND I.KOLTUK_NO = SD.KOLTUK_NO
AND I.KOD = SD.ISLEM_KOD
AND SD.ISLEM = 'S'
AND LP.FIRMA_NO = I.FIRMA_NO
AND LP.HAT_NO = I.HAT_NO
AND LP.SEFER_KOD = I.SEFER_KOD
AND LP.PLAN_TARIHI = I.PLAN_TARIHI
AND LP.YER_KOD = I.BIN_YER_KOD
AND I.FIRMA_NO = $1
AND S.FIRMA_NO = LP.FIRMA_NO
AND S.HAT_NO = LP.HAT_NO
AND S.KOD = LP.SEFER_KOD
AND S.IPTAL = 'H'
AND ((I.ISLEM_TARIHI = $2 AND $5 = 'I') OR (LP.KALKIS_TARIHI = $2 AND $5 = 'K'))
AND (((LP.LOKAL_KOD = $3 AND $4 = 'K')) OR ((I.ypt_lcl_kod = $3 AND $4 = 'I')))
GROUP BY S.KALKIS_YERI,S.VARIS_YERI,S.SAAT; $BODY$
LANGUAGE 'sql' VOLATILE; Adnan DURSUN ASRIN Bilişim Ltd.Şti Turkey | 
