MySQL :: Re: Performance with select query that joins two tables one with 45MM and another with 12MM

Contact MySQL |
Login | Register

The world's most popular open source database

Documentation Downloads MySQL.com

Developer Zone

Section Menu:

New Topic

Re: Performance with select query that joins two tables one with 45MM and another with 12MM

Posted by: M Sundar
Date: May 01, 2009 10:12AM

Thanks Rick for all your suggestions, I am trying to avoid the schema refactoring but looks like it is not avoidable for longer term solution. I will try some of your suggestions and let you know.

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Views

Written By

Posted

Performance with select query that joins two tables one with 45MM and another with 12MM

5045

M Sundar

February 18, 2009 08:00PM

Re: Performance with select query that joins two tables one with 45MM and another with 12MM

2282

Vince Gatto

February 18, 2009 08:53PM

Re: Performance with select query that joins two tables one with 45MM and another with 12MM

2124

aftab khan

February 19, 2009 05:34AM

Re: Performance with select query that joins two tables one with 45MM and another with 12MM

2601

M Sundar

February 19, 2009 05:17PM

Re: Performance with select query that joins two tables one with 45MM and another with 12MM

2675

Rick James

February 20, 2009 12:28AM

Re: Performance with select query that joins two tables one with 45MM and another with 12MM

1873

M Sundar

May 01, 2009 10:12AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.