Use SQl only for querying and sorting?

1

Hello,

I was wondering if it is a good idea to only do the querying and sorting of things in SQL returning only a list of thing ids which can later be looked up by some service like Firebase which uses binary search to look up information much faster. This way I dont need to store the actual information in SQl but only the relations so I can get the key tp the data I want. Is this a good Idea or is this stupid?

2

I'm just not sure your premises are valid. SQL Server also uses a binary search method. Any dbms with b-tree indexes does.

1 Like
3

Can you expound what you mean by SQL? is this SQL the product from Microsoft ie Microsoft SQL Server . Or are you talking about SQL the query language?