Which would be more resource intensive: Accessing a text file (Large, all data) every few seconds or Accessing a MySQL database every few seconds?
Through PHP that is.
i think contacting the MySQL database would be more intensive.. but when taking out data, then parsing it and all that.. MySQL will do that much faster for you.(and also more secure).
It would be doing it every about 1-2 seconds and the file is about 3 mbs. It gets it all each time.