[ciapug] Re: Re: MySQL 5 Stored Procedures (correction)

[Carl Olsen]

I'm thinking that all the advantages of using InnoDB are meaningless with
Propel and that I need to convert all my tables to MyISAM to get a
performance boost and reduce the file size of those tables.  I still think
having my indexed columns in separate tables is a good idea, because I can
remove all the columns that aren't indexed on those tables and I'm guessing
I'll get better performance for full text searches.

-----Original Message-----
From: ciapug-bounces at cialug.org [mailto:ciapug-bounces at cialug.org] On Behalf
Of Tony Bibbs
Sent: Monday, July 24, 2006 3:29 PM
To: ciapug at cialug.org
Subject: Re: [ciapug] Re: Re: MySQL 5 Stored Procedures (correction)

It can digest both MyISAM and InnoDB just fine.

The cool thing is that you can take a MyISAM database and you can edit 
the schema.xml manually to add in foreign key references and the 
generated Propel code will mimick the FK support that MyISAM lacks. 
Come on, now that's hot.

I haven't messed with cascading deletes/updates so I don't know what you 
can expect there.  Correct, your SP's won't be touched so no problems there.

--Tony