Hi there,
I’m new to Yii and also learning OO atm, I have a project which is supposed to be a single user system to track traffic from paid advertisements.
Now I did my research on what MYSQL engine to use for my reporting database, and came to the conclusion that it must be MYISAM because of the much better read performance when using fixed rows with char columns.
The reporting part of the system will have like 95% reads/5% insert/update/delete, and potentially have tens or even hundreds of millions of rows with tracking data after a while. And to quickly build reports of this data I think I have to use MYISAM over INNODB and a single table approach for the tracking data to get the most read performance out of the system…
Ok that was now just to explain what I build and why I use MYISAM
The real question I have is if I can or should leave the relations methods in the models that gii generated for me, completely empty…? Or will that have any negative effects that I don’t know about yet, because I am still learning everything.
BTW: Thanks a lot for making yii, it seems to be an awesome framework and I’m sure I will use it for all of my projects in the future!