Doug Chamberlin <chamberlin.doug@...> wrote:

>> Two possible structures.
>>
>> [1] (Symbol, Date, Blob) => Symbol primary and Date is secondary key
>> [2] (Symbol_Date, Blob) => Symbol_Date is single primary key
>
> Relational databases nearly always work best when each individual data
> item (column) is stored separately ...

Doug, I was with you up to the last line.

>
> Go with [2].

Personally, I'd go with [1] (three separate fields) and put a compound
index on Symbol and Date
if they're often used together.

Good luck,

Ann