Thanks for this warning. I was not aware of it.
I googled a bit on this issue and it seems that queries on a view should use
indexes of underlying tables when the MERGE algorithm is used.
However I will look ahead to performance issues. Thanks again.
2009/2/23 Simon Gow <simon....@gmail.com>
>
> 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 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 a more integrated solution, using the Event System.
> >
> > In my project configuration I register a new listener on post_command
> event
> > (which is a built-in event of sfTask)
> > $this->dispatcher->connect('command.post_command', array('DatabaseInit',
> > 'createViews'));
> >
> > Then I have a hook to create my views exactly where I want:
> > class DatabaseInit {
> > static public function createViews(sfEvent $event) {
> > if( $event->getSubject() instanceof sfDoctrineInsertSqlTask ) {
> > // create views here
> > }
> > }
> >
> > }
> >
> > Damien
> >
> > 2009/2/21 Lawrence Krubner <lkrub...@geocities.com>
> >
> >
> >
> > > 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 the help for *doctrine:insert-sql* says:
> > > > The task connects to the database and creates tables for all the
> > > > lib/model/doctrine/*.php files.
> >
> > > > Anybody knows how to execute custom SQL script with Doctrine ?
> >
> > > Why not just put this in a shell script and call it from the command
> > > line? That's really all that the above mentioned propel or doctrine
> > > commands do. It would take you, what, 5 minutes to write your own
> script?
> >
> > > --- lawrence
> >
> > > > 2009/2/17 David Herrmann <d...@okto.tv>
> >
> > > >> 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
> > > >>> doctrine:build-db I think).
> >
> > > >>> I read about using Views with Doctrine here:
> >
> > >http://www.doctrine-project.org/documentation/manual/1_0/en/component.
> ..
> > > >>> But I miss information about how to integrate views when using
> doctrine
> > > >>> in symfony.
> > > >> I can only tell how I did it for Propel but I suppose it will work
> for
> > > >> Doctrine, too: just put the SQL to generate your view into something
> > > >> like /data/sql/my_view.sql and it will automatically be included
> during
> > > >> DB build/create execution.
> > > >> If there's a folder /data/sql/doctrine (can't find out atm) then
> that's
> > > >> your place of course.
> >
> > > >> Just make sure your view code gets executed after all the other SQL
> > > >> statements (so all tables exist). Symfony will order the SQL files
> by
> > > >> name, so you can use the file name to change the order.
> >
> > > >> Hope that helps
> >
> > > >> David
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
