I am doing some inquiries for which many lines are required, some of them add fields and multiply.
I know that this is unclear, but I have a question that the numerical data type is the fastest for these types of operations?
Will the double be faster than the double, because the double is 8 bytes, and the float is 4?
Can INT faster than INT FLOAT (even if both are 4 bytes)?
Will Be Faster than Flat?
Here's some more information: The problem I am solving, gives me the option to store the "float" number as a biggie ... I can only increase the number of them 100,000 before inserting I would be prepared to do this if the beginnings of mathematics were faster than FLOAT.
Thank you.
Byte size affects data retrieval, not calculation based on that. The index can improve this if necessary, but will slow the update / INSERT / DELETE statements.
I suggest selecting the type of data that shows the work you are using. If you do not need any accuracy, there is no reason to consider using DECIMAL or FLOAT.
Comments
Post a Comment