Question 2 million individuals - Best DB?

Hello,

Using the latest version of webtrees, our installation has a total of 2 million individuals ( 2 093 926 ), which include 832 353 families. Understandably, the searches are about 30 seconds with MariaDB. Wanted to try Microsoft SQL Server but it seems limited with webtrees at the moment. Can anyone suggest anything? Is this the best product to display via the web our records?

Thanks in advance,
Donald

> Understandably, the searches are about 30 seconds with MariaDB

The "general search" simply does a full table scan of some tables.

I doubt the choice of DB engine is signifacant.

Most likely, you just need to give more RAM to MariaDB.

PS - I know a site with approx 10M records which switched from SqlServer to MySQL

Thank you so much for taking the time to answer my question. Much appreciated!

Also, the privacy rules might be slowing things down for you.

If all your data is public (or you can create a filtered export), you can disable the checks which csn make a significant difference.

That is interesting. Did not realize this fact. I thought the default indexes would take into account the privacy settings. Will certainly look into this.

In our case, the records have been donated to us. We do give access to the general public, We only give access to visitors through our kiosks that are onsite. The kiosks are firewalled as well.

So in this case, Is there a function that I could make all records remove the privacy settings?

Privacy filtering happens after searching.

Control panel - family tree - privacy - living individuals - show to.public

(or similar. can't check right now)

Found it!

Thanks again!