MrAdam Posted August 19, 2010 Share Posted August 19, 2010 Hi guys.For my project there's going to be a series of actions that need to be stored/logged. When displaying these logs there are several types and I need to be able to filter between them, but rarely will mixed types of actions be displayed together. Which of the following methods would be the most efficient/quickest overall..?a) Store the actions within separate tables - a table for each type of action. Then in the odd occasion where I need to select mixed types just join the tables, or.. Store all the actions within one table with a field to determine the type of action and obviously just use a where clause to return the correct type when filtering between them?Thanks for any help or suggestions,Adam Link to comment Share on other sites More sharing options...
MrAdam Posted August 19, 2010 Author Share Posted August 19, 2010 Actually just to give a little more information; there's currently 3 different types of actions defined, however more maybe added in the future. Link to comment Share on other sites More sharing options...
Synook Posted August 19, 2010 Share Posted August 19, 2010 Do the different "actions" all have the same information? If so, it is better to store them all in one table. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.