sql schema warning on [idx_sf_url_data]
When exporting data or running a schema script when porting from dev to test/prod SQL Manager keeps giving me a warning. I know it's a warning and not an error, merely pointing it out...
Warning! The maximum key length is 900 bytes. The index 'idx_sf_url_data' has maximum length of 1275 bytes. For some combination of large values, the insert/update operation will fail.
But that last sentence always makes me reach for the garlic and keeps my fingers crossed.
J.
Hello Jochem,
This is indeed concerning, so I logged it as a bug in our system and the indexes of this table will be reevaluated for our future releases. Thanks for the report and sorry for the inconvenience caused. I updated your Telerik Points. If you have any further problems, don't hesitate to contact us.
All the best,Hey Svetoslav,
Awesome thanks!
And so far no inconvenience, so far it remains a mere warning.
Jochem
Any word on if/when this will be fixed? We're still getting this warning on a deployment with Sitefinity v5.0.2800.
Hello Ken,
Thnak you for letting us know about your concern. Indeed his still remains a known warning, however we've postponed its implementation as it necessitates breaking changes in the product. Generally the warning should be perceived more as a pure warning rather than a p[possible issue indication. let me elaborate on that - a problem might occur only if the size of the data that generates the index exceeds 900bytes. In this case these columns are app_name and url, which we do not expect to reach this combined size in the normal use case scenarios.
Greetings,
Boyan Barnev
the Telerik team
Just tried to move some db stuff 5.4 and get 3 warnings:
Warning! The maximum key length is 900 bytes. The index 'idx_sf_url_type' has maximum length of 1276 bytes. For some combination of large values, the insert/update operation will fail
I have no clue if this important but it sure is not nice to read.
Markus
Hello Markus,
The warning is displayed by design, since we're indeed went above the default limit for the index size. However in the real case scenario, a problem might occur only if you have data (in this particular case URLs) that is exactly the same up to the limit size (to which it will be truncated), which is a very low probability.
All the best,
Boyan Barnev
the Telerik team
@Boyan
Thank's for the feedback. I assume this is going to stay that way because if you would change it you would run the risk of cutting of some customers URL. But that would be a very low probability :-)
Thanks
Markus
Hi Markus,
Currently we do not have any plans for changing the functionality but we will keep you posted if any changes are about to occur.
Regards,
Victor Velev
the Telerik team