KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Context: SQL Server 2008, C# I have an array of integers (0-10 elements). Data doesn't change often, but is retrieved often. I could create a separate table to store the numbers, but for some reason it feels like that wouldn't be optimal. Question #1: Should I store my array in a separate table? Please give reasons for one way or the other. Question #2: (regardless of what the answer to Q#1 is), what's the "best" way to store int[] in database field? XML? JSON? CSV? EDIT: Some background: numbers being stored are just some coefficients that don't participate in any relationship, and are always used as an array (i.e. never a value is being retrieved or used in isolation).
Tags (comma-separated)
Save Edits
Cancel