SaaS ideas your next customers are already looking for
100 SaaS startup ideas for the people who said they'd pay, from agency owners to dentists. Micro SaaS ideas, AI SaaS ideas and B2B SaaS ideas: find yours, build it, sign them up.
Popular:
| # | Idea |
|---|
No idea matches this filter.
Pain points in business: what people struggle with
Search the problems to solve, as people described them on Reddit and other platforms, in their own words.
Popular:
| # | Pain point |
|---|
No pain point matches this filter.
Slow Database Queries
Poorly optimized queries and missing indexes cause slow performance, high compute costs, and scalability issues across databases.
In their words
I want to give access to a limited number of other folks, and the little box I'm running on won't cope.
my main pages need 15 - 19 queries to load all the things for one user
one frequent query running every 5 mins had no composite index covering its WHERE clause, so SQLite was scanning the entire table
my storage gets filled quickly... less than a week... my query performance is poor as well
For every incremental model, a full refresh is actually faster.
The lack of data profiling is a massive blind spot. When data goes sideways, we don't know.
847,293 files ... 600 GB table averaging 750 KB per file ... three minutes of listing before any parallelism even starts
we are running a side-by-side evaluation if Lakebase should replace some our cloud-native databases
the expectation is to load the data everywhere not more than 2 sec. and as of now it sometimes takes around 6 sec. for the heaviest reports.
we have a large number of servers - each system has its own dedicated production server, plus a separate server for development
During heavy ETL runs, client reports suffer.
Found missing indexes and a lot of sequential scans. Added the indexes, performance went from critical to better than optimal.
We (over)pay for datadog's Database monitoring APM, but it is decent
a count() over the entire DB could take 8 minutes
Data and platform engineers
Where they talk
- r/SQLServer
- r/snowflake
- r/MicrosoftFabric
- r/dataengineering
- r/Database
- r/databricks
- r/SQL
- r/softwarearchitecture
Tools they use today
- PostgreSQL
- Snowflake
- ClickHouse
- Spark driver app
- SQL Server
- Query Store
- Databricks
- Cube
Why those fall short
- No easy sorting or alerting; worst queries look cheap in UI
- no alerting on rows read or query cost
- ORM generated absolute nightmare SQL queries that locked up our database
- predictive optimization only on serverless; manual scheduling needed otherwise
- Incremental models perform worse than full refreshes on Redshift Serverless
Map of ideas
Drawing the map…