[symfony-users] Re: Performance optimization!HELP!!
Make sure you've read http://www.symfony-project.org/book/1_2/18-Performance - lots of good advice there. http://www.symfony-check.org/ is another useful site. In order of the biggest improvement for the least amount of effort, I'd say: 1. Install a PHP accelerator 2. Make sure your db tables are properly indexed 3. Minimise the number of queries with joins Anything after that starts to get increasingly more time consuming to implement for smaller and smaller gains. If you're using multiple web servers, look at using memcached for session storage and for the view cache. Do not be tempted to share via NFS as it will kill your performance. On Sep 17, 4:40 am, Shi Zhuguo wrote: > Hi there, > > We've just finished a product using Symfony 1.2.7 and it is going to > be online. But after test we got a critical performance problem. We > use Doctrine as database interface layer. > > So far we haven't do many optimizations so I am here for some > practical, effective and quick ways to do optimizations with Symfony > and Doctrine. Any suggestions are welcome! > > Help me and thanks in advance~ --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[symfony-users] Re: Performance optimization!HELP!!
looking at rhe debug toolbar is always excelent to see what exactly is taking so long... On Thu, Sep 17, 2009 at 06:50, Phil Moorhouse wrote: > > Make sure you've read > http://www.symfony-project.org/book/1_2/18-Performance > - lots of good advice there. > > http://www.symfony-check.org/ is another useful site. > > In order of the biggest improvement for the least amount of effort, > I'd say: > > 1. Install a PHP accelerator > 2. Make sure your db tables are properly indexed > 3. Minimise the number of queries with joins > > Anything after that starts to get increasingly more time consuming to > implement for smaller and smaller gains. > > If you're using multiple web servers, look at using memcached for > session storage and for the view cache. Do not be tempted to share via > NFS as it will kill your performance. > > > > > On Sep 17, 4:40 am, Shi Zhuguo wrote: > > Hi there, > > > > We've just finished a product using Symfony 1.2.7 and it is going to > > be online. But after test we got a critical performance problem. We > > use Doctrine as database interface layer. > > > > So far we haven't do many optimizations so I am here for some > > practical, effective and quick ways to do optimizations with Symfony > > and Doctrine. Any suggestions are welcome! > > > > Help me and thanks in advance~ > > > -- Sidney G B Ferreira Desenvolvedor Web --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[symfony-users] Re: Performance optimization!HELP!!
> 3. Minimise the number of queries with joins > > I would be careful about this as we have found a few times now that reducing a join to multiple queries actually increases performance. This is very much a case by case basis. -- Gareth McCumskey http://garethmccumskey.blogspot.com twitter: @garethmcc --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[symfony-users] Re: Performance optimization!HELP!!
On Sep 17, 2009, at 7:47 AM, Gareth McCumskey wrote: > > 3. Minimise the number of queries with joins > > > I would be careful about this as we have found a few times now that > reducing a join to multiple queries actually increases performance. > This is very much a case by case basis. That's always going to be the case if you are replacing joins with multiple queries that does the same thing. You're replacing in-memory and highly optimized database code with multiple trips over the wire (even localhost has a delay) plus query parsing plus result set parsing plus object hydration. Reducing joins only works in a handful of special cases like: 1) denormalize the data so you don't need to join to return the same result set, 2) if you can get the same result set by skipping a join, 3) you can eliminate some data from the result set to remove a join. -- Jacob Coby --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[symfony-users] Re: Performance optimization!HELP!!
On Thu, 17 Sep 2009, Phil Moorhouse wrote: > If you're using multiple web servers, look at using memcached for > session storage and for the view cache. memcache is also great for caching routing, database query results and function results. I work on a site with huge traffic and memcache has been fantastic. -- --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---