Subject Performance question
Author checkmail

Hello,

 

the situation:

state for each element (can be 0 or 1 for Example) = 10010001111..

Is it faster to insert this in a varchar-field or is it better to store it in zwenty smallint separate database fields? I would like to analyze it later.

(read substring or each field)

 

Thanks in advance

 

Best regards

 

Olaf