Help save net neutrality! Learn more.
Close

#151 Link cache performance increase

open
nobody
None
5
2014-08-23
2004-11-10
Josh Burley
No

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
correctly.

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
command:

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.

Discussion

  • Josh Burley

    Josh Burley - 2004-11-10

    tikilib.php.patch

     

Log in to post a comment.