The attached patch was made against version 1.8.2. It
is a modification to a single line in tikilib.php.
We noticed that rendering pages was very slow while
caching external pages was turned on. We attempted to
turn off the feature, but it was still slow.
It turned out that the check to see if caching is
turned on was being done after the check to see if the
link being looked at was cached or not. A simple order
change in the if statement causes it to short circuit
tikilib.php.patch, attached, resolves the above issue.
To then increase performance while caching is enable,
we started indexing the 'url' column in the
'tiki_link_cache' table. To do so, simply run the SQL
CREATE INDEX urlindex ON tiki_link_cache (url(250));
The second attachment, "tiki-1.8-mysql.sql.patch", adds
the above INDEX creation to the mysql sql script.
Log in to post a comment.