Would you be willing to share what the community what you did to improve performance?

egarriosn - please post back your findings. my system runs so slow. anything you can suggest, i will do.

One thing I've been meaning to try but haven't had time yet is use a code profiling tool to see where bottlenecks in the code are really happening.  Both Red Gate software and JetBrains have code profiling tools.  They both have fully functioning trials.  Could be very useful information for you.

Hi, how much available memory does your server have (when it is running)?

These calls should be cached, if you have enough memory available:

skudiscountloadall
globalsettingloadall

How many different discounts do you have?

Try updating to the latest 4.1.2 version, this introduced serialization for meta fields so the following procedures won't be called if serializeddata field is not empty within product table:

MDPSP_SYS_LOADMETAFIELD
MDPSP_SYS_LOADMETAATTRIBUTES
DISCOUNTLOADBYPRIMARYKEY
MDPSP_SYS_LOADMETAFIELDLISTBYMETACLASSID

Hope this helps,
Sasha.

Also avoid using the complex meta fields like dictionaries since those take more resources to retrieve during runtime.

I have applied up to the current release and database schema of 4.1.13 and code 4.1.2.  My serializedData field in the Product database is all nulls.  How do I get them to populate and what get poplulated in that field. 

 

The products need to be resaved in order for serializedData field to be populated.