Click here to Skip to main content
14,327,370 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.
 
GeneralRe: just thought of kind of a cool idea that's simple but neat (maybe) Pin
musefan20-Sep-19 4:38
membermusefan20-Sep-19 4:38 
GeneralRe: just thought of kind of a cool idea that's simple but neat (maybe) Pin
honey the codewitch20-Sep-19 5:22
memberhoney the codewitch20-Sep-19 5:22 
GeneralRe: just thought of kind of a cool idea that's simple but neat (maybe) Pin
OriginalGriff20-Sep-19 2:38
protectorOriginalGriff20-Sep-19 2:38 
GeneralRe: just thought of kind of a cool idea that's simple but neat (maybe) Pin
honey the codewitch20-Sep-19 2:40
memberhoney the codewitch20-Sep-19 2:40 
GeneralRe: just thought of kind of a cool idea that's simple but neat (maybe) Pin
PeejayAdams20-Sep-19 3:00
memberPeejayAdams20-Sep-19 3:00 
GeneralRe: just thought of kind of a cool idea that's simple but neat (maybe) Pin
Slacker00720-Sep-19 2:54
professionalSlacker00720-Sep-19 2:54 
GeneralRe: just thought of kind of a cool idea that's simple but neat (maybe) Pin
honey the codewitch20-Sep-19 2:56
memberhoney the codewitch20-Sep-19 2:56 
GeneralRe: just thought of kind of a cool idea that's simple but neat (maybe) Pin
PIEBALDconsult20-Sep-19 3:12
protectorPIEBALDconsult20-Sep-19 3:12 
Can it go arbitrarily deep?

And remember that .net's Regular Expression engine is far richer than most, so you may not be describing a generally-applicable technique.

I've been working at loading data from JSON files to SQL Server for only about a year now. I convert JSON to XML on-the-fly and pass the XML elements to SQL Server for further processing and storage -- using SQL Server's built-in XML functions.

In my situation, it's all about getting data from file to table as quickly as possible (with an eye toward not hogging resources) and I never need to have all the objects in memory at once.
Like you, IO seems to be the main bottleneck, with writing to the database being slower than reading from the disk.
GeneralRe: just thought of kind of a cool idea that's simple but neat (maybe) Pin
honey the codewitch20-Sep-19 3:15
memberhoney the codewitch20-Sep-19 3:15 
GeneralRe: just thought of kind of a cool idea that's simple but neat (maybe) Pin
lw@zi 20-Sep-19 3:47
professional lw@zi 20-Sep-19 3:47 
GeneralRe: just thought of kind of a cool idea that's simple but neat (maybe) Pin
honey the codewitch20-Sep-19 4:29
memberhoney the codewitch20-Sep-19 4:29 
GeneralRe: just thought of kind of a cool idea that's simple but neat (maybe) Pin
musefan20-Sep-19 4:55
membermusefan20-Sep-19 4:55 
GeneralRe: just thought of kind of a cool idea that's simple but neat (maybe) Pin
honey the codewitch20-Sep-19 5:02
memberhoney the codewitch20-Sep-19 5:02 
GeneralRe: just thought of kind of a cool idea that's simple but neat (maybe) Pin
lw@zi 20-Sep-19 5:51
professional lw@zi 20-Sep-19 5:51 
GeneralRe: just thought of kind of a cool idea that's simple but neat (maybe) Pin
honey the codewitch20-Sep-19 5:54
memberhoney the codewitch20-Sep-19 5:54 
GeneralRe: just thought of kind of a cool idea that's simple but neat (maybe) Pin
Sander Rossel21-Sep-19 2:02
professionalSander Rossel21-Sep-19 2:02 
GeneralRe: just thought of kind of a cool idea that's simple but neat (maybe) Pin
honey the codewitch21-Sep-19 3:23
memberhoney the codewitch21-Sep-19 3:23 
GeneralRe: just thought of kind of a cool idea that's simple but neat (maybe) Pin
honey the codewitch21-Sep-19 3:25
memberhoney the codewitch21-Sep-19 3:25 
GeneralRe: just thought of kind of a cool idea that's simple but neat (maybe) Pin
Sander Rossel21-Sep-19 3:27
professionalSander Rossel21-Sep-19 3:27 
GeneralRe: just thought of kind of a cool idea that's simple but neat (maybe) Pin
honey the codewitch21-Sep-19 3:28
memberhoney the codewitch21-Sep-19 3:28 
GeneralRe: just thought of kind of a cool idea that's simple but neat (maybe) Pin
Sander Rossel21-Sep-19 3:39
professionalSander Rossel21-Sep-19 3:39 
GeneralMan vs. Machine Pin
PeejayAdams19-Sep-19 23:57
memberPeejayAdams19-Sep-19 23:57 
AnswerRe: Man vs. Machine Pin
lopatir20-Sep-19 0:10
memberlopatir20-Sep-19 0:10 
GeneralRe: Man vs. Machine Pin
PeejayAdams20-Sep-19 0:20
memberPeejayAdams20-Sep-19 0:20 
GeneralRe: Man vs. Machine Pin
Slacker00720-Sep-19 1:28
professionalSlacker00720-Sep-19 1:28 

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.