Re: Performance Issue
Posted by:
Rick James
Date: March 07, 2009 12:22AM
No performance issue with the different sized INTs (TINYINT...BIGINT), per se. But BIGINT takes 8 bytes per row. With a million rows, that's 8MB of disk space and/or cache space, as opposed to 4MB for INT or 1MB for TINYINT.
If you table or database is small, the disk space difference won't matter enough to notice. But when you get into gigabytes of data, it can make a difference.
Subject
Views
Written By
Posted
4068
March 06, 2009 11:57PM
Re: Performance Issue
2165
March 07, 2009 12:22AM
1944
March 09, 2009 12:11PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.