Tuning PosgreSQL/Wappler query performance

[Apple]

@Notum

What’s Wappler is actually paralleling?

Nothing, absolutely nothing.

Vote for the feature request:

Parallel Repeat

The current Parallel block of the NodeJS server target doesn’t allow to parallelize an array, only a series of hard-coded steps - meaning you cannot do a database query and parallelize actions over each element/row/item. An example makes it easier to understand. Let’s say you have a table “websites” with URLs, such as: https://wappler.io https://microsoft.com https://bing.com https://google.com https://youtube.com If you want to perform an API Action (fetch those websites) in parallel, you ca…

Also check my other feature request for additional information concerning database performance:

Smarter Database Multi Insert

Continuing the discussion from Slow insert records into the database: Actually, I’ve just realized how slow is the Database Multi Insert in Wappler, even with transactions as mentioned in my previous post. I did the same test using a third-party SQL viewer, with the import feature, and it basically transforms the CSV into a bulk INSERT statement: INSERT (...) VALUES (...), (...), (...), (...), (... about 300) INSERT (...) VALUES (...), (...), (...), (...), (... about 300) // instead of Wapple…