Databases
StackOverflow2013
Postsdbo
POPriority Database size or Performance c#
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPriority Database size or Performance c#
    primarykey
    data
    text
    <p>Sometimes we find our self in situation where we have to choose one from database size or performance.</p> <p>I am working on application for bill accounting in which i store details of bill in table design </p> <pre><code> BillNo ProductName Qty Rate 1 aaaa 1 12 </code></pre> <p>I learned that its not good to store data we can calculate at run time in database like <code>Amount(Qty*Rate)</code> <code>, Tax(Amount*5/100)</code>.</p> <p>But at some point i need Total amount and total vat for thousands of entries, if i follow above approach first i need to select <code>Qty , Rate</code> then perform multiplication for each row then perform addition which will be definitely time consuming.</p> <p>What i was thinking:- Move on with approach which stores data like </p> <pre><code> BillNo ProductName Qty Rate Tax Amount 1 aaaa 1 12 4 16 </code></pre> <p><strong>Disadvantage:-</strong></p> <ol> <li>Need to store extra data in database and which will increase some performance overhead also for insertion of Tax and Amount.</li> </ol> <p><strong>Advantage:-</strong></p> <ol> <li>Need to select only one value from database.</li> <li>No need to perform multiplication operation, which will improve my performance. </li> </ol> <p>Which one is better and efficient in condition like this .</p> <p>Above question is just an example to explain the condition. Mainly question is about whether i go with computed columns or calculation during retrieval. As Calculation during retrieval is good if you don't have large no of records but it is against database rules. Is choice between computed columns or calculation during retrieval depend upon no of records.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USHot Cool Stud
    1. USHot Cool Stud
    plurals
    1. PL
      singulars
      1. LTDuplicate
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POPriority Database size or Performance c#
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POPriority Database size or Performance c#
      1. This table or related slice is empty.
      1. VTDownMod
    1. COWhy don't you test execution times?
      singulars
      1. POPriority Database size or Performance c#
      1. USalxx
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload