Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ristos85
Starting Member
8 Posts |
 Posted - 2014-01-27 : 15:29:39
|
Hi,I'm trying to design a capacity planning tables. Idea is to have a possibility to plan each unique item (1000 new unique items per year) to date that I choose. What would be the best solution to design a database on that? Solution that I come up is to create 2 tables 1) unique item ID with all dates2) Items with required quantity (Please see image).Problem is that using this solution I would have ~10 million of records in dates table within 5 years which seems a lot. Is there some other way to design it? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-01-27 : 15:33:34
|
| I'm not able to answer your question as I don't understand the info you posted. But I wanted to mention that 10 million rows in a table is not at all a big table, especially if it's over 5 years. Some of us support systems that receive that many or MORE inserts PER DAY.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
Ristos85
Starting Member
8 Posts |
Posted - 2014-01-27 : 15:42:32
|
| I want to create a simple php + mysql production planning tool. Meaning that producing each item requires certain amount of time and number of working hours per day limits how much I could plan to produce each day. |
|
|
|
|
|
|
Designing capacity planning tables MYSQL