HackMD
4.2 Expectation of the possible DB operations, frequencies and data volumes
Assume : User = 10000, Game = 800,
| Table | 可能操作 | 預估使用頻率 (per day) |
表格資料量(tuples) | 系統負擔 (worst case) |
|---|---|---|---|---|
| user | user登入身分驗證 | 500 | 10000 | 5,000,000(Query/Day) |
| user | 新增會員資料 | 10 | don't care | 10(Insert/Day) |
| user | 餘額更新 | 500 | 10000 | 5,000,000(Update/Day) |
| user | 更改密碼 | 5 | 10000 | 50,000(Query/Day) 5(Update/Day) |
| game | 新增遊戲 | 5 | don't care | 5(Insert/Day) |
| game | 更改遊戲售價 | 2 | 800 | 1,600(Query/Day) 2(Update/Day) |
| game | 更改遊戲介紹 | 2 | 800 | 1,600(Query/Day) 2(Update/Day) |
| game | 更改遊戲折扣 | 5 | 800 | 4,000(Query/Day) 5(Update/Day) |
| game | 更改遊戲版本 | 2 | 800 | 1,600(Query/Day) 2(Update/Day) |
| cart | 下訂單新增遊戲庫內容 | 500 | don't care | 500(Insert/Day) |
| game_list | 新增留言 | 50 | don't care | 50(Insert/Day) |
| game_list | 新增遊戲庫分類 | 10 | don't care | 10(Insert/Day) |
| issue | 新增退款需求 | 5 | don't care | 5(Insert/Day) |
| issue | 處理退款需求 | 5 | don't care | 5(Delete/Day) |
| issue | 新增違規 | 3 | don't care | 3(Insert/Day) |
