triplets_93
Well-Known Member
- Messages
- 6,151
- Reaction score
- 6,602
I understand that more now.... A simple search of "Jerry Jones" for example, would bring up to many hits and stress the database.I will look into it but the problem is the XF search system (at least in the old software) was horrible. When people would perform obscure searches it brought the site to a standstill for everyone despite running on enterprise level servers.
The main issue is that databases are traditionally bad with searching millions of records, so you need to use a search indexing system rather than a database search.
I plan to spend time testing the search system in the new software, but if has the same performance issues, I will consider writing my own search indexing system for CZ.
Perhaps the Search function could be defaulted to just search the last 3 months, for example.
If someone wanted to search a different timeframe, they would have to go to the trouble to enter a date range.
I usually end up wanting to use the search function in the Off Topic and the Music sub-threads anyway.