Say you have a table that could potentially be several thousand rows or more (lots) and you need to do a select based on an indexed field or a group of indexed fields.
For example, let's say the table has the following fields: content_id pKey object_id indexed integer field this_id indexed integer field another_id indexed integer field The select might look like: SELECT * FROM theTable WHERE object_id = 1 AND this_id = 2 AND another_id = 5; Is there a size of table where the selects would become slow? Or does the indexing of each of the fields take care of the problem? I am concerned about the table becoming several hundred of thousands of rows big. I'm using mysql and/or postgresql. Matt Friedman Web Applications Developer www.SpryNewMedia.com Email: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]