pg/tcl performance related - Mailing list pgsql-general

From wolfgang@alle-noten.de
Subject pg/tcl performance related
Date
Msg-id wolfgang-1180309095226.A0218096@noten19.local
Whole thread Raw
Responses Re: pg/tcl performance related  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general

Hi,

suppose I want to create a tcl function that basically walks through a long list and compares its
argument against all entries
In plain tcl I would probably write

set data {
  # .... lots of stuff here
}
proc check val {
  global data
  foreach d $data {
    # .... this does the work
  }
}

Now, for pl/tcl, I could use either

create function check(text) returns text as $$
set data {
  # the data value
}
foreach d $data {
   # the work
}
$$ language pltcl;
or
create function check(text) returns text as $$
if ![info exists GD(data)] {
   set GD(data) {
    # the data value
  }
}
foreach d $GD(data) {
  # the work
}
$$ language pltcl; 

Does this make any difference - i.e. how often will parsing the data happen?

Best regards
Wolfgang Hamann



pgsql-general by date:

Previous
From: Bjørn T Johansen
Date:
Subject: Re: Authentication?
Next
From: Aldrin Martoq Ahumada
Date:
Subject: Postgresql upgrade to 9.5.12/10.3 changes pg_dump format for cloningschemas