I found it for you: https://support.wix.com/en/article/velo-best-practices-for-improving-performance-in-wix-sites-with-data
At the bottom “Downloading only the fields you need”
And about how to call it from the frontend:
- in your page, import the function from .jsw file at the top, just like you imported wix-data before
- if you call it from the page onReady, make it async, like so:
$w.onReady(async function () {
If you call it from another function than the onReady function, just make that function async
3) do this inside the function:
let arrResult = await queryApplications(Email) ;
$w("#table1").rows = arrResult.items;