What should be another alternative from indexing, if I want to quickly know the length of the query first before executing a potential slow query (such as multiple regions with a long date range)?

Indexing query, Counting with subquery of query, Ways to make compress query

crs.execute(query) #from fdb cursor

if crs.fetchone() is None:
   #notify user there is no results
else:
   #do stuff

I want to notify user quickly if there is no results in query instantly/faster.

0

There are 0 best solutions below