troubleshooting Question

Can a text file handle more traffic than a database?

Avatar of bemara57
bemara57 asked on
XMLASP.NETMicrosoft SQL Server 2005
1 Comment1 Solution136 ViewsLast Modified:
I have several application-wide variables that get queried from a database. I'm thinking about putting those values in an XML file and just query against the file instead of the database. I'm wondering if calling values from a text file is superior in performance and scalability of traffic compared to a database. It's a high traffic site,so I'm thinking that 100,000 visitors calling values from a text file would be less intense than calling the values from a database since the database has so much overhead. Is this line of thinking right or should I leave them in the database? In case it matters, I'm using ASP.NET 2.0 and C# for this website.
Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros