Good morning
My forum is empty so performance is not an issue, however I
noticed that the column <table prefix>thread.message is not set up with
full text indexing.
Having a nose around search_process.asp, it appears to me
that the topic search is implemented in the same way for all supported databases
using the LIKE predicate.
I know that Access mdbs don’t have full text support, but
MySQL and SQL Server do and the performance advantages are massive, especially
for the larger forums.
I also appreciate that full text indexing is an optional install
so it can’t be assumed to be present.
Would this be an area where it would be beneficial to have database
server specific code, not only would it improve performance for the users, it
would also reduce database server load?
In my office I am the only person using my development SQL Server so I
can get the benefit of all of the RAM being used to cache the database that is relevant
to the project that I am currently working on, so even larger tables may end up completely cached in RAM. In a shared hosting environment this is much less likely to be happening so
performance will be a lot worse.
Bye
Ian
Topic Options
Post Options
Thanks(0)
