On Tue, Aug 25, 2009 at 3:16 PM, Suhail Doshi <digitalwarf...@gmail.com>wrote:
> Hi everyone, > Is there any forseeable issue with having an extremely large data set, say > 1 > TB in size for a single database and doing a SELECT * FROM tbl WHERE > <constraints> where <constraints> are super restrictive (in that they > return > only a few rows since only a few match) and the proper indexes are in > place? > > This is on the InnoDB engine. > > I was curious if there are any problems where doing a read on a large > dataset has huge problems down the road. Let's assume the server is a quad > core with 4 GB of RAM. Surely it shouldn't have a *huge* effect? > > Sincerely, > Suhail Doshi > Maybe this article will help give you some idea; http://www.mysqlperformanceblog.com/2006/06/09/why-mysql-could-be-slow-with-large-tables/ -- Muhammad Subair