• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XenForo and large boards - VB3 import and search

lantek

Active member
#1
Firstly, very excited to have stumbled on this - looks very impressive. It gives new hope to me as a VB3 user to escape having to ever move to VB4.

A couple of questions on large(ish) boards. I've got around 4 million posts, 70000 users.

1. Assuming importing from vb3.8, what would you very roughly expect the import time to be like? I'm interested on whether it would be hours, days, or weeks.

2. How well does search work on large boards. Can we expect similar search performance to VB3 using MYSQL Full Text? VB4 is completely unusable on my DB, whereas VB3 is fine.

Thanks for any info!
 
F

Floris

Guest
#2
Hi there :)

Welcome to the site :D

Depending on your statistics it will take within reasonable time to a handful of hours.
I doubt it will take weeks. ImpEx by vB for example never took longer than a day for 15 million posts boards. In my experience at least.
 

mlx

Well-known member
#3
I'm pretty sure it won't take days or weeks on a proper server.

They've already mentioned that they are planning Sphinx search support. So search should work great for big boards.
 

Kuma

Active member
#4
2. How well does search work on large boards. Can we expect similar search performance to VB3 using MYSQL Full Text? VB4 is completely unusable on my DB, whereas VB3 is fine.

Thanks for any info!
The search being used here as far as I know is just a standard MySQL Fulltext, if you require sphinx you will need to wait until its included or figure out how to impliment it. I am positive that if the xF staff do not bring it out as part of the package it will be a third party addon.
 

lantek

Active member
#5
The search being used here as far as I know is just a standard MySQL Fulltext, if you require sphinx you will need to wait until its included or figure out how to impliment it. I am positive that if the xF staff do not bring it out as part of the package it will be a third party addon.
Thanks. Standard MySQL fulltext on VB3 works great for me. Whatever occurred during VB4 development most definitely does not work for me. So if XenForo does indeed use a search similar to VB3, that would be great for me.
 
F

Floris

Guest
#7
You're welcome.

Once XF can be purchased and downloaded, we will have some real life statistics regarding small to big board imports.
 

Kuma

Active member
#8
Thanks. Standard MySQL fulltext on VB3 works great for me. Whatever occurred during VB4 development most definitely does not work for me. So if XenForo does indeed use a search similar to VB3, that would be great for me.
It is still just fulltext, just in another table for muti-content search. There are known issues with it though. But it is just Fulltext.