Examples: query, "exact match", wildcard*, wild?ard, wild*rd
Fuzzy search: cake~ (finds cakes, bake)
Term boost: "red velvet"^4, chocolate^2
Field grouping: tags:(+work -"fun-stuff")
Escaping: Escape characters +-&|!(){}[]^"~*?:\ with \, e.g. \+
Range search: properties.timestamp:[1587729413488 TO *] (inclusive), properties.title:{A TO Z}(excluding A and Z)
Combinations: chocolate AND vanilla, chocolate OR vanilla, (chocolate OR vanilla) NOT "vanilla pudding"
Field search: properties.title:"The Title" AND text
Answered
Helium SQL Query limit

Why is there a limit to the amount of records that can be returned by a DSL native SQL query? Why can't I set that limit to 1 million records all the time?

2
2
Posted 4 years ago
DevOps
84 × 2 Administrator
-1
-1

I know right?! It's so irritating, just let me query the entire database already!

Charl Viljoen   4 years ago Report
Votes Newest

Answers


There's actually a very good reason for the limit.
Whereas selectors page their results from the db ensuring that there are never more than a few records in memory at one time the native SQL does not.
So the native SQL is typically much faster because of that but can have a massive memory footprint if there is no limit on the number of records that are loaded into memory.
Also since Helium is a multi-tenant system (hosting many different apps) if one app causes memory to run out on the server it will cause downtime for all apps running there.

1
1
Posted 4 years ago
  
  

Why you so sour on my comment @Jacques Marais?

Charl Viljoen   4 years ago Report
199 Views
1 Answer
4 years ago
4 years ago
Tags