Despite that, if you're running on MYSQL, remember that view support
is really REALLY bad.
If you've got more than one sub-select. or nested joins, mysql won't
use any indexes.
On Feb 23, 4:32 am, Damien Lepage damienlep...@gmail.com wrote:
Thanks for your suggestion Lawrence. But I don't
Thanks for your suggestion Lawrence. But I don't like it because it requires
an extra step and breaks the built-in task
doctrine:build-all-reload-test-all (because I need my views created between
DB build and tests).
Thanks to the tutorial published on symfony blog yesterday, I found a way to
get
Damien Lepage wrote:
Thanks for your help David.
However, it seems to be different for doctrine. I tried it and it doesn't
work.
The help for *propel:insert-sql* says:
The task connects to the database and executes all SQL statements found in
[config/sql/*schema.sql|COMMENT] files.
But
Damien Lepage schrieb:
I would like to know if there is an easy way to automatically create
views each time I rebuild my database.
In other words, is there a place where I can put a custom script which
will create my views and will be triggered when my database is built (by
Thanks for your help David.
However, it seems to be different for doctrine. I tried it and it doesn't
work.
The help for *propel:insert-sql* says:
The task connects to the database and executes all SQL statements found in
[config/sql/*schema.sql|COMMENT] files.
But the help for