Performance increase when using case-insensitive queries with Symfony, Propel and PostgreSQL

Posted by Eric Bartels

Symfony makes heavy use of Propel. Propel finds objects in the storage container using criteria. If you want to let Propel (okay the database) ignore the case you can set this in the criteria. $c = new Criteria ();   // Allow case sensitive searches $c->setIgnoreCase (true);   // Find all posts which name contains [...]