Which database is the fastest in the search by several parameters, for example from 10-100?

Select the database for your project, in the same table can be from 500-1000 columns or parameters. If they use my project for a very long time 4-20 years. although it is unlikely, but may happen, then this table will be around 100000-1000000 records. What database might be relevant in this situation ?
Which database holds the speed when searching by multiple parameters, I'm looking to couchbase, it will fit ?
April 4th 20 at 00:36
2 answers
April 4th 20 at 00:38
Any, having the structure polnovatogo "tree" unique "nodes" ("keys").
Through the unique relationship between "nodes", find all the necessary data of the incoming request.
You need to find a good DBA/DBM, which will design the right scheme for Your task.
Then choose the appropriate "engine" database created under the schema of the data.

Direct response: a properly designed.
April 4th 20 at 00:40
Until you pointed out nothing unique, so almost any. A "in one table can be from 500-1000 speakers" more like a design problem database.
And what database will bring faster results, 100 parameters, mysql, couchbase or not know ?)) - Jaqueline.May commented on April 4th 20 at 00:43
@Jaqueline.May, in case you have a spherical horse in vacuum. The faster displays, which will be more professional DBA set up. - Anderson.May commented on April 4th 20 at 00:46
@Jaqueline.Mayvery from lot depends on the data itself, from indexes, from settings. Sometimes even better index to be stored in special databases, like sphinx or elasticsearch - Jared64 commented on April 4th 20 at 00:49
nonsense. there may be more columns. depends on the subject area. - idella_Jacobi commented on April 4th 20 at 00:52

Find more questions by tags Databases