[In-Commerce] Shipping cost (on shipping editing) wasting of auto-increment problem

[Alexander Obuhovich]

There a problem with worthless usage of auto-increment value in ShippingCosts table. When you click on "Costs" tab, or other tab, that triggers shipping cost being saved, then it firstly deletes all records about shipping costs and then create new ones, event when nothing is changed. This approach result a tons of useless change log records to be created. Also this increments ID of that table, event when no data was changed.

--
Best Regards,

http://www.in-portal.com
http://www.alex-time.com

[Phil]

Hello Alex,

I really apreciate to read that you take care of DB fine tuning in
recent posts.
This is very important for future if In-Portal, and also important for
us (users and resellers) to give a better trust in the platform
stabity.

I've said a long time ago that tables and requests could be optimized,
and I'm happy that we go in this direction.

Phil.

[Alexander Obuhovich]

This is all thanks to recently upgraded automatic problem detection methods, that allows developer to notice things, that were previously missed and therefore nearly to impossible to detect.

--
You received this message because you are subscribed to the Google Groups "In-Portal Bugs Team" group.
To post to this group, send email to in-port...@googlegroups.com.
To unsubscribe from this group, send email to in-portal-bug...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/in-portal-bugs?hl=en.

[Alexander Obuhovich]

Here is the task: http://tracker.in-portal.org/view.php?id=609