| ??? 01/19/08 20:10 Read: times |
#149742 - Single server Responding to: ???'s previous message |
Jan Waclawek said:
... complex and maybe more dangerous code (who does not make errors and mistakes?), isn't it possible to find "cheaper" solutions?
For example, isn't it possible to copy the database of messages to a different computer and run the search on that one, separately of the rest of server - whatever time it takes (and perhaps indicate to the users when that other computer feels unhappy)? That sounds more time-consuming to get working than to just rewrite an efficient version of the 8052.com search. :) The server is completely capable of handling the load caused by searches as long as the database is structured in such a way to make the search efficient. The current database structure is not even remotely efficient from a text search perspective. It's kind of a brute force approach to search that worked when we had 10,000 messages... even 50,000 messages. But now that we're approaching 150,000, it just doesn't scale. So I need to fix that. Regards, Craig Steiner 8052.com Webmaster |
