Developer forum

Forum » Development » Performance DW 7 implementation

Performance DW 7 implementation

E-mail notifications

Reply
Posted on 11/05/2011 13:25:44

We are currently implementing our first DW webshop.

After the implementation of the new design we are experiencing performance issues and do not know where to look.

I did the following things to boost performance, but still no luck:
- enabled "Disable 7.1 logging (CartV1, CartV2, Payment gateways and Checkout handlers)"
- disabled statistics
- Added 1GB of RAM Memory to the webserver
- Updated DW to 19.2.2.3

I also did some SQL select query's on the database to see test the performance of the SQL database. This looks fine.

After the update to 19.2.2.3 the website seems a little faster, but when I add something to the cart the website is extremely slow.

Does anyone have a suggestion to speed things up?

EDIT:
I don't know if this has anything to do with the above. But we have also implemented the Norriq NAV connector.

 


Replies

 
Nicolai Høeg Pedersen
Posted on 11/05/2011 14:14:52
Reply
It depends on the solution.

These are things I've seen before
- It could be a custom module or some add-ins that do too many db connections
- It could be many XSLT templates or XSLT templates with bad performance
- It could be large HTML output

Also - of course it could be DW or some configuration.

Could you provide a URL - either here or by mail - then we will have a look

BR Nicolai
 
Posted on 11/05/2011 14:29:10
Reply
The URL is http://109.72.179.38/
I have send you an e-amail with the login for the DW-admin.



 
Jacob Jensen
Posted on 12/05/2011 11:14:12
Reply
If you use XSLT templates for your group list, product list, product item etc. it could be the following...
XML loops... Have you limited the available loops to limit the XML beeing processed?
Look at the code below, you can limit the loops avaliable, which increaces performance...
You set this variable in the top of your XSLT template (You can add more loops separated with commas):
<xsl:variable name="availableloops" select="'Products,ProductGroups'" />


 

You must be logged in to post in the forum