28 Feb
2004
28 Feb
'04
12:44 p.m.
Star War wrote at 2004-2-26 15:30 -0800:
... BTW, I figured out what caused my pages very slow. The orignial designer put <dtml-in Catalog size=1 sort=... reverse> to get Last-Modified Date. After I recataloged, about 1,700 items in catalog, this statements takes about 6 seconds in the server. I have changed it into <dtml-in "Catalog(..., sort_on=..., sort_order=...)" size=1>, it just takes 2 seconds. I'm not sure if it is normal. Does somebody has a better way to get the lastest date?
Casey recently implemented a "limit" option for "searchResults". It can drastically bring down sorting time (from "O(n log(n))" to "O(n)"). Using "limit=1" is essentially equivalent to the loop proposed in a different message. -- Dieter