Re: Performance problems inside a stored procedure.

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

 




Ahh, sorry, I have been too aggressive with my cutting, I am running 8.2.6 and the function is below.

Thanks.
Matthew

CREATE OR REPLACE FUNCTION sp_get_price_panel_id(int4, "varchar", "varchar", "varchar", bpchar)
 RETURNS SETOF t_market_price_panel AS
$BODY$
SELECT *
  FROM market mrkt
  JOIN market_group_relation mgr USING (market_id)
  JOIN market_group mg USING (market_group_id)
  JOIN market_group_price_relation mgpr USING (market_group_id)
JOIN accommodation_price_panel app ON app.accommodation_price_panel_id = mgpr.price_panel_id WHERE mrkt.live <> 'X'::bpchar AND mg.live <> 'X'::bpchar AND app.live <> 'X'::bpchar AND MARKET_ID = $1 AND CODE = $2
   AND CODE_TYPE = $3::CHAR(2)
   AND CONTRACT_ID = $4
   AND ( PRICE_PANEL_TYPE = 'B' OR PRICE_PANEL_TYPE = $5 );
$BODY$
 LANGUAGE 'sql' VOLATILE;


Heikki Linnakangas wrote:
Matthew Lunnon wrote:
I have a query which runs pretty quick ( 0.82ms) but when I put it inside a stored procedure it takes 10 times as long (11.229ms). Is this what you would expect and is there any way that I can get around this time delay?

It depends. You'll need to show us the function. Also, what version of Postgres are you running?


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
      message can get through to the mailing list cleanly

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

  Powered by Linux