database limits
By n1ghtowl
@n1ghtowl (17)
United States
June 7, 2009 6:43am CST
What are the real limits? if my understanding is correct then ... Mysql, MsSql each have a 4billion record per table limit, this is due to the way the indexing is done, atleast on 32 bit hardware and/or OS. several sites clame Oricle can handle unlimited records. does anyone know for sure if Oricle can go beyond the 4Billion limit? Or even some documentation from oricle themselvse as Oricle is rather expensive to find it wont handle my needs.
1 response
@b0naf1de (111)
• United States
9 Jun 09
No because 32-bit give you max of 4billion record limit. Yes that's right, go 64-bit and you'll get more. It's not a file size limit only a record limit, because the variable in memory determined by operating system can only be 32 bits integer, so you cant address larger number in database program code. they can glue some unique bit lenghts by using 2 addresses work around but its just easier to go 64-bit now.
