G
G
ganbatte2020-01-02 21:04:00
Database
ganbatte, 2020-01-02 21:04:00

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

2 answer(s)
X
xmoonlight, 2020-01-03
@ganbatte

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.

D
Dr. Bacon, 2020-01-02
@bacon

So far, you haven't specified anything unique, so pretty much anything. And "one table can have from 500-1000 columns" is more like a problem in database design.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question