l3pp4rd/DoctrineExtensions — Issue #170: [Sluggable] Unique feature slow...
Author: jstout24
Created: 2011-10-12 17:24:34+00:00
State: open

I was going to use the unique feature, but realized it does a select on all the data. My data will be user generated and have over 3 million users.. so there's going to be duplicate title posts.

Why not do orderBy slug desc and setMaxResults(1) for people with this use-case instead of:

SELECT slug FROM post p WHERE p.slug LIKE 'my-slug%'