After trying to use the attributes to extend some products data, we gave up due to slow performance in POS. The attribute code in Retailserver was/is complex and slow.

As SQL Server has some great support for querying and using JSON data, would it be possible to handle the attribute data or extended data for products as JSON documents?

So when a POS solution needs to extend the product information a JSON document could be a field in the product table. That JSON information could then be handeld by extension code to display it or use in it any extension logic.

This could open up a very flexible and fast way of extending product information were no new ext.InventTable is needed and replication does not need to be extended as the extended information is all in one JSON document column.

Same thing could be done around customers if needed..

The performance should be much faster than the current attribute solution.