Click here to Skip to main content
15,891,033 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
QuestionAzure Pin
Mycroft Holmes29-Dec-17 20:18
professionalMycroft Holmes29-Dec-17 20:18 
AnswerRe: Azure Pin
Gerry Schmitz30-Dec-17 6:28
mveGerry Schmitz30-Dec-17 6:28 
GeneralRe: Azure Pin
Mycroft Holmes30-Dec-17 13:47
professionalMycroft Holmes30-Dec-17 13:47 
QuestionCredential stuffing / Passing Auth cookie to current user Pin
SEJohnson9-Dec-17 5:00
SEJohnson9-Dec-17 5:00 
QuestionJSON size Pin
Eytukan28-Nov-17 21:07
Eytukan28-Nov-17 21:07 
AnswerRe: JSON size Pin
Eddy Vluggen29-Nov-17 0:58
professionalEddy Vluggen29-Nov-17 0:58 
GeneralRe: JSON size Pin
Eytukan29-Nov-17 22:14
Eytukan29-Nov-17 22:14 
GeneralRe: JSON size Pin
Eddy Vluggen30-Nov-17 1:12
professionalEddy Vluggen30-Nov-17 1:12 
Vunic wrote:
On the other hand, if I'm distributing it into multiple documents, it will need proper indexing/partitionin/sharding things done right.
JSON, XML and CSV are great formats for exporting data; but they do not work well as datastores where frequent updates are expected. If your data contains images, they'll probably be stored in Base64, making the file even larger. If there is no updates expected to the data, and it is merely a static export - then one of the text-based exports is preferred. Reading is fast enough for text, but updating takes a severe and noticable penalty.

Vunic wrote:
Though a single document looks neat on the design
Also a lot easier when making backups and sending stuff. I prefer to put all data in a single file; with a file-based database like SQLite, SQLCe and MSAccess you can easily even store binary data. Another nicety is that you can link to these databases from SQL Server and interact with them as if they were local SQL Server databases.

If the data is not related at all, then I'd recommend zipping your various documents, so it remains "one file" in the eye of the end-user. Since you initially chose JSON, I'd be expecting data that is somehow related.
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]

GeneralRe: JSON size Pin
Eytukan30-Nov-17 20:29
Eytukan30-Nov-17 20:29 
AnswerRe: JSON size Pin
Gerry Schmitz30-Nov-17 5:25
mveGerry Schmitz30-Nov-17 5:25 
GeneralRe: JSON size Pin
Eddy Vluggen30-Nov-17 8:16
professionalEddy Vluggen30-Nov-17 8:16 
GeneralRe: JSON size Pin
Gerry Schmitz30-Nov-17 9:19
mveGerry Schmitz30-Nov-17 9:19 
GeneralRe: JSON size Pin
Eddy Vluggen30-Nov-17 9:32
professionalEddy Vluggen30-Nov-17 9:32 
GeneralRe: JSON size Pin
Gerry Schmitz30-Nov-17 12:02
mveGerry Schmitz30-Nov-17 12:02 
GeneralRe: JSON size Pin
Pete O'Hanlon30-Nov-17 21:14
mvePete O'Hanlon30-Nov-17 21:14 
GeneralRe: JSON size Pin
Gerry Schmitz30-Nov-17 21:40
mveGerry Schmitz30-Nov-17 21:40 
GeneralRe: JSON size Pin
Eddy Vluggen1-Dec-17 0:59
professionalEddy Vluggen1-Dec-17 0:59 
GeneralRe: JSON size Pin
Gerry Schmitz2-Dec-17 3:49
mveGerry Schmitz2-Dec-17 3:49 
GeneralRe: JSON size Pin
Eddy Vluggen2-Dec-17 4:09
professionalEddy Vluggen2-Dec-17 4:09 
GeneralRe: JSON size Pin
Gerry Schmitz2-Dec-17 4:32
mveGerry Schmitz2-Dec-17 4:32 
GeneralRe: JSON size Pin
Eddy Vluggen2-Dec-17 6:43
professionalEddy Vluggen2-Dec-17 6:43 
GeneralRe: JSON size Pin
Gerry Schmitz2-Dec-17 8:44
mveGerry Schmitz2-Dec-17 8:44 
GeneralRe: JSON size Pin
Eddy Vluggen2-Dec-17 9:08
professionalEddy Vluggen2-Dec-17 9:08 
GeneralRe: JSON size Pin
Gerry Schmitz2-Dec-17 10:42
mveGerry Schmitz2-Dec-17 10:42 
GeneralRe: JSON size Pin
Eytukan30-Nov-17 20:30
Eytukan30-Nov-17 20:30 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.