Error: [CONVEX Q(users:getTopUserByPodcastCount)]

[Jay-Karia]

Server Error
Uncaught Error: Too many bytes read in a single function execution (limit: 8388608 bytes).

[ldanilek]

To avoid this error, you can add an index on the podcasts table by authorId, and use it here

podcastr/convex/users.ts

Line 31 in e4b6473

.filter((q) => q.eq(q.field("authorId"), u.clerkId))

const podcasts = await ctx.db
          .query("podcasts")
          .withIndex("by_authorId", (q) => q.eq("authorId", u.clerkId))
          .collect();

and define the index here

podcastr/convex/schema.ts

Line 21 in e4b6473

})

.index("by_authorId", ["authorId"])

Why this works: with a .filter(), it reads the entire podcasts table for each user, but withIndex only looks up the podcasts authored by that specific user.