![]() ![]() Then we would need write a SQL parser for that. Unfortunately nodejs does not have any really good SQL parser. We would need have the AST of the query to ensure that is a SELECT query and does not have yet a LIMIT. Although doing that in the backend can be pretty trick depending in the query (e.g. We already sort of do that, but it is only done in the front end (which already improves a lot the performance in the rendering). The only thing I think we can do is force paging any SELECT query when the user does not include an LIMIT. I guess the amount of memory you have available does not support loading that much data at once. Hi query is creating a very large buffer which is reaching the memory limit. ![]() The select is simple: select * from table where foreign_key = 1 App is crashing after querying a simple select, which returns more than 185446 records. ![]()
0 Comments
Leave a Reply. |