I'm building a WordPress theme framework, that will likely have many options as development progresses.
I found a related question: When is it appropriate to create a new table in the WordPress database?, which indicates that a new table would be more efficient, but I'd like to know more.
It makes sense that if it's faster to use a new table for a thousand entries, it must also be faster for tens or hundreds of entries. What's more, the wp_options table can become very cluttered.
What are the differences in query execution time, memory usage, and other factors between these two options?