Today I found the possibility to get rid of the id number and /content/ part in the URL of my K2 items. This is very good news for the SEO of my website.

But I see this warning:

"Enabling this option will modify all K2 URLs making them more SEO friendly. However this option will add a significant performance hit for websites with more than a few hundred K2 items in them. Use with caution. This option is disabled by default. "

What effects will this have on a website with e.g. 500 K2 items? Or K2 items?

Where will this generate a load? On the database?

If anybody can give more information...

Greets,

With 500 items you should be ok.
If you plan to have items by the thousands, I would not use this feature unless I was using a VPS which was set up properly.

This is our server:

CPU: 1x Intel Xeon E3-1220
MEM: 2x8GB ECC
RAID CONTROLLER: HW
HDD: 2x Samsung Pro SSD 256GB
NICs: 2x + ilo7

We host around 150 Joomla websites on it.

But, for our important SEO clients this would be a very good feature. So, as long as you stay under 500 items you're generally OK? From this amount, the page load on the database will increase a lot?

It depends, on the traffic, but basically I think you should be fine.
Use caching to be extra sure.

Taking that thousands of items along with K2 SEO feature enabled would produce perfomance hit on a website - can you say if it depends on number of K2 Items in Joomla! database overall or only that Items which take part in K2 SEO alias routing? I have like 200-300 (and about more 800 planned) K2 items on my website, but most of them linked to main Menu normally (in a standard Joomla! way), and just about 10% of them are blog category entries whith K2 SEO generated urls like /blog/blog-post-k2-alias. Does that make sense? Shoud I consider only blog items amount and keep it below 1000 or it doesn't matter and only total amount of all K2 Items plays role in that performance overhead?

I use quite powerful VPS for production where server cache is enabled, but it's good to look forward and get prepared.
Thanks

So basically you are talking about roughly a couple of hundred URLs generated with the advanced SEF settings and with caching enabled.

Realistically I don't see any major issues (apart from keeping distinct aliases).

To be 100% sure since you are on a powerful VPS, you can always populate demo items and stress test it and tweak it. This way you won't have any nasty surprises (altogether not only from K2's settings) down the road.

Thanks Krikor for the answer. Stress test with demo items is the great idea.

Nice to be of assistance :)