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
