Click here to Skip to main content
15,499,289 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.

 
JokeRe: Simple question for the Database Rock Stars Pin
Duncan Edwards Jones16-Apr-15 2:10
professionalDuncan Edwards Jones16-Apr-15 2:10 
GeneralRe: Simple question for the Database Rock Stars Pin
Richard Deeming16-Apr-15 3:26
mveRichard Deeming16-Apr-15 3:26 
GeneralRe: Simple question for the Database Rock Stars Pin
Kevin Marois16-Apr-15 2:49
professionalKevin Marois16-Apr-15 2:49 
GeneralRe: Simple question for the Database Rock Stars Pin
charlieg16-Apr-15 5:24
Membercharlieg16-Apr-15 5:24 
GeneralRe: Simple question for the Database Rock Stars Pin
Sander Rossel15-Apr-15 21:52
professionalSander Rossel15-Apr-15 21:52 
GeneralRe: Simple question for the Database Rock Stars Pin
OriginalGriff15-Apr-15 22:05
mveOriginalGriff15-Apr-15 22:05 
GeneralRe: Simple question for the Database Rock Stars Pin
GuyThiebaut15-Apr-15 22:24
professionalGuyThiebaut15-Apr-15 22:24 
GeneralRe: Simple question for the Database Rock Stars Pin
Rutvik Dave15-Apr-15 23:21
professionalRutvik Dave15-Apr-15 23:21 
10,000 is very low number to compare anything for performance.

When you compare XML / Flat file with database the only advantage you get is write performance and cheaper cost. Which is never a deciding factor for any application, whether its enterprise or consumer.

The things you can get with database and not with xml are:
  • Concurrency (You can control if you have insert/update at the same time on your data)
  • Transaction Reliability (You can go back to an older data/snapshot to correct a mistake)
  • Backup (You can configure very efficient backup policy i.e. log shipping / replication which is not possible with XML)
  • Partitioning (You can store data to different database/location based on region and then retrieve it easily)
  • Archiving (Transfer data to archive in realtime and then access it in realtime with linked database)
  • Security (fine grain control over who can access what)
  • And the most important, Well Structured and Connected Data (makes complex query for different reports very easy)
So I would suggest you to use XML for intermediate stuff, or to store settings. but other than that don't waste your time and efforts. Just go with the RDBMS.

And for Mobile device to store offline stuff you can use XML / JSON Documents (JSON is better than XML). But at the end you should have a RDBMS server and Sync your offline data to it.

GeneralRe: Simple question for the Database Rock Stars Pin
Eddy Vluggen15-Apr-15 23:24
professionalEddy Vluggen15-Apr-15 23:24 
GeneralRe: Simple question for the Database Rock Stars Pin
Jörgen Andersson16-Apr-15 0:26
professionalJörgen Andersson16-Apr-15 0:26 
GeneralRe: Simple question for the Database Rock Stars Pin
Mark_Wallace16-Apr-15 1:38
MemberMark_Wallace16-Apr-15 1:38 
GeneralRe: Two Words... Pin
Jeremy Falcon16-Apr-15 5:17
professionalJeremy Falcon16-Apr-15 5:17 
GeneralRe: Simple question for the Database Rock Stars Pin
PIEBALDconsult16-Apr-15 5:40
professionalPIEBALDconsult16-Apr-15 5:40 
GeneralRe: Simple question for the Database Rock Stars Pin
wreckless16-Apr-15 6:59
Memberwreckless16-Apr-15 6:59 
GeneralRe: Simple question for the Database Rock Stars Pin
User 483504716-Apr-15 9:46
MemberUser 483504716-Apr-15 9:46 
GeneralAimed ads Pin
Jörgen Andersson15-Apr-15 13:36
professionalJörgen Andersson15-Apr-15 13:36 
GeneralRe: Aimed ads Pin
Steve Wellens15-Apr-15 13:53
MemberSteve Wellens15-Apr-15 13:53 
GeneralRe: Aimed ads Pin
Mycroft Holmes15-Apr-15 16:00
professionalMycroft Holmes15-Apr-15 16:00 
JokeRe: Aimed ads Pin
Cornelius Henning15-Apr-15 16:46
professionalCornelius Henning15-Apr-15 16:46 
GeneralRe: Aimed ads Pin
Mycroft Holmes15-Apr-15 16:55
professionalMycroft Holmes15-Apr-15 16:55 
GeneralRe: Aimed ads Pin
Daniel Pfeffer15-Apr-15 20:48
professionalDaniel Pfeffer15-Apr-15 20:48 
GeneralRe: Aimed ads Pin
JimmyRopes15-Apr-15 17:43
professionalJimmyRopes15-Apr-15 17:43 
GeneralRe: Aimed ads Pin
ZurdoDev16-Apr-15 2:35
professionalZurdoDev16-Apr-15 2:35 
JokeRe: Aimed ads Pin
Joan M15-Apr-15 20:15
professionalJoan M15-Apr-15 20:15 
GeneralRe: Aimed ads Pin
Johnny J.15-Apr-15 20:21
professionalJohnny J.15-Apr-15 20:21 

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.


Straw Poll

When thinking about your job, how important is the option to work from home?
Some bosses are casual about where you work, and some, naming no names, will insist you're in the office, always. What are your thoughts?
  Results   769 votes