Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 113510

For questions about the persistent storage of database data.

2
votes
2answers
When I say efficient, I mean total storage(kb), and not excessively burdening the CPU. I have 70 columns of data. The last 35 fields have always been NULL. The table has only 4 columns of … before the whole lookup makes sense? What is the best way to handle the 35 blank columns in terms of storage? Create a separate table with a single ID, have the 35 columns with 1 row that has all NULL …
asked May 9 '17 by cybernard
0
votes
Using lookup columns is definitely the way to go here. For all except the columns that are always present. Today I have 2x as much data nearly 100k records, and it only uses 54mb. Storing all those …
answered Aug 24 '19 by cybernard