The Question and Answer Board

[Bob Zumbrunnen]

My time today got 100% soaked up in dealing with ad sales (nice problem to have, when sales are the outcome), so no time was put in on the public search until just now, where I'm working on it from home.

For now, until I get the routines written to auto-populate/update the search table, newer messages aren't available in Advanced Search unless I run the catch-up routine, which I just did a little while ago.

There seem to be other problems, though, that I haven't put my finger on yet. It took over half an hour to copy 8000 messages to the search table, which is horrible. And while the copying was happening, searches were timing out. Now a typical one takes about 14 seconds, which is unacceptable to me, although part of that may be the cataloger catching up and keeping the CPU busy. We'll see if the results are any better once it's caught up.

For now, until I get Advanced Search changed, regular Public Msg search should yield near-realtime results though it'll probably run slowly and occasionally time out.