Absorbator Posted November 11, 2009 Share Posted November 11, 2009 I'm wondering are MySQL tables more efficient than normal files in the matter of performance. I know that MySQL stores tables in files, but I still don't know which one to prefer - to store my data in MySQL tables or in "regular" files? Quote Link to comment https://forums.phpfreaks.com/topic/181098-store-in-mysql-or-in-file/ Share on other sites More sharing options...
PFMaBiSmAd Posted November 11, 2009 Share Posted November 11, 2009 It depends on what your data is and what you are doing with it. If you are doing typical things, such as finding specific values and ordering them a specific way, using a database engine, which uses compiled code to do the finding and ordering will be at least 100 times faster than using some slow parsed/tokenized/interpreted php code to do the finding and ordering of the data that is in a file. Quote Link to comment https://forums.phpfreaks.com/topic/181098-store-in-mysql-or-in-file/#findComment-955520 Share on other sites More sharing options...
trq Posted November 11, 2009 Share Posted November 11, 2009 Completely depends on how much data and what exactly you plan on doing with it. If you plan on searching through or organizing your data for display then thats pretty much what databases are made for. Quote Link to comment https://forums.phpfreaks.com/topic/181098-store-in-mysql-or-in-file/#findComment-955521 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.