SQL Server Int or BigInt database table Ids -

-

I am writing a new program and it will need the database (SQL Server 2008). Now what I am running for the system is 64-bit, which brings me to this question. For all the ID columns in different tables, can I have them all INT or BIGINT? I suspect that the system will never cross the INT range, but it seems to me that there is a possibility within some big financial tables. It seems that INT is the standard though ...

OK, let's quickly recapture an INT 32-bit and gives you basically 4 billion worth - if you only calculate values ​​greater than zero, then it's still 2 billion. Do you have many employees? Customers? Products in stock? Orders in the lifetime of your company? Actually?

  • The Beginnum moves ahead of that path. Do you really need ?? Really ?? If you are an astronomer, or particle physics - perhaps an average line of business user? I suspect

    • Imagine that you have a table - say - 10 million rows (order for your company). Let's say you have an order table, and the order id that you have made has been referenced by 5 other tables, and has been used on your order table in 5 non-clustered indexes - not much, I It seems, right?

    By 10 million rows, 5 tables, and 5 non-clustered indexes, which are 100 million instances, where you are using 8 bytes instead of 4 bytes - 400 million bytes = 400 MB . Total waste ... You will need more data and index pages, your SQL server will have to read more pages from the disk and cache more pages ... which is not beneficial for your performance - plain and simple .

    Plus: What is not to think about most programmers: Yes, this dirt in the disk space is cheap but this waste space is also relevant in your SQL server RAM memory and your database cache - and this location is messy Not cheap!

    Shorten for a very long time: actually use the smallest type INT according to your needs; If you have to handle 10-20 different values ​​- Use TINYINT if you need an order table, then I believe INT should be very suitable - only start There is a waste of space.

    Plus: Should you come close to reaching any table in any of the 2 or 4 billion rows, if you really need it, then you have a lot to upgrade your table to a bigger ID Time will be .......


    Comments

    Post a Comment

    Popular posts from this blog

    oracle - The fastest way to check if some records in a database table? -

    -
    I have a big table to work with. I have to see that there are some records whose parent_id is equal to my passing value. Currently I do this by implementing "my_table using select count (*) where parent_id =: id"; If the result> 0, it means that they exist. Because this is a very large table, and I do not care what the actual number of records present, I just want to know if it exists, so I think count (*) Bit is disabled. How do I apply this requirement most quickly? I'm using Oracle 10. # Tips for Hibernation & amp; Tricks It suggests writing in such a way: Integer number = (integer) session .createQuery ("Select Count (*) to ...."). UniqueResult (); I do not know what is the magic of the unique rule? Why does it fast? To compare, select "1 from mytable where parent_id = passId and rowrum", which is more efficient? If you are not interested in the number of records, then there is an EXISTS query one: Select 'y'
    Read more

    php - multilevel menu with multilevel array -

    -
    Just ask someone to solve this problem? I want to create a multilevel menu I can not find the right solution generated with multilevel array, it always gets an array_push error My study came from the original idea But still my Can not match the need. This is my MySQL [code] ----- --------------------- --------------- | ID | PARENT_ID | Name | Link | Seq | 1 | 0 | Dashboad | Dashboard / | 1 | 2 | 0 | Menu 1 | Menu 1 / | 2 | 3 | 0 | Menu 2 | Menu 2 / | 3 | 4 | 0 | Menu 3 | Menu 3 / | 4 | 5 | 2 | Joint Add / | 1 | 6 | 3 | Joint Add / | 1 | 7 | 2 | Edit | Edit / | 2 | 8 | 4 | Joint Add / | 1 ------------------------------------------ [/ Code] I want to do something like this in my array array ('dashboard' = & gt; array ('id' = & gt; '' 'Dame' = & gt; 'Dashboard', 'Title' = & gt; 'Dashboard', 'MatchMin' = & gt; Base_URL (). 'Dashboard /', 'Active' => = & Gt; NULL), &
    Read more

    jQuery UI: Datepicker month format -

    -
    I am trying to change the format of the month that shows in the popup (not in the date that the picker actually I do not have any choice anywhere to do this, do I like to use a sub-string () or something else? What I normally display is Trying to change: Class = "ui-datepicker-title"> January & lt; / span & gt; ... & lt; / div & gt; Div>
    Read more