Re: [GENERAL] stored procedure optimisation...

2007-02-27 Thread Anton Melser
RAISE NOTICE 'I am here, and myvar = % and thatvar = %', myvar, thatvar; Thanks... it is indeed a gem that little instruction!!! Cheers Anton ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] stored procedure optimisation...

2007-02-27 Thread Albe Laurenz
Anton Melser wrote: > I need to analyse some html to get some links out, and with only 25 > lines in exports_tmp_links (and text_to_parse no more than around > 10KB) this function has taken 10 minutes and counting. Something > horribly wrong is going on here! Can someone give me any pointers? I be