Hi,
Let´s supose that we have a table with this features :
- about 70000 records;
- only a primary index;
- about 30 fields;
- 50% of SELECTS and 50% of INSERTS/UPDATES. The SELECTS
typically uses about 3 or 4 fields in the WHERE clause.
Creating indexes, one for each field used on SELECTS, will speed up things ?
Or the overhead of updating the indexes on INSERTS/UPDATES does not
compensate ?
MySQL v 3.22.32, Linux Kernel 2.2.17, Pentium III, 256 Ram, 50 dbs, 15
tables in avg / db,
1 db with 200 tables, about 10 simultaneous users.
Regards,
3 messages in com.mysql.lists.mysqlIndex X No Index
