Columns used in the WHERE clause is the good identifier for which columns to
index. You don't want to index every column you select.
Typically adding indexes decreases insert performance. The more indexes the
slower inserts operate, because the indexes also must be updated.
Adding an index to
replies below:
""M. Verheijen"" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Dear reader,
A newbie mysql/php-question here! I've filled a mysql-database with about
1600 records. All these records contain items which
are on sale on a website. Every row contain
Dear reader,
A newbie mysql/php-question here! I've filled a mysql-database with about 1600
records. All these records contain items which
are on sale on a website. Every row contains an integer defining the category to which
a item belongs.
At the left of the website there are buttons linked t