Hi.
On Wed 2002-12-18 at 18:40:04 +0000, [EMAIL PROTECTED] wrote:
>
> PLATFORM: 3.23.52-max-nt with Windows 2000 professional (default table type)
>
> I have discovered a performace issue when joining several tables together.
> The performance is extremely poor when performing select queries using the
> WHERE clause and joining the tables with the pk_media_id = fk_media_id
> etc... I guess this is what people might think about when considering using
> mysql. With SQL 2000 Windows Server, and ACCESS, there was no loss in
> performace. 4 of my tables are cross reference tables as such:
Access? You aren't serious, are you? If you really experience
Microsoft Access being faster than MySQL, you are doing something
*seriously* wrong. Probably keys missing or not used for whatever
reason.
Please post the result of EXPLAIN for the query in question and the
result of SHOW INDEX. Also SHOW CREATE TABLE, if posting that
information is OK with you. And whatever information you consider to
be of interest.
Regards,
Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
