Sometimes you have a table contains `message` which is TEXT or BLOG columns,
and your frequently used columns are `id`,`title`,`time`.

So, how to lazy load the `message` 's content to fast your sql query?

The answer is use propel's lazyload function.

schema.xml Example:

................
  <table name="test" idMethod="native">
    <column name="id" type="INTEGER" size="10" primaryKey="true" autoIncrement="true"
           required="true"/>
    <column name="title" type="VARCHAR" size="255" required="true"/>
    <column name="message"  type="CLOB" lazyLoad="true" />
    <column name="time" type="TIMESTAMP" required="true" defaultValue="0000-00-00 00:00:00"/>
    <vendor type="mysql">
      <parameter name="Engine" value="InnoDB"/>
      <parameter name="Charset" value="utf8"/>
    </vendor>
  </table>
...............

Yes,very simple, just mark the column with lazyLoad="true"



Date: 2012-01-16 08:49:45 and last modified: 2012-01-16 08:55:46

Relate tags:

Hot tags: