Let me explain in detail,

We are developing application for Grocery stores as SAS model.

Each customer selling items ( More than 3000 items) each items is sold based on its UOM( Unit of measurement)

ex : Rice Bag, It can be (1,3,5,25,50) Kg Bag, Transaction Table rows for rice will be 5 rows.

Similar if we calculate for each item having 5 UOM, then it will be 3000*5=15000, For each Customer.

For 500 Customer it will be 15000*500=7500000 rows.

DB is accessed from Mobile APP through WCF Service.