Profile: untiedshoes

Hi Boyko, and thanks for the reply :)

After more testing this morning, I completely uninstalled the plugin, ran some more tests, then re-installed it.

Performance is much much better than it was now for some reason? Still a reduction in performance, but much better than it was!

By the way, single slide, homepage only - Empty page, with just 6 products. The slide is a simple slide, with desktop and mobile images, no conditions, and using homepage_top, limited to store1 (two stores being used on the dev).

Test graphs below (150 clients per second, 1 minute).

Empty homepage:


Empty homepage with single slide:


The same test yesterday, prior to uninstalling and reinstalling?!


Just to note, this is an upgrade from 4.30, not a clean install. The plugins will have been migrated (upgraded) when the store got upgraded to 4.40 - obviously, uploaded all the new 4.40 plugins :)

I've got the clients login details, so I'll do some more tests, and create a ticket if required :)

Thanks,
Craig

Here's a couple of graphs that didn't get added?

Nop Anywhere Sliders Enabled:
(150 clients per second, 1 minute)


Nop Anywhere Sliders Disabled:
(150 clients per second, 1 minute)

Also, I can't create a ticket, as the license isn't in my name.

Not sure why, but a lot of this has been cut off??

Hi Boyko,

You may know me from the forum, and of course, GitHub, as we've had issues with one of our clients, and performance under high loads.

We're currently running, a 4.40.3 site, but with various bits (AutoFac for instance), rolled back to 4.40.1. Autofac caused performance of 4.40.3 to plummet!

We're having some rather large performance issues (still!!) under high concurrent loads, and I've spent hours and hours on this issue over the years.

Anyway, yesterday and today, I decided to start looking at plugins, and it seems that we have an issue with the Anywhere Sliders under load.

Below are some load tests (not sure if these tables will render?).


Nop Anywhere Sliders Enabled:
(150 clients per second, 1 minute)

<table role="table">
<thead>
<tr>
<th>avg(ms)</th>
<th>min(ms)</th>
<th>max(ms)</th>
<th>success</th>
<th>timeout</th>
</tr>
</thead>
<tbody>
<tr>
<td>9556</td>
<td>144</td>
<td>30226</td>
<td>748</td>
<td>299</td>
</tr>
<tr>
<td>3036</td>
<td>151</td>
<td>14358</td>
<td>4661</td>
<td>0</td>
</tr>
<tr>
<td>6528</td>
<td>156</td>
<td>30214</td>
<td>2209</td>
<td>0</td>
</tr>
<tr>
<td>4650</td>
<td>155</td>
<td>27620</td>
<td>3333</td>
<td>0</td>
</tr>
</tbody>
</table>

Nop Anywhere Sliders Disabled:
(150 clients per second, 1 minute)
<table role="table">
<thead>
<tr>
<th>avg(ms)</th>
<th>min(ms)</th>
<th>max(ms)</th>
<th>success</th>
<th>timeout</th>
</tr>
</thead>
<tbody>
<tr>
<td>152</td>
<td>103</td>
<td>1095</td>
<td>8977</td>
<td>0</td>
</tr>
<tr>
<td>151</td>
<td>104</td>
<td>1084</td>
<td>8993</td>
<td>0</td>
</tr>
<tr>
<td>161</td>
<td>105</td>
<td>994</td>
<td>8843</td>
<td>0</td>
</tr>
<tr>
<td>164</td>
<td>106</td>
<td>1103</td>
<td>8999</td>
<td>0</td>
</tr>
</tbody>
</table>

Nop Anywhere Sliders Enabled:
(100 clients per second, 1 minute)
<table role="table">
<thead>
<tr>
<th>avg(ms)</th>
<th>min(ms)</th>
<th>max(ms)</th>
<th>success</th>
<th>timeout</th>
</tr>
</thead>
<tbody>
<tr>
<td>160</td>
<td>112</td>
<td>1011</td>
<td>6000</td>
<td>0</td>
</tr>
<tr>
<td>156</td>
<td>115</td>
<td>796</td>
<td>5887</td>
<td>0</td>
</tr>
<tr>
<td>159</td>
<td>113</td>
<td>817</td>
<td>5995</td>
<td>0</td>
</tr>
<tr>
<td>160</td>
<td>113</td>
<td>1129</td>
<td>5919</td>
<td>0</td>
</tr>
</tbody>
</table>

Nop Anywhere Sliders Disabled:
(100 clients per second, 1 minute)
<table role="table">
<thead>
<tr>
<th>avg(ms)</th>
<th>min(ms)</th>
<th>max(ms)</th>
<th>success</th>
<th>timeout</th>
</tr>
</thead>
<tbody>
<tr>
<td>131</td>
<td>104</td>
<td>607</td>
<td>6000</td>
<td>0</td>
</tr>
<tr>
<td>156</td>
<td>115</td>
<td>796</td>
<td>5887</td>
<td>0</td>
</tr>
<tr>
<td>136</td>
<td>104</td>
<td>818</td>
<td>5998</td>
<td>0</td>
</tr>
<tr>
<td>134</td>
<td>104</td>
<td>1381</td>
<td>5919</td>
<td>0</td>
</tr>
</tbody>
</table>

Nop Anywhere Sliders Enabled:
(0 - 500 (maintain client load), 1 minute)
<thead>
<tr>
<th>avg(ms)</th>
<th>min(ms)</th>
<th>max(ms)</th>
<th>success</th>
<th>timeout</th>
</tr>
</thead>
<tbody>
<tr>
<td>1582</td>
<td>101</td>
<td>15385</td>
<td>8179</td>
<td>0</td>
</tr>
<tr>
<td>1591</td>
<td>101</td>
<td>14519</td>
<td>8495</td>
<td>0</td>
</tr>
<tr>
<td>1628</td>
<td>102</td>
<td>30218</td>
<td>8446</td>
<td>1</td>
</tr>
<tr>
<td>1581</td>
<td>101</td>
<td>17597</td>
<td>8332</td>
<td>0</td>
</tr>
</tbody>
</table>

Nop Anywhere Sliders Disabled:
(0 - 500 (maintain client load), 1 minute)
<table role="table">
<thead>
<tr>
<th>avg(ms)</th>
<th>min(ms)</th>
<th>max(ms)</th>
<th>success</th>
<th>timeout</th>
</tr>
</thead>
<tbody>
<tr>
<td>1524</td>
<td>102</td>
<td>9204</td>
<td>9059</td>
<td>0</td>
</tr>
<tr>
<td>1587</td>
<td>99</td>
<td>9888</td>
<td>8865</td>
<td>0</td>
</tr>
<tr>
<td>1

Creating a new slide (image) using nop 4.40.2, does not upload the image to the Azure blob storage when using Anywhere Sliders (Version: 4.40).

This works as expected with 4.30.

Not sure if this is a nop issue, or a nopTemplates issue?

Regards,
Craig

Ignore - tried to delete, but failed.

Hi,

I'm trying to add a specific html widget for all products within a specific Manufacturer, but I can't get the conditions to work?

For instance, this is what I've got..

Active - True
Default State - Fail

Condition:
Manufacturer > Name > Equal To > Daily Sports.

Doing this shows the widget on all products, not just Daily Sports products?

Any ideas?

p.s. Using nopCommerce 3.90

EDIT - Never mind, I've fixed it!

Hi Again,

I didn't no... only ran the one script that came with the ultimate bundle.

Restored the DB, then ran the '7Spikes_upgrades' in order and seems to fine now thanks.

I also get an error when trying to view the sliders in the admin!

System.Data.Entity.Core.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Invalid object name 'dbo.SS_AS_AnywhereSlider'. at 

By the way, the client has purchased the full ultimate bundle!!

I've upgraded a site from 3.00 to 3.70 and everything has been fine so far. I've upgraded the plugins (Replaced all the plugin folders with the 3.70 versions), and ran the upgrade script, but now getting an error!

Invalid object name 'dbo.SS_MAP_EntityWidgetMapping'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'dbo.SS_MAP_EntityWidgetMapping'.

Line 3:  @foreach (var widget in Model)
Line 4:  {
Line 5:      @Html.Action(widget.ActionName, widget.ControllerName, widget.RouteValues)
Line 6:  }

Source File: c:\inetpub\wwwroot\Avec - ProClubs 2016\Views\Widget\WidgetsByZone.cshtml    Line: 5 

Stack Trace:
[code][SqlException (0x80131904): Invalid object name 'dbo.SS_MAP_EntityWidgetMapping'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +1787814
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +5341674
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +546
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +1693
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +61
   System.Data.SqlClient.SqlDataReader.get_MetaData() +90
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +377
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) +1421
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +177
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +53
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +137
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +41
   System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +10
   System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.<Reader>b__c(DbCommand t, DbCommandInterceptionContext`1 c) +9
   System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch(TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed) +72
   System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext) +355
   System.Data.Entity.Internal.InterceptableDbCommand.ExecuteDbDataReader(CommandBehavior behavior) +166
   System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +10
   System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) +37




[EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details.]
   System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) +112
   System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute(ObjectContext context, ObjectParameterCollection parameterValues) +743
   System.D