Re: Optimizing
| From: | .: B i g D o g :. | Date: | Sun, 10 Nov 2002 11:48:54 +0000 |
| Subject: | Re: Optimizing | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-23193@lists.php.net to get a copy of this message | ||
This varies from database to database. I would suggest reviewing the
documentation on your database type.
For review here is some information on indexing from PostgreSQL (my
database of choice):
http://www.postgresql.org/idocs/index.php?indexes.html
That should give you some ideas on how indexing works.
HTHs
On Sun, 2002-11-10 at 18:46, Chris Payne wrote:
> Hi there everyone,
>
> How does indexing work, and does it speed up small / average size DB's of
> around 20,000 records, with 12 columns per record? (Some columns being
> paragraphs of text).
>
> Also, do you create an index on everything or just 1 item or or or :-)
>
> I've not looked at indexing but think it's time to start, but in a way even
> I can understand so I thought i'd ask you all here :-)
>
> Thanks
>
> Chris
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
.: B i g D o g :.