FileMaker developer.
>Matt Friedman
>Web Applications Developer
>www.SpryNewMedia.com
>Email: [EMAIL PROTECTED]
>
>
>-Original Message-
>From: Miles Thompson [mailto:[EMAIL PROTECTED]]
>Sent: Sunday December 2, 2001 2:53 PM
>To: Matt Friedman; [EMAIL PROTECTE
iedman
Web Applications Developer
www.SpryNewMedia.com
Email: [EMAIL PROTECTED]
-Original Message-
From: Miles Thompson [mailto:[EMAIL PROTECTED]]
Sent: Sunday December 2, 2001 2:53 PM
To: Matt Friedman; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Large Table - Indexed - Select Time
Matt,
A
Matt,
A few things:
Indexes are fastest means of accessing data in a relational database.
Have the indexes you need for your queries, and no more, because
building/adding to the index takes time as well.
Length of the index key value also affects speed - longer
expres
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
