Originally Posted by KULP
That's what I was thinking. Now assume I have 20,000 tweets in a database. Or twitter's seemingly infinite number. Is this when php is no longer an option? I mean, must take forever to search through every tweet (server-side, not myself).
MySQL keeps the indexes sorted and will search for the index to retrieve the requested records. It doesn't have to do a full table scan. And 20,000 records is not very much. I have a table with GPS coordinates for about 2,300 records and MySQL can do a full table scan while performing geometric calculations on the GPS coordinates in a few thousandths of a second. This is much more computationally demanding than a basic select query.