Right now, I created a custom post type "resource" that is currently set to hidden. I'm planning on getting all resource posts and displaying them on 1 page. Not like an archive page, but like a post. I estimate there will be 300-500 of these posts.
Each custom post "resource" will use the "title," "body," custom field "website," a custom taxonomy, a second custom taxonomy, ratings/votes, potentially a feature image, and potentially comments.
I do not want to create a single post and have to manage tons and tons of formatted lines of resources. Additional benefits are the fact that I can manage these resources from a CSV file and use WP All Import to mass update the list. Furthermore, each resource can store a rating or "upvote" by users and I can eventually use this to sort by "best." And, maybe even implement comments on these, so users can submit tips for how they used it...
But, I imagine pulling 500 items out of a database and then displaying each field will be very inefficient. Yes? No? Is there a better way to do this?