On Mon, 2003-03-17 at 08:06, Sheldon Rampton wrote:
My first question is: Have
changes made during the past three months improved the efficiency of
the scripts in ways that might reduce the server load? If not, maybe
there's no need for me to upgrade the scripts at this time.
Yes, in several ways:
* Limited client-side caching (enabled for IE) reduces the number of
pages requested.
* Inverse timestamp index makes history list, diff, and user contribs
_not_ exceedingly slow.
* Moving search index to separate table should reduce lock pressure on
'cur' table.
(2) I used CVS to install the new scripts at a
temporary URL for
testing purposes, but I haven't been able to get them working. I
compared my current database schema to the schema in buildTables.sql,
and it looks like a number of changes have been made, including:
You didn't run the update scripts!
See maintenance/patch-list.txt, and double-check that none have been
left off the list by mistake. ;)
Oh, and BACK UP YOUR DATABASE BEFORE PROCEEDING. As I'm sure you already
have...
-- brion vibber (brion @
pobox.com)