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, Joćo Alexander Marques [EMAIL PROTECTED] Uranet Projetos & Sistemas Ltda. Tel. : 55 11 3242-1353 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
