So I have a basic philosophy question. I have a set of ~4700 records that I need to have locally searchable for my plugin via an auto-complete (it's the Google Product Search categories). Would it be okay to store this data in the options table as an array or would it be better to actually create a separate table in which to store this data?
It's about 317k. Would I be asking for trouble if I just stored it as an array in the options table? Does each page load cache all the site options?