Good day > Yes, but it doesnt seem right to assume someones app will have the same > amount or rows that is equesl to the max integer the os can hold?
You really have table larger than 2 000 000 000 entries on 32-bit servers? :) Let's see... int = 4 bytes on 32 bit systems: 2 000 000 000 x 4 = 8 000 000 000 = ~ 8 gb minimum per table :) Let's add here at least varchar(255): 2 000 000 000 x (4 + 255) = 518 000 000 000 = ~ 518 gb per table :) Try to search some data through this table. :) There are some architecture solutions for this, like splitting tables into smaller (or shards). -- Валерий Яцко ______________________________________________________________________ [email protected] | http://www.artlebedev.ru
