Datat Base Option and Performance

[Andrew Robinson]

This might not be the best place to post this, but I thought I would give it
a try:

I am working on a small to medium sized web site for my company that will
have some dynamic content. "Corporate" controls our web servers and I am not
sure that I can get SQL or MSDE installed on a machine for this web site.

I am thinking about serializing the DataSet and storing it as an XML file.
Lets say that DataSet contains three tables and about 20-30 records in each
of them. The site might be visited by 50-100 people per day. Difficult to
put hard numbers on any of this, but what will my performance be like using
a flat XML based source instead of SQL? I will not be writing any
information back to the database, but rather just using it for configuration
information including product names and information. I realize that it will
be opened and read with each page hit.

thanks for any info.

-Andrew

 

[Jason S]

You should be just fine with a light user load like that. Investigate the
cache mechanism to alleviate any repetitive disk hits.

Regards,
Jason S.

 

[David Browne]

This might not be the best place to post this, but I thought I would give it
a try:

I am working on a small to medium sized web site for my company that will
have some dynamic content. "Corporate" controls our web servers and I am not
sure that I can get SQL or MSDE installed on a machine for this web site.

I am thinking about serializing the DataSet and storing it as an XML file.
Lets say that DataSet contains three tables and about 20-30 records in each
of them. The site might be visited by 50-100 people per day. Difficult to
put hard numbers on any of this, but what will my performance be like using
a flat XML based source instead of SQL? I will not be writing any
information back to the database, but rather just using it for configuration
information including product names and information. I realize that it will
be opened and read with each page hit.

One xml file, read-only, 100 records, 50-100 people per day.

That's nothing. It will work fine.

And you can always load the XML file into a DataSet and save it in
Application scope.

David