Gerhard
Explore posts from serversCCConvex Community
•Created by Gerhard on 9/13/2024 in #support-community
efficiency of: return (await ctx.db.query("messages").collect()).length;
that does not seem very efficient if I had 1mil rows in a table.
Two suggestions/questions:
1. Is there a count of a table (without scanning the whole table)?
2. Alternatively, should there not a some for of projection?
What if I had a table with 50 columns and I need a list that really only contains 2 or 3 of the columns?
Am I going to get all 1M rows streamed into memory or somehow in order to get a count?
7 replies
CDCloudflare Developers
•Created by Gerhard on 3/21/2024 in #workers-help
specific placement
Instead of smart placement, for governance purposes, how can I run a worker in my location of choice.
Use case: I need to check uptime of other systems, and gather app info, but it has to be from a specfic region.
So not smart-placement, by my-placement.
12 replies