venkatesh.naikd (11/30/2015)
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.
Well is this database just supposed to be a list of what each customer has available to sell or is it meant to track actual sales and inventory?