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]

Reply via email to