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)