# 4.2 Expectation of the possible DB operations, frequencies and data volumes

Assume : User = 10000, Game = 800,

##
| Table | 可能操作 |預估使用頻率<br>(per day)|表格資料量(tuples)|系統負擔<br>(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)<br>5(Update/Day)|
|game| 新增遊戲 |5|don't care|5(Insert/Day)|
|game| 更改遊戲售價 |2|800|1,600(Query/Day)<br>2(Update/Day)|
|game| 更改遊戲介紹 |2|800|1,600(Query/Day)<br>2(Update/Day)|
|game| 更改遊戲折扣 |5|800|4,000(Query/Day)<br>5(Update/Day)|
|game| 更改遊戲版本 |2|800|1,600(Query/Day)<br>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)|