Intersoft Community - WebCombo - The Search Product in the Web Combo very slow,

The Search Product in the Web Combo very slow,

Hans — Tue, 18 Feb 2014 05:52:48 GMT

Hello,

Thank you for the reply & video.

I made a SQL database, that similar with the SortingCode access database, with one table within.
Then I made another WebCombo sample. I bind the WebCombo to SQL data source (with table that I have made).

While I’m running, I try to trace the queries that happen in my SQL server using SQL Server Profiler.
The result is every query (process) that happens in my SQL server always takes time less than one second.
I get the same result when I try to see the HttpRequest profiler from browser.

Please kindly try to investigate your current Store Procedure / SQL query; perhaps there is some improvement to make the query faster.

Please kindly have review on the video as well, you could the video from this link below:
http://sdrv.ms/1lGhsU7

Regards,
Hans K.

The Search Product in the Web Combo very slow,

armore1972 — Fri, 14 Feb 2014 03:49:16 GMT

Hi Hans,
i have put the video in your sharing area.
You can see that everytime i enter a char in the combo a HttpRequest was open (with related call procedure of search product) but if i try to insert quickly some chars more HttpRequests are opening and after was closing one by one and i need to wait that are closing all to have a result.
Very thanks
Regards
armore1972

The Search Product in the Web Combo very slow,

Hans — Wed, 12 Feb 2014 23:39:32 GMT

Hello,

Thank you for the reply.

Thank you for the video, but unfortunately I can’t open the video properly. Here’s what I get while I’m trying to open the video file: TeamViewerIssue.png.
I am sorry, if you don’t mind, please kindly try to upload the .tvs file to another server upload, and then provide me the download link. Or provide me another video format.

Since I can’t run your page, due to don’t have your database, I made simple table use access and WebCombo page that perhaps similar with yours.
I bind the WebCombo to access data source.
However, the WebCombo works fine on my end.

I attached my WebCombo page and the video about the result that I get on my end.
If you couldn’t get the attachment file properly, please try to follow this link below:
http://sdrv.ms/1lGhsU7

Please let me know if there is missing configuration & step while trying to attempt your issue.

Regards,
Hans K.

The Search Product in the Web Combo very slow,

armore1972 — Tue, 11 Feb 2014 12:31:56 GMT

I try to capture the video with issue that we have. Sorry but only with TeamViewer.
Every time i enter a value a Http Session with Calling procedure was started, but if i enter other values, other sessions are opening, and the other that are open are stopped ( by ther search process still running), this behaviour slowing the system.
This is Team Viewer File that i rename like JPEG to attach. You must remove .JPEG extension to see.

Very Thanks

The Search Product in the Web Combo very slow,

armore1972 — Tue, 11 Feb 2014 08:17:15 GMT

Very thanks for your answer, but seems that we use this properties.
We use this properties in this way:
The Webcombo has define the method WebComboProd_InitializeDataSource

<ISWebCombo:WebCombo ID="WebComboProd" runat="server" AdditionalSearchFields="ProductName, Speedy_CustProdRefDescription"

DataTextField="ProductNumber"

DataValueField="ProductId"MinCharsToRequest="2"Height="20px"

UseDefaultStyle="True"OnInitializeRow="WebComboProd_InitializeRow"

Width="550px"Latency="200"

OnInitializeDataSource="WebComboProd_InitializeDataSource"

OnInitializeLayout="WebComboProd_InitializeLayout" AllowWildCardSearch="True"

DropDownRows="7" >

....

In the code C# the WebComboProd_InitializeDataSource is defined

protected void WebComboProd_InitializeDataSource(object sender, ISNet.WebUI.WebCombo.DataSourceEventArgs e)

{

string appleOrderTypeBehaviour = HiddenApplyOrderTypeBehaviour.Value;

if (!HiddenEntityType.Value.Equals("salesorder"))

{

appleOrderTypeBehaviour = "false";

}

if (HiddenCustomizedDataSource.Value == "true")

{

DataSet1TableAdapters.pGetproductreferenceTableAdapter prods = new pGetproductreferenceTableAdapter();

orderId = Request.QueryString["id"];

orgname = Request.QueryString["orgname"];

//Request.QueryString["userId"]);

DataSet ds = newDataSet();

string queryText = "";

if (!e.IsFlyDataRequest)

{

if (WebComboProd.Value != "" && WebComboProd.Value != null && WebComboProd.Value != " ")

{

ds.Tables.Add(prods.GetDataById(Request.QueryString["customerid"], Request.QueryString["userlcid"], Request.QueryString["orglcid"], HiddenApplyProductDist.Value, Request.QueryString["userId"], HiddenEnableProdRef.Value, WebComboProd.Value));

e.DataSource = ds;

}

else

{

int rowCount = e.RowCount;

if (e.StartRow != 0)

{

rowCount = e.RowCount / 2;

}

int TopRows = e.StartRow + rowCount;

queryText = e.QueryText.Replace("*", "%");

if (!e.QueryText.Contains("*"))

queryText = queryText + "%";

string connectionString = Wuerth.Phoenix.Speedy.PriceSearchPlugin.Properties.Settings.Default.Speedy_ConnectionString;

using (SqlConnection conn = new SqlConnection(connectionString))

{

conn.Open();

using (SqlCommand storedProcCommand = new SqlCommand("p_GetproductreferenceQueryTxt", conn))

{

storedProcCommand.CommandType = CommandType.StoredProcedure;

storedProcCommand.Parameters.AddWithValue("@accountID", Request.QueryString["customerid"]);

storedProcCommand.Parameters.AddWithValue("@languageID", Request.QueryString["userlcid"]);

storedProcCommand.Parameters.AddWithValue("@languageIDOrg", Request.QueryString["orglcid"]);

storedProcCommand.Parameters.AddWithValue("@applyProductDist", HiddenApplyProductDist.Value);

storedProcCommand.Parameters.AddWithValue("@userID", Request.QueryString["userId"]);

storedProcCommand.Parameters.AddWithValue("@enableProdRef", HiddenEnableProdRef.Value);

storedProcCommand.Parameters.AddWithValue("@queryTxt", queryText);

storedProcCommand.Parameters.AddWithValue("@numRowsToGet", TopRows);

storedProcCommand.Parameters.AddWithValue("@applyBehaviour", appleOrderTypeBehaviour);

storedProcCommand.Parameters.AddWithValue("@orderType", orderType);

SqlDataAdapter adapter = new SqlDataAdapter(storedProcCommand);

adapter.Fill(ds, e.StartRow, rowCount, "pGetproductreference");

e.DataSource = ds;

}

WebComboProd.SkipRowParsing = true;

using (SqlCommand storedProcCommand = new SqlCommand("p_GetproductreferenceQueryTxtCount", conn))