Answer the question
In order to leave comments, you need to log in
Which database is the fastest in searching for multiple parameters, such as 10-100?
I choose a database for my project, in one table there 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 it can happen, then there will be about 100000-1000000 entries in this table. What database can be relevant in this scenario?
Which database holds speed well when searching by several parameters, I'm looking at couchbase, will it fit?
Answer the question
In order to leave comments, you need to log in
Any that has the structure of a fully connected "tree" on unique "nodes" ("keys").
Through unique connections between "nodes", we find all the necessary data of the incoming request.
And after that - choose the appropriate "engine" of the database for the created data schema.
Direct answer : properly designed.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question