indexes are the next optimization after that. It sounds like an index on the posts table by map would be useful here, since you want to grab all the posts of a given map value

for the second part, there are ways to data model this - but you could wait to get into this until you have thousands of posts with the same map value to do it, because doing this in memory as you already are sure is convenient

it's ok not to do this the most efficient way for now, Convex being relational helps make it easy to change data access patterns later

for doing a condition inside the filter it would help to see code, that's a reasonable thing to do!

let postsQuery = db.query("posts").order("desc")
if (map !== "" && map !== "All) {
  postsQuery = postsQuery.filter(q => q.eq(q.field("map"), map))
}

const posts = await postsQuery.collect()

let postsQuery = db.query("posts").order("desc")
if (map !== "" && map !== "All) {
  postsQuery = postsQuery.filter(q => q.eq(q.field("map"), map))
}

const posts = await postsQuery.collect()