Jump to content


Photo

A question of taxation


  • Please log in to reply
2 replies to this topic

#1 ijasont

ijasont
  • Members
  • Pip
  • Newbie
  • 5 posts

Posted 12 May 2003 - 06:09 PM

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
Jason Tugman [br]wannabe PHP Game Dev

#2 gizmola

gizmola
  • Administrators
  • Advanced Member
  • 4,664 posts
  • LocationLos Angeles, CA USA

Posted 12 May 2003 - 09:35 PM

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.

#3 ijasont

ijasont
  • Members
  • Pip
  • Newbie
  • 5 posts

Posted 12 May 2003 - 10:39 PM

Thanks for the fast reply!

Do you have any good book references on MYSQL tuning and optimizing?

Jason
Jason Tugman [br]wannabe PHP Game Dev




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users