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
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? |