2 Replies
Hi @d4rk51d3. I'm kapa.ai, your friendly support bot. I will try to answer your question by searching through the knowledge base. :wave:
----------------------
To get the total count with
useList
when using Supabase as your data provider, you can utilize the meta
property to pass the count
parameter. By default, the getList
method returns the exact count of rows, but you can request an estimated count to improve performance.
Here's how you can do it:
1. Exact Count (Default): This will return the exact number of rows, but it might slow down the request depending on the table size.
2. Estimated Count: You can request an estimated count by passing the count
property in the meta
object.
Example Code
Explanation
- meta: { count: "estimated" }
: This line in the useList
hook configuration requests an estimated count of the total rows. You can change "estimated"
to "exact"
if you need the exact count.
For more details, you can refer to the Supabase documentation on getList
performance (https://refine.dev/docs/data/packages/supabase/#getlist---performance) and the useList hook documentation (https://refine.dev/docs/data/hooks/use-list/#retrieving-the-total-row-count).
By using the meta
property, you can control how the total count is retrieved, which can help optimize performance based on your application's needs.
----------------------
Note: you can ask me a follow up question by @ mentioning me again :speech_balloon:
----------------------<@475681545793961986> kapa.ai is still learning and improving, please let us know how it did by reacting below