Magento Plug in Performance Tuning

I implemented a Razuna site that holds the images for our Magento site using the Magento add-in.

Our page loads for our category pages, which shows the list of products, went from 1 second to over 6 seconds (note we are getting the url from Razuna to the files stored on our cloudfront cdn).

What could be taking so long that it adds 5 additional seconds of processing to retrieve the list of items?

What can I do to get this time so the category pages load in the 1-2 second time frame that they were before?

Thanks,

Jim

I forgot to mention, we are using MySQL as the database, with the latest released version of Razuna, and Magento version 1.9.0.2.

For Razuna we have the webserver running on a small Amazon EC2 instance, with 8 GIG of RAM.

For the mySQL we have that running on a separate Amazon EC2 instance, with 4 GIG of RAM.

Thanks,

Jim

There are a couple of things coming into play here.

For Java/Tomcat you can find tuning guides here http://wiki.razuna.com/display/ecp/Configure+Tomcat+for+production+deployment and http://wiki.razuna.com/display/ecp/Adjusting+Memory+Settings+for+Tomcat

I would also highly recommend tuning your MySQL instance.

I have done some more testing, where I wrote my own service to call into Razuna search api using multiple threads to see if I can reduce the search time when processing 10-25 items like I would via the magento categories and found something interesting.

If I run 10 searches sequentially, I get a consistent response time of 7.5 seconds.

if I run all 10 concurrently (threaded), I get a consistent response time of 6.7 seconds for all to complete.

Is there a setting in Razuna somewhere where it is only allowing a single thread to search at a time and then queueing up the rest?

Thanks,

Jim

Here is some more data.

We assign a label to each part image in razuna so that the label is the the part number (sku), as described in the magento add-in instructions…

For testing, I created a .net application where I am calling the searchassets api as follows:

http:///razuna/global/api2/search.cfc?method=searchassets&api_key=&searchfor=%28+labels:" + + “%20+WebImage%29”

I then set this up to run 10 different part numbers first sequentially where 1 is called waits for completion, then the next and so on. After that is completed I take the same 10 part numbers and call the same API with 10 concurrent threads so all are running at the same time.

I then repeat this ten times for each test so we can get good metrics.

The results of test #1 (where each number is the total time in seconds, hundreds of seconds) :

Sequential Threaded


00:07:16 00:06:201
00:05:951 00:05:988
00:06:834 00:06:99
00:06:699 00:06:159
00:06:606 00:06:149
00:06:890 00:06:194
00:06:983 00:05:948
00:06:713 00:03:435
00:06:496 00:06:213
00:06:549 00:05:852

The results of test #2:

Sequential Threaded


00:06:736 00:05:711
00:06:645 00:06:81
00:06:850 00:05:941
00:06:619 00:06:367
00:06:711 00:06:139
00:06:800 00:06:338
00:06:699 00:06:119
00:06:700 00:06:273
00:07:75 00:06:159
00:06:660 00:06:329

Typically when I thread I see a time slightly larger than the longest duration individual item; but here it appears that something in Razuna is blocking the searchassets requests from running simultaneously.

Any ideas as to what that could be?

Thanks,

Jim

Thank you for your reports.

As Razuna is an open source application the source code is freely available for anyone to see and improve upon. The source code is available over at https://github.com/razuna/razuna. You are free to fork the code, change it and issue a pull request.

Since I have never developed a cold fusion application before, do you have any hints as to what could be causing / where this issue could be located within the Razuna system:

1.) Configs for Tomcat?
2.) Configs for Cold Fusion?
3.) Programming within the search function itself?
4.) Other?

Just really strange that the concurrent searches are working that way.

Aren’t other people who are using the Magento add-in saying anything about the performance of it as it renders the category listing pages?

Thanks,

Jim

As mentioned, it all boils down to tuning.

  • Did you follow the guidelines as mention in Magento Plug in Performance Tuning ?
  • Did you tune your Linux machine for better networking?
  • Where is your Magento server located?

Mu suspicion is that Tomcat is not configured properly. Java tuning is an art in itself and takes time and efforts. We can only offer so much as pointing you to the available documentation on the web without a support plan subscription.