Metadata vs create table, best practice?

Hi

WordPress encourage us to save post metadata using the update_post_meta(). That will create or update a post in the options table. Simple and fine for most of the times!

But if I want to filter posts on my metadata or sort on metadata, for example get all posts containing map coordinates save as metadata?

This will be slow and maybe a table is the best solution?

So, Metadata vs create table, best practice?

regards // Johannes