function call vs staright query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi all.

I'm experiencing a strange behaviour with 8.1.8 (cannot do upgrades to 8.2 at
the moment).

On a 13+ million rows table I can do a query with results back in less than
100 ms. Result is a set of bigint.
But when I encapsulate that query into an "SQL" function with three parameters
the results come back in about one minute. The function contains just the same
query as above.
Of course there's been no change in indices or even into the table itself
between the two tests.

I'm almost sure I'm missing something, but have no clue about what!
Any hint?


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux