| 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: | Whole Thread | Raw Message | 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? |