I'm in the design stages of creating a database schema and my problem is that one of the tables I'm creating has the possibility of growing to several billion rows over time. I could probably cut this by a few factors, but we're still looking at least a billion rows.
Each row will only be a few columns so I'm not too worried about space but only the number of rows. Is there some limit on the number of rows? I assume if I index then searching won't be much of a problem? I know this isn't a unique problem so I'm wondering how others have approached it. Any feedback is appreciated. -- View this message in context: http://www.nabble.com/Dealing-With-Very-Large-Tables-tp15812712p15812712.html Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]