[ic] speed problem

[Peter Jakl]

The site I created had some serious speed problems. I added a time stamp
to the output produced by "logDebug" in the source code and activated
some of them to isolate where time is begin spent. It turns out the from
the time stamp on the [query...] below to the ending [/query] takes 3
full seconds. It's not the actual "select ...". After removing the
select to test that, there was no delay. The delay is strictly within
the [options][/options] tags. This is version 4.6.5. Any ideas?

[query prefix=attr list=1 list_prefix=options st=db sql=|
	select distinct [loop-code] from tpcat as a
	where tblid='t[scratch catid]' and [loop-code] is not null
[scratch acond]
	order by [loop-code]
	|
]
<select onChange="submit()" name="[loop-code]">
<option value="">Any</option>
[options]
[seti vattr][attr-code][/seti]
[seti vcode][cgi [loop-code]][/seti]
[if type="explicit" condition="$Scratch->{vattr} eq $Scratch->{vcode}"]
[tmp selected]selected[/tmp]
[/if]
<option [either][scratchd selected][/either] value="[scratch
vattr]">[attr-code]</option>
[/options]
</select>
[/query]


Peter