If I have a table that has, say, 250,000 rows, would a SELECT statement be very slow? What I mean is, does mySQL somehow keep track of where cells that start with a certain letter, etc. are?
| SitePoint Sponsor |
If I have a table that has, say, 250,000 rows, would a SELECT statement be very slow? What I mean is, does mySQL somehow keep track of where cells that start with a certain letter, etc. are?
Have you added suitable indexes to your table?
Sean
Harry Potter
-- You lived inside my world so softly
-- Protected only by the kindness of your nature
Since I have no idea what you're talking about, I assume the answer is no . . .
Harry Potter
-- You lived inside my world so softly
-- Protected only by the kindness of your nature
Off topic I know, but I always thought the plural of index was indices. Oh well...
-Sam
Sam Hastings
I believe either indexes or indicies is correct; I prefer indexes.Originally Posted by Devilware.net
Deluxe Portal Project Manager
not indicies, indices
Posting Permissions
Bookmarks