[RSS Feed/News] mysql and indexes?

[XenForo]

Here is my next table:

- item_id => auto

- group_id;
the items can be in groups and they are fetched as groups (select * where group_id =x)

- another_id
items also are fetched by this _id

- title

- order

A similar example uses item_id/another_id as an index.

Indexes are used to find rows with specific column values quickly. Without an index, MySQL must begin with the first row and then read through the entire table to find the relevant rows. The larger the table, the more...
Click to expand...

Read more

ادامه مطلب...