Re: MyIsam vs Innodb Query Performance
conor meegan wrote:
> I am working with a test database. Originally the tables were all innodb.
> I then changed the table type to MyIsam because I wanted to speed up the application
> However when I ran the same EXPLAIN on the exact
> same queries as before, I noticed that the performance statistics had changed from those when
> I was using Innodb tables indicating that the queries would take longer.
I would be very interested to see both EXPLAINs, together with other relevant data (table definitions etc...)
--
felix
Please use
BBCode to format your messages in this forum.
Subject
Views
Written By
Posted
6151
July 29, 2005 05:29AM
Re: MyIsam vs Innodb Query Performance
2497
July 29, 2005 06:58AM
2465
July 29, 2005 03:34PM
1912
August 03, 2005 03:36AM
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.