Apr 18th, 2010, 11:05 AM
Hi Scott,
I should come clean about the InnoDB/MyISAM thing...
Form Tools originally used MyISAM back in an early version of 1.x, but I then converted it to InnoDB with the intention of adding foreign keys to speed things up. I never DID add foreign keys, however, since speed didn't prove to be much of an issue and it caused innumerable other headaches. Now I'm finding that MyISAM is probably a better solution, for the reason you posted above, and others.
So... at risk of looking like a complete idiot (too late!) I *will* be moving back to MyISAM in a future release - probably in the next Beta (2.0.1). At this point I haven't fully checked out the implications of this, but I haven't heard of any problems.
In the meantime, I think you're stuck manually updating the tables each time you create a new form. If that's too much of a pain, you could try tweaking the code to explicitly set them as MyISAM - then only upgrade once the new version is creating everything in the new DB format. If you need help on that, let me know.
- Ben
I should come clean about the InnoDB/MyISAM thing...
Form Tools originally used MyISAM back in an early version of 1.x, but I then converted it to InnoDB with the intention of adding foreign keys to speed things up. I never DID add foreign keys, however, since speed didn't prove to be much of an issue and it caused innumerable other headaches. Now I'm finding that MyISAM is probably a better solution, for the reason you posted above, and others.
So... at risk of looking like a complete idiot (too late!) I *will* be moving back to MyISAM in a future release - probably in the next Beta (2.0.1). At this point I haven't fully checked out the implications of this, but I haven't heard of any problems.
In the meantime, I think you're stuck manually updating the tables each time you create a new form. If that's too much of a pain, you could try tweaking the code to explicitly set them as MyISAM - then only upgrade once the new version is creating everything in the new DB format. If you need help on that, let me know.
- Ben