Jump to content

XML files vs database - need some opinions


OM2

Recommended Posts

I need to open a CSV file and reorder the rows of values

(+ do some text manipulations to individual files)

 

What I really want to do is store the results in an XML file

OK... so I know that database is the way to go with this kind of job

 

But is it a really really bad idea to use XML?

What kind of sorting algorithm would I need to use in reading the CSV file?

Would sorting a CSV file + storing in order into an XML file be more processor intensive than a database?

 

If I had 200 rows in and 30 fields in my CSV file - would this be a big load on the server to process and store in an XML file?

 

The processing part is an important consideration

Ultimately, I will have 1000's of users using (I hope!!)

What would the implications be of a 1000 users tried to run the same process at the same time?

 

OK, so not every user will have 200 rows to process and not all will try at the same time!

But it would be good to know the worst case scenario

 

Why XML? I can create a portable solution, the main reason being though: I can fit more easily into an existing already developed system that does not have databases

 

Thanks

 

 

OM

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.