I have the option of storing data online as text files, or storing data online in a MySQL database. If the information is stored as a text file, all I have to do is a HttpWebRequest to the text file to retrieve the information. I'm willing to store the information in a MySQL database if its faster. For you who want to know what I'm doing to provide a better solution, I'm simply communicating client and server through the web. I don't want to use TCP for many reasons (like my customers don't know how to open ports). How fast is a C# mysql database query, providing I used optimal code and I have an average internet connection. Is it faster than reading the contents of a text file online? (the text file is on the internet, not on the local disk).
C# Microsoft Windows XP-Vista .NET 3.5 How fast is a mysql database query?
Collapse
X
-
senol, your reply was completely irrelevant to the OP's question and has been deleted.
MODERATOR
As to the question, Databases should be faster than directly accessing text files, especially if you create your indexes properly. I don't know specifics to the speed of MySql vs. any other DB, but you should get better results and be able to manipulate your data better in a database.Comment
Comment