I have a csv of 65,000+ rows. Each row only has two fields, an ID code and a Description. This csv will get updated every year or so. The users needs to be able to type in the code and get a list of related posts (which I'll handle with a custom meta box).
It seems like these 65,000 items would really clutter up the wp_posts table and maybe the wp_postmeta table and make searches slow. This is a site with hundreds of posts (thousands counting revisions) in various CPTs already.
I'm not a database guy, so I really don't know the best way to handle this. Would be something better handled in it's own custom table?