Which technique usually professional CI use for SEO?

[eluser]Unknown[/eluser]
I've used a different means to implement SEO friendly URLS.

Instead of ...
http://www.site.com/cat/Event-and-Entertainment

I use ...
http://www.site.com/cat/Event-and-Entert.../E8RD9221/

The last bit 'E8RD9221' is a 5 char hash combined with the id from my table. This enables me to quickly retrieve the entry from the database using an integer index and hash query (ex. WHERE id=221 AND hash='E8RD9').

This is mainly with performance in mind. The above query is much faster than doing an equals conditional on a VARCHAR field.

$.02