database Bandwidth by Dashboard
Hello I have a table with more than 20k documents and everytime I select the table on the panel it loads all the documents consuming a lot of bandwidth, is there a way to limit the default amount of documents when selecting a table in the dashboard?
12 Replies
Thanks for posting in <#1088161997662724167>.
Reminder: If you have a Convex Pro account, use the Convex Dashboard to file support tickets.
- Provide context: What are you trying to achieve, what is the end-user interaction, what are you seeing? (full error message, command output, etc.)
- Use search.convex.dev to search Docs, Stack, and Discord all at once.
- Additionally, you can post your questions in the Convex Community's <#1228095053885476985> channel to receive a response from AI.
- Avoid tagging staff unless specifically instructed.
Thank you!
Hi Zaimon, the dashboard's data page only loads the first couple pages of documents until you scroll down. Are your documents particularly large or high write load to your tables?
Hi Ari, no, they are not large, there was a time when it loaded only few docs but now I dont know why it is loading all the 20k documents! its crazy because every time I click on the table it spend like 50mb of bandwidth but there is no conf in settings to change that
That's quite odd, normally documents are only loaded as they're needed (and you'll see a spinner next to the table name at the top while they're loading)
What browser are you using?
And if you could provide your deployment name that would be helpful for us to dig in
Google chrome as you mentioned the browser I tried firefox but I got the same result. the deployment name is adventurous-goldfinch-852
Thanks! That helps. Do you use filters on the dashboard when this happens?
No, it happens right away when I enter to the table. If I apply a filter it said filtering 20000 documents and takes a few seconds to load
I'm looking into our logs -- looks like the query for the screenshot above read 8,500 bytes, which is good. It only loaded 25 documents.
I do see a query that read ~4mb at <t:1749055699>. Do you know if that query was filtered or not? I see a number of other dashboard queries that read 2-5mb each in the past few days. This shouldn't happen when no filters are applied, but we'll investigate further to try and reproduce
Ok looks like it was the filtered query but it is still a lot because tody I only filter 3 tables and it makes a 50mb consume. from now I will check the cosume before quering to keep track of the bandwidth.
Yeah if you run a filtered search using the Add Filter button, the table will be scanned sequentially until it finds documents that match your search. The payment table looks is about 8mb so it would take up to 8mb per query (if it needs to scan to the end of the table to find a match).
If you want to filter on the dashboard more efficiently, I'd recommend using the index filters instead
Same goes for the code you write --
.withIndex is going to use a lot less bandwidth than .filterI will be checking that on dashboard. I indeed have all the code queries indexed thanks for your help!
Awesome! good luck 🙂