Archive for tables

How to indicate the specific fields to be saved or updated in CakePHP

Posted in CakePHP, CakePHP 1.2 with tags , , , , , on April 30, 2009 by myleskadusale

If you want to save selected fields only to avoid validating the fields that are not included when you are going to save, do this.

Make an array that has the list of fields that is going to be saved
$fieldList = array(“p_address”,”p_age”);

Next pass the values of $fieldList in the save or saveAll method like this
$this->Person->saveAll($this->data,array(true,true,$fieldList))

That’s it. 🙂

Advertisements

Dealing Large Tables in MySQL

Posted in MySQL with tags , , , , , on February 25, 2009 by myleskadusale

Today I found a site that gives good tips in dealing large tables in MySQL.

Why MySQL could be slow with large tables