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
Recent entries:
- Emacs rainbow mode
- Squirm a url rewriter for squid
- How to use rsync for transferring files over ssh
- Vide: GRE tunnel
- Video: how to install freebsd
- Video: Install zend framework
- Video: Install Window7 from network
- Install Window7 from a PXE Boot server (Linux/FreeBSD)
- Create GRE tunnel with FreeBSD8
- What's cooking for FreeBSD 9