Comment by Rajkumar on "Is InternationalCupid like search possible with PostgreSQL without using Solr, ES or other fulltext-search engine?"

Bill O'Neil

Sep 7, 2017

SQL can easily search over a million records in far less than 2 seconds depending on the query and indexing.

Rajkumar

Fullstack Developer.

Sep 17, 2017

Bill O'Neil Recently we had to encounter a situation, and in that we need to pull 1 Million data from DB and show them on screen. While the query fetches data within 2 seconds, and we didn't do much to optimise the query. So now I know the ability of SQL performance.

MG

Mahesh G

Mar 13, 2018

This might be off topic. How will user make sense of data if it is in order of millions?

Search Hashnode