Log in

View Full Version : mySQL fulltext or vB built in?


Andreas
01-20-2005, 05:55 AM
As our postindex table is over 39 million rows big and search sometimes crashes (memory exhausted) I wonder which search method would be less server intensive?

Colin F
01-20-2005, 08:16 AM
As our postindex table is over 39 million rows big and search sometimes crashes (memory exhausted) I wonder which search method would be less server intensive?
As the mysql fulltext search is built in, I would assume that that should be able to handle some big loads, allthough I don't know much of the technical stuff.

I've heard though that the current mysql fulltext search built into vB isn't all too optimised yet.

Xenon
01-20-2005, 09:10 PM
it's not too optimized right now, but iirc vb.com is using it already.

I'd say that mysqls build in feature is optimized enough to use it, so switch over ;)