ijasont Posted May 12, 2003 Share Posted May 12, 2003 I am creating a simple game using PHP. One of the games really just a string of radio buttons. My question: Is it LESS taxing for my server to store all the \"name\" Value\" data in a file or place variable that link to the Name and Value to the db? in other words. I will not be changing this info much at all and the file will be accessed a LOT. Should I place the Name and Values in my db or leave them in the <form> as is? Thanks for the help: Jason Link to comment https://forums.phpfreaks.com/topic/461-a-question-of-taxation/ Share on other sites More sharing options...
gizmola Posted May 12, 2003 Share Posted May 12, 2003 If you mean lookup values, I\'m prejudiced towards keeping that type of stuff in the database. This is what is generally referred to as having a \"data driven\" design. In general small tables like these should be cached by the database, and retrieval is as close to instantaneous as the database can be. There are many different things that can become a bottleneck in an application, and I\'ve found it\'s best to create the system first, then tune around the bottlenecks, rather than to assume you know what the bottlenecks will be and start making design decisions based around those assumptions. Link to comment https://forums.phpfreaks.com/topic/461-a-question-of-taxation/#findComment-1566 Share on other sites More sharing options...
ijasont Posted May 12, 2003 Author Share Posted May 12, 2003 Thanks for the fast reply! Do you have any good book references on MYSQL tuning and optimizing? Jason Link to comment https://forums.phpfreaks.com/topic/461-a-question-of-taxation/#findComment-1568 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.