Developer forum

Forum » Ecommerce - Standard features » ProductID - nvarchar(30)

ProductID - nvarchar(30)

E-mail notifications
Terri Donahue
Reply
Posted on 01/06/2016 22:02:13

I have the need to increase the ProductID from nvarchar(30) to nvarchar(255). I am getting an error about needing to delete the indexes. This brought up a few thoughts. Will this cause an impact to performance? Also, in EcomGroupProductRelation, the GroupProductRelationProductID is already set to nvarchar(255). Seems if 1 table allows it, it should be OK in the EcomProducts table as well. Just want to make sure I'm not going to cause issues down the road with this change.

Thanks,
Terri


Replies

 
Nicolai Høeg Pedersen
Posted on 02/06/2016 09:02:52
Reply
This post has been marked as an answer

Hi Terri

It might affect performance, but not sure how much. That you will probably be able to Google. But it is a big undertaking to change the size since all foreign keys also needs to be changed.

BR Nicolai

Votes for this answer: 1
 
Terri Donahue
Posted on 02/06/2016 12:39:05
Reply

Hi Nicolai,

Ah, much bigger than I want to undertake. I may have thought of another way to 'parse' the data to enable uniqueness without using the full groupid as part of the productid. Thanks for the help.

Terri

 

You must be logged in to post in the forum