Reason for search results taking 4 seconds ⏱

[Apple]

Can you show your query “where” fields?

Funnily enough, I wrote a feature request a while back:

Database manager: Index column checkbox

It seems Wappler’s database manager is missing a checkbox to make a column indexed, near the Unique checkbox. Indexing certain columns can enhance query speed if you search those columns frequently [Screenshot]

If it’s a primary key (id) it’s indexed by default, otherwise it’s not

Also another feature request:

Back-end (server action) performance profiling

This is an intermediate-advanced feature - you can skip this topic if you’re a beginner I just had a situation where in a NodeJS project I added an API Action step somewhere in a Library file and a few server actions became slow because they relied on the API Action step that was included as part of an Exec step. If I hadn’t remembered about this, I’d be left wondering why the server actions were slow, with no apparent way of performance profiling. I suggest the addition of an option (much li…