pg/tcl performance related

From: wolfgang(at)alle-noten(dot)de
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: pg/tcl performance related
Date: 2018-03-09 08:52:26
Message-ID: wolfgang-1180309095226.A0218096@noten19.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Aldrin Martoq Ahumada 2018-03-09 13:26:28 Postgresql upgrade to 9.5.12/10.3 changes pg_dump format for cloning schemas
Previous Message Bjørn T Johansen 2018-03-09 08:25:05 Re: Authentication?