Re: Innodb + Large data set

2009-08-25 Thread mos
At 03:16 AM 8/25/2009, you 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 where are super restrictive (in that they return only a few rows since only a few match) and the prope

Re: Innodb + Large data set

2009-08-25 Thread muhammad subair
On Tue, Aug 25, 2009 at 3:16 PM, Suhail Doshi 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 > where are super restrictive (in that they > return > only a few rows since

Innodb + Large data set

2009-08-25 Thread Suhail Doshi
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 where 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