I have a dashboard type page which is going to generate 4 database queries on big tables of symbols holding 50k rows. Only trying to return the top 10 records in each table, I only need to select that many rows.
I understand how to limit the display of a repeating group by the number of rows. However, past that I do not see anywhere to designate that I would like to only return 10 records in the query itself. I would also like to cache this group of queries.
Is anything like this possible?