![]() |
hmm, i don't know the speed of mysql's full text seraching indexing, but i think so, as it should be strongly optimized ;)
but generally yes, it should be much faster when you are using mysqls fulltext indexing instead of vb's |
short note: I've just finished archiving about 2.600.000 postings in my board. I'll have to make some further compatibility test, than I will release it as hack.
it's another approach, then used by Xenon, and the result is a dramatic increase of speed by reducing the "post"-table by half... :) ...so the "key feature" of my hack is speed improvment for large boards (> 1 million posts), and not to reduce used space. I hope, I get the beta released in about 2 weeks! scotty |
Very interesting to me indeed. I'm only at 2.1 million posts, but we keep them *all* online and searchable at all times. I've since moved search to an alternate slave mysql server to keep from killing site performance, and I'm sure this would help all that much more.
|
All times are GMT. The time now is 03:54 PM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|