Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 25
Joined: Wed 10 Nov 2004 16:07
Location: Orland Park, IL U.S.A.


Post by danzman » Wed 10 Nov 2004 16:24

I am not sure why my previous posting did not show up. Anyway my problem is the big speed difference between MyIsam and InnoDB. Using InnoDB files, it takes about 30 seconds to move from row to row. I am sure I have configured the InnoDB parameters correctly. Any suggestions?

Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Re: MyDAC/InnoDB

Post by Ikar » Thu 11 Nov 2004 09:32

It is a known problem of InnoDB. We cannot suggest you any method to optimize access, try to contact MySQL AB.

Post Reply