The latest articles on DEV Community by Shareque (@iamshareque). https://dev.to/iamshareque https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F306075%2F6206c4a6-cb18-4ab3-b968-c902bd4b00a5.jpg https://dev.to/iamshareque en Shareque Thu, 08 Oct 2020 11:23:06 +0000 https://dev.to/iamshareque/what-is-an-optimized-way-of-product-discount-in-db-5hg5 https://dev.to/iamshareque/what-is-an-optimized-way-of-product-discount-in-db-5hg5 <p>I have product price based on 3 different ways <br> 1) Fixed (single)</p> <p>2) Vary by the quantity range (<br> 1-100 = $60 <br> 101-200 =$55 <br> 201-300=$50<br> 301-400=$45<br> 401-500=$40</p> <p>3) Vary by size<br> M =$50<br> L= $60<br> XL=$70</p> <p>but one type at a time, so should I create a discount price column with a discount percentage, or just calculate at run time.</p> database sql