Hello again,
Seems to be ok, by adding normal outer join and some fields on where-part.
Previous, I use to used with Oracle and Sybase databases as much as possible
functions/procedures.
There ware something to do with performance: "Do it on server, not in client".
Typically all programs were c
Hi and thank's guys!
First trying this Brendan's recommendation.
It seems only a small difference between sql and PL/pgSQL. from 40-->37. Not so
good yet.
I will try Maxim's little later and you all know.
--
kupen
Brendan Jurd [dire...@gmail.com] kirjoitti:
On 10 July 2012 18:36, Pena Kupen
On 10 July 2012 18:36, Pena Kupen wrote:
> Hi,
>
> I have searched solution to my problem a few days. On my query, there is big
> performance problem.
> It seems to me, that problem is on where-part of sql and it's function.
>
> How should I handle this situation and use function?
>
I would star
On Tue, Jul 10, 2012 at 6:36 PM, Pena Kupen wrote:
> Hi,
>
> I have searched solution to my problem a few days. On my query, there is
> big performance problem.
> It seems to me, that problem is on where-part of sql and it's function.
>
> My sql is:
> select count(*)
> from table_
Hi,
I have searched solution to my problem a few days. On my query, there is big
performance problem.
It seems to me, that problem is on where-part of sql and it's function.
My sql is:
select count(*)
from table_h
where
level <= get_level_value(11268,id,area) and
(date1 >= '2011-1-
