Page 1 of 1

database

Posted: Wed Sep 15, 1999 5:31 pm
by Thunderstone



I have commercial webinator on multiple databases.

#1 works fine, searches are completed in 2-5 seconds -- html.tbl is 166 Mb
texis consumes max 20% of cpu resource and finishes quickly and stops running

#2 has gotten very slow, searches consume over 20 sec and sometimes time out -- html.tbl is 329 Mb
texis consumes 98% of cpu resource and remains at that level while trying to search

Server is dual pentium III 500 with 512 Mb ram running linux/apache

Is there a way to search for and/or correct possible corruption in the database?

What other possible causes could there be for this slowdown?

Thank you.

Mike Clark
super@101super.com





database

Posted: Wed Sep 15, 1999 5:46 pm
by Thunderstone


Both of those sound slower than we would expect. You should run gw -index
for each of the database to ensure that the text search indexes are created
and up to date.

John Turnbull
-------------
Thunderstone Software


super@101super.com said: