I'm still not remotely pleased with Advanced Search performance so, before resorting to a separate Search server, I'm going to segregate it by year ala SI and make the Public Msgs search at the top just do the current year.
I think a huge part of our problem not only on the retrieval side of things but the catalog update side is we're dealing with a single table much large than any of the individual tables on SI. Not that we have more messages. Just that our total messages are more numerous than any single year of messages on SI.
Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.