Steven Roussey writes:
>
> Some clarification. On this table there are a lot of indexes, but there is
> one unique/primary key, and it is that one that the replace should be
> checking for. The other indexes have the same fields in different places
> though. Table key def is something like this:
>
> PRIMARY KEY (f,m),
> KEY (f,d,a),
> KEY (f,d,p,m),
> KEY (u,d,a,f),
> KEY (i,d,a,f),
> KEY (l,d,a,f),
> FULLTEXT (t,m),
> FULLTEXT (a,e),
> KEY (f,r,d,m)
>
>
> Sincerely,
>
> Steven Roussey
> Network54.com
> http://network54.com/?pp=e
>
Hi!
You definitely have lot's of indices !!
May be too many !!
With so many indices you probably can't make a good use of the
key_buffer, that is why things could run slow although MySQL finds out
the index to use.
Schema normalisation and query optimisation would reap most of benefit
in your case.
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
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