MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: MySQL InnoDB Performance vs Postgres
Posted by: Robin Schumacher
Date: July 20, 2005 04:16PM

Hi Ram -

How many rows are returned in your InnoDB query? Have you updated the stats for the tables so the optimizer has the right info to work with? Finally, can you post the EXPLAIN output from your query?

Thanks,

Robin

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
MySQL InnoDB Performance vs Postgres
4696
Ram Gudavalli
July 20, 2005 03:42PM
Re: MySQL InnoDB Performance vs Postgres
2020
Robin Schumacher
July 20, 2005 04:16PM
Re: MySQL InnoDB Performance vs Postgres
1983
Ram Gudavalli
July 20, 2005 05:12PM
Re: MySQL InnoDB Performance vs Postgres
2226
Peter Zaitsev
July 20, 2005 05:27PM
Re: MySQL InnoDB Performance vs Postgres
2146
Ram Gudavalli
July 20, 2005 07:57PM
Re: MySQL InnoDB Performance vs Postgres
2157
Peter Zaitsev
July 21, 2005 12:53PM
Re: MySQL InnoDB Performance vs Postgres
1979
Ram Gudavalli
July 24, 2005 11:36PM
Re: MySQL InnoDB Performance vs Postgres
2130
Peter Zaitsev
August 03, 2005 12:34PM
Re: MySQL InnoDB Performance vs Postgres
2117
Jay Pipes
July 21, 2005 05:37AM


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.