I am a .net developer and devolving an application for a company. For that I need to write a little php script to meet my needs. My app need to check some information which randomly change almost every second from internet. I am thinking to make a php script so that I can give app the needed information. My idea is to use a simple text file instead of a mysql database (I am free to use a mysql db also). And then make two php pages. For example writer.php and reader.php
work of writer.php is very simple. This file will save the submitted data to the text file I want to use as db.
reader.php will read the text file and then show as simple text and on every read it will also empty the text file.This file will be read by my app. work done.
Now the logical questions.
reader.php will be read by 40 clients in the same time. If there is any conflicts?
If this method will be fast than mysql db?
If this method is more resource consuming than a mysql db?