After the last couple patches to Telerik, the legend item click event for the RadHtmlChart is running very slow. I am using asp.net. It is slow for the built in click for one chart with no javascript or server code for it. It is also very slow, and often times out, when capturing OnLegendItemClick event for one of seven charts to set the legend on the other charts to have the same visibility properties. Is there a way to speed this up?
Here is my javascript for the OnLegendItemClick event.
function OnLegendItemClick(args) {
// hiddenchartClicked prevents any possible looping of click events
// args.preventDefault fixes the problem of the currently clicked item not becoming visible again
// It was making all other charts visible except the clicked one,
// so I set all charts and stopped it from toggling.
if ($('#hiddenchartClicked').val() != "")
return;
var seriesName = args.text;
var visibility = !args.series.visible;
var seriesIndex = args.seriesIndex;
var seriesChart = args.sender.element[0].id
$('#hiddenchartClicked').val(seriesChart);
args.preventDefault();
for (var i = 0; i < 7 ; i++) {
var chartID = "RadDemandChart" + i.toString();
var chart = $find(chartID);
chart._chartObject.options.series[seriesIndex].visible = visibility;
chart.repaint();
}
$('#hiddenchartClicked').val("");
}
Thank you so much.
12 Answers, 1 is accepted
Could you please attach whole page where this can be tested. I will profile it and tell you what is happening and how to optimize it.
Regards,
Vasil
Telerik
Rank 1
I had to gut most of it out because it won't let me attach the files and it cut off my pasted code.
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="CPAReports.aspx.cs" Inherits="CPAReports.CPAReports" %>
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<%@ Register Assembly="Telerik.Web.UI.Skins" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<!DOCTYPE html>
<html lang="en" class="no-js">
<head id="Head1" runat="server">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" />
<meta charset="UTF-8" />
<title>OPAP | 7 Day Reports</title>
<link rel="stylesheet" href="css/style.default.css" type="text/css" />
<link rel="stylesheet" href="css/Custom_Metro/Grid.Custom_Metro.css">
<script type="text/javascript" src="js/jquery-1.10.1.min.js"></script>
<script type="text/javascript" src="js/jquery-migrate-1.1.1.min.js"></script>
<script type="text/javascript" src="js/jquery-ui-1.9.2.min.js"></script>
<script type="text/javascript" src="js/jquery.uniform.min.js"></script>
<script type="text/javascript" src="js/chosen.jquery.min.js"></script>
<script type="text/javascript" src="js/custom.js"></script>
<script type="text/javascript">
function OnLegendItemClick(args) {
// hiddenchartClicked prevents any possible looping of click events
// args.preventDefault fixes the problem of the currently clicked item not becoming visible again
// It was making all other charts visible except the clicked one,
// so I set all charts and stopped it from toggling.
if ($('#hiddenchartClicked').val() != "")
return;
var seriesName = args.text;
var visibility = !args.series.visible;
var seriesIndex = args.seriesIndex;
var seriesChart = args.sender.element[0].id
$('#hiddenchartClicked').val(seriesChart);
//args.preventDefault();
for (var i = 0; i < 7 ; i++) {
var chartID = "RadDemandChart" + i.toString();
if (chartID != seriesChart) {
var chart = $find(chartID);
chart._chartObject.options.series[seriesIndex].visible = visibility;
chart.repaint();
}
}
$('#hiddenchartClicked').val("");
}
</script>
</head>
<body>
<div class="mainwrapper">
<form class="block-content form" id="table_form" runat="server" enableviewstate="true">
<asp:ScriptManager ID="scriptManager" runat="server" />
<div
<asp:UpdatePanel ID="updatePanelMain" UpdateMode="Conditional" runat="server">
<ContentTemplate>
<asp:HiddenField ID="hiddenchartClicked" runat="server" />
<div class="chart">
<telerik:RadHtmlChart ID="RadDemandChart0" Visible="true" runat="server" Skin="Metro" Width="1000"
RegisterWithScriptManager="true" ChartTitle-Appearance-TextStyle-FontSize="12px"
Legend-Appearance-Position="Bottom" Transitions="false" >
<ClientEvents OnLegendItemClick="OnLegendItemClick" ></ClientEvents>
<PlotArea>
<XAxis MajorTickType="None" MinorTickType="None">
<MinorGridLines Visible="false" />
<MajorGridLines Visible="false" />
<TitleAppearance Text="Time" Visible="false" />
<LabelsAppearance RotationAngle="-90" />
</XAxis>
<YAxis>
<MinorGridLines Visible="false" />
<MajorGridLines Visible="true" />
<TitleAppearance Text=" " />
</YAxis>
</PlotArea>
</telerik:RadHtmlChart>
</div>
</ContentTemplate>
</asp:UpdatePanel>
</div>
COPY ABOVE CODE TO MAKE 6 MORE OF THESE RADHTMLCHARTs.
</form>
</div><!--mainwrapper-->
</body>
</html>
Code behind:
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Drawing.Printing;
using System.Linq;
using System.Threading.Tasks;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Telerik.Web.UI;
namespace CPAReports
{
public partial class CPAReports : System.Web.UI.Page
{
/// <summary>
/// Holds demand chart data for a week of demand data.
/// </summary>
private List<DataSet> multipleReports = new List<DataSet>();
protected void Page_Load(object sender, EventArgs e)
{
CreateChartSeries();
BuildChart();
updatePanelMain.Update();
}
/// <summary>
/// Creates the chart series for the Demand Chart for each of
/// the seven days of demand data.
/// </summary>
private void CreateChartSeries()
{
RadHtmlChart[] radChartArray = new RadHtmlChart[] { RadDemandChart0, RadDemandChart1,
RadDemandChart2, RadDemandChart3, RadDemandChart4, RadDemandChart5, RadDemandChart6 };
foreach (RadHtmlChart demandChart in radChartArray)
{
demandChart.PlotArea.Series.Clear();
AreaSeries Actual_Unit_Hours = new AreaSeries();
Actual_Unit_Hours.DataFieldY = "Actual_Unit_Hours";
Actual_Unit_Hours.LabelsAppearance.Visible = false;
Actual_Unit_Hours.TooltipsAppearance.Visible = false;
Actual_Unit_Hours.Appearance.FillStyle.BackgroundColor
= System.Drawing.ColorTranslator.FromHtml("#aaccee");
Actual_Unit_Hours.MarkersAppearance.Visible = false;
Actual_Unit_Hours.Appearance.Overlay.Gradient = Telerik.Web.UI.HtmlChart.Enums.Gradients.None;
demandChart.PlotArea.Series.Add(Actual_Unit_Hours);
AreaSeries Scheduled_Unit_Hours = new AreaSeries();
Scheduled_Unit_Hours.DataFieldY = "Scheduled_Unit_Hours";
Scheduled_Unit_Hours.Name = "Scheduled UHs";
Scheduled_Unit_Hours.TooltipsAppearance.Visible = false;
Scheduled_Unit_Hours.LabelsAppearance.Visible = false;
Scheduled_Unit_Hours.MarkersAppearance.Visible = false;
Scheduled_Unit_Hours.Appearance.FillStyle.BackgroundColor
= System.Drawing.ColorTranslator.FromHtml("#bbbbbb");
Scheduled_Unit_Hours.Appearance.Overlay.Gradient = Telerik.Web.UI.HtmlChart.Enums.Gradients.None;
demandChart.PlotArea.Series.Add(Scheduled_Unit_Hours);
LineSeries New_Schedule = new LineSeries();
New_Schedule.LineAppearance.Width = 3;
New_Schedule.DataFieldY = "Schedule_NOT_Effective";
New_Schedule.Name = "New Schedule";
New_Schedule.TooltipsAppearance.Visible = false;
New_Schedule.LabelsAppearance.Visible = false;
New_Schedule.MarkersAppearance.Visible = false;
New_Schedule.Appearance.FillStyle.BackgroundColor
= System.Drawing.Color.DarkBlue;
New_Schedule.Appearance.Overlay.Gradient = Telerik.Web.UI.HtmlChart.Enums.Gradients.None;
demandChart.PlotArea.Series.Add(New_Schedule);
LineSeries Chart_Peak = new LineSeries();
Chart_Peak.Name = "Chart Peak";
Chart_Peak.DataFieldY = "Chart_Peak";
Chart_Peak.LabelsAppearance.Visible = false;
Chart_Peak.MarkersAppearance.Visible = false;
Chart_Peak.TooltipsAppearance.Visible = false;
Chart_Peak.MissingValues = Telerik.Web.UI.HtmlChart.MissingValuesBehavior.Gap;
Chart_Peak.Appearance.FillStyle.BackgroundColor = System.Drawing.Color.OrangeRed;
Chart_Peak.Appearance.Overlay.Gradient = Telerik.Web.UI.HtmlChart.Enums.Gradients.None;
demandChart.PlotArea.Series.Add(Chart_Peak);
LineSeries Area_Demand = new LineSeries();
Area_Demand.Name = "Demand Area";
Area_Demand.DataFieldY = "Area_Demand";
Area_Demand.LabelsAppearance.Visible = false;
Area_Demand.MarkersAppearance.Visible = false;
Area_Demand.TooltipsAppearance.Visible = false;
Area_Demand.Appearance.FillStyle.BackgroundColor = System.Drawing.Color.Aqua;
//Area_Demand.ZIndex = 1;
Area_Demand.MissingValues = Telerik.Web.UI.HtmlChart.MissingValuesBehavior.Gap;
Area_Demand.Appearance.Overlay.Gradient = Telerik.Web.UI.HtmlChart.Enums.Gradients.None;
demandChart.PlotArea.Series.Add(Area_Demand);
LineSeries Efficiency_Target = new LineSeries();
Efficiency_Target.Name = "Demand Entity";
Efficiency_Target.DataFieldY = "Entity_Demand";
Efficiency_Target.LabelsAppearance.Visible = false;
Efficiency_Target.MarkersAppearance.Visible = false;
Efficiency_Target.TooltipsAppearance.Visible = false;
Efficiency_Target.Appearance.FillStyle.BackgroundColor = System.Drawing.Color.Green;
//Efficiency_Target.ZIndex = 2;
Efficiency_Target.MissingValues = Telerik.Web.UI.HtmlChart.MissingValuesBehavior.Gap;
Efficiency_Target.Appearance.Overlay.Gradient = Telerik.Web.UI.HtmlChart.Enums.Gradients.None;
demandChart.PlotArea.Series.Add(Efficiency_Target);
LineSeries q5_Tight = new LineSeries();
q5_Tight.LineAppearance.Width = 1;
q5_Tight.Name = "Target Staffing";
q5_Tight.DataFieldY = "q5_Tight";
q5_Tight.MarkersAppearance.Visible = false;
q5_Tight.LabelsAppearance.Visible = false;
q5_Tight.TooltipsAppearance.Visible = false;
q5_Tight.Appearance.FillStyle.BackgroundColor = System.Drawing.Color.Purple;
q5_Tight.MissingValues = Telerik.Web.UI.HtmlChart.MissingValuesBehavior.Gap;
q5_Tight.Appearance.Overlay.Gradient = Telerik.Web.UI.HtmlChart.Enums.Gradients.None;
demandChart.PlotArea.Series.Add(q5_Tight);
DateTime timeLabels = new DateTime();
List<AxisItem> axisItems = new List<AxisItem>();
List<AxisItem> blankAxisItems = new List<AxisItem>() { { new AxisItem("") },
{ new AxisItem("") }, { new AxisItem("") },
{ new AxisItem("") }, { new AxisItem("") } };
for (int index = 0; index < 48; index++)
{
axisItems.Add(new AxisItem(timeLabels.ToString("HH:mm")));
axisItems.AddRange(blankAxisItems);
timeLabels = timeLabels.AddMinutes(30);
}
demandChart.PlotArea.XAxis.Items.AddRange(axisItems);
}
}
/// <summary>
/// Builds the chart and chart labels for seven days of
/// demand data.
/// </summary>
private void BuildChart()
{
RadHtmlChart[] radChartArray = new RadHtmlChart[] { RadDemandChart0, RadDemandChart1,
RadDemandChart2, RadDemandChart3, RadDemandChart4, RadDemandChart5, RadDemandChart6 };
DateTime requestedDate = DateTime.Today;
// Order by day of week starting with Sunday, even if the dates are out of order
DateTime[] dates = { requestedDate.AddDays(-6), requestedDate.AddDays(-5), requestedDate.AddDays(-4), requestedDate.AddDays(-3), requestedDate.AddDays(-2), requestedDate.AddDays(-1), requestedDate };
foreach (DateTime date in dates)
multipleReports.Add(GetChartData(date.ToString(), null));
int currentChart = 0;
double scheduledUHsTotal = 0;
double AUHTotal = 0;
double actualHoursTotal = 0;
double newSchedUHsTotal = 0;
double targetUHMaxEntityTotal = 0;
double targetUHMaxAreaTotal = 0;
double activeHoursTotal = 0;
foreach (DataSet ChartData in multipleReports)
{
DataTable dtData = ChartData.Tables[0];
string actual_UH_Weeks = !string.IsNullOrWhiteSpace(labelData.Rows[0]["Sys_Actual_UH_Weeks"].ToString())
? string.Format(" (x{0} weeks)", labelData.Rows[0]["Sys_Actual_UH_Weeks"]) : string.Empty;
radChartArray[currentChart].PlotArea.Series[0].Name = "Actual UHs";
if (radChartArray[currentChart].PlotArea.Series.Count == 7)
{
LineSeries Active_Calls = new LineSeries();
Active_Calls.DataFieldY = "Active_Calls";
Active_Calls.LabelsAppearance.Visible = false;
Active_Calls.TooltipsAppearance.Visible = false;
Active_Calls.MissingValues = Telerik.Web.UI.HtmlChart.MissingValuesBehavior.Gap;
Active_Calls.Name = "Active Calls";
Active_Calls.MarkersAppearance.Visible = false;
//Active_Calls.MarkersAppearance.MarkersType = Telerik.Web.UI.HtmlChart.MarkersType.Circle;
Active_Calls.Appearance.FillStyle.BackgroundColor = System.Drawing.Color.Red;
//Active_Calls.MarkersAppearance.Size = 3;
//Active_Calls.MarkersAppearance.BorderWidth = 1;
//Active_Calls.MarkersAppearance.Visible = true;
//Active_Calls.MarkersAppearance.BackgroundColor = System.Drawing.Color.Transparent;
radChartArray[currentChart].PlotArea.Series.Insert(3, Active_Calls);
}
LineSeries LDT = new LineSeries();
LDT.LineAppearance.Width = 3;
LDT.Name = "LDT";
LDT.DataFieldY = "LDT_Demand";
LDT.TooltipsAppearance.Visible = false;
LDT.LabelsAppearance.Visible = false;
LDT.MarkersAppearance.Visible = false;
LDT.Appearance.FillStyle.BackgroundColor = System.Drawing.Color.Orange;
DateTime date = dates[currentChart];
string currentDate = date.ToString("MM/dd/yyyy");
radChartArray[currentChart].ChartTitle.Text = string.Format("Date: {0} - {1}", currentDate, date.DayOfWeek.ToString());
radChartArray[currentChart].DataSource = dtData;
radChartArray[currentChart].DataBind();
currentChart++;
}
}
private DataSet GetChartData(string inputDate = null, string inputDOW = null)
{
DataSet results = new DataSet();
//Get the chart data here
return results;
}
}
}
I see that you add additional 240 empty x-axis items in addition to the displayed 48 x-axis items. I would suggest that you remove these 240 empty x-axis items, which optimizes the performance of the chart on my side:
for (int index = 0; index < 48; index++){ axisItems.Add(new AxisItem(timeLabels.ToString("HH:mm"))); //axisItems.AddRange(blankAxisItems); timeLabels = timeLabels.AddMinutes(30);}Regards,
Danail Vasilev
Telerik
Rank 1
I was wondering how can I get RadHTMLChart legends. I am looking for following additions to legends:
1) Legend Icons are available only in square shape. How can I change legend shape to match with series marker shape i.e, circle, triangle.
2) Very limited marker shapes are available for use. Only circle, triangle, square are allowed as of now. Are you planning to add more marker shapes?
3) And also, it would be more meaningful to align legend shape with the chart series type i.e, line, column, bubble, etc.,.
Please let me know if above requests are already addressed in your latest releases or planned for future release.
Thank you!
Rank 1
Thank you for your reply, Danail. However, those blank axis items are required. We have labels every 30 minutes, but require data points to be plotted for every 5 minutes. It would be illegible if we had labels every 5 minutes. So this does not help because we are using all those blank axis to plot data.
This used to happen in 2 or 3 seconds. Then your last upgrade caused it take almost 2 minutes now. You changed something in your latest upgrade that seriously degraded performance. If I wasn't using the spreadsheet functionality, I would revert back to the prior release.
In addition, if I step through debug, the repaint function takes forever and returns an invalid object message. I am not sure if this is because we can't step into Telerik code or if the repaint is returning an error. I will try to package some test data and send to you so you can see better what is happening.
Rank 1
Use this data for all 7 datasources.
TimeSlot,Scheduled_Unit_Hours, Schedule_NOT_Effective, Actual_Unit_Hours, Active_Calls, Entity_Demand, Area_Demand, Chart_Peak, q5_Tight, LDT_Demand
00:00:00,4,0,5.00,4,4.04,4.00,8.00,5.0000,0.00
00:05:00,4,0,4.00,3,4.00,4.00,7.00,5.0000,0.00
00:10:00,4,3,4.00,3,4.00,4.00,7.00,5.0000,0.00
00:15:00,4,3,4.00,3,4.00,4.00,7.00,5.0000,0.00
00:20:00,4,3,4.00,3,5.00,4.00,6.00,5.0000,0.00
00:25:00,4,3,4.00,3,4.34,4.00,6.00,5.0000,0.00
00:30:00,4,3,4.00,2,4.00,4.00,5.00,5.0000,0.00
00:35:00,4,3,4.00,2,4.00,4.00,5.00,5.0000,0.00
00:40:00,4,3,4.00,2,4.34,4.00,5.00,5.0000,0.00
00:45:00,4,1,4.00,2,5.00,4.00,5.00,5.0000,0.00
00:50:00,4,1,4.00,1,5.00,3.00,5.00,5.0000,0.00
00:55:00,4,1,4.00,1,4.00,3.00,5.00,5.0000,0.66
01:00:00,4,1,4.00,0,4.00,3.00,5.00,4.0000,0.51
01:05:00,4,1,4.00,1,4.00,3.00,4.00,4.0000,0.66
01:10:00,4,1,4.00,1,3.34,3.00,4.00,4.0000,0.34
01:15:00,4,1,4.00,1,3.34,3.00,4.00,4.0000,0.34
01:20:00,4,1,4.00,1,3.00,3.00,3.00,4.0000,0.00
01:25:00,4,1,4.00,1,3.49,3.34,4.00,4.0000,0.49
01:30:00,4,1,4.00,1,3.64,4.00,5.00,4.0000,0.64
01:35:00,4,1,4.00,1,3.00,3.00,5.00,4.0000,0.00
01:40:00,4,1,4.00,1,3.00,3.00,5.00,4.0000,0.00
01:45:00,4,1,4.00,0,3.00,3.00,5.00,4.0000,0.51
01:50:00,4,1,4.00,0,3.00,2.34,3.00,4.0000,0.00
01:55:00,4,1,4.00,0,3.94,3.00,5.00,4.0000,0.94
02:00:00,4,1,4.00,0,3.00,3.00,5.00,4.0000,0.00
02:05:00,4,1,4.00,0,3.00,4.00,5.00,4.0000,0.00
02:10:00,4,1,4.00,0,3.00,4.00,5.00,4.0000,0.00
02:15:00,4,1,4.00,0,3.00,3.00,5.00,4.0000,0.00
02:20:00,4,1,4.00,0,3.00,3.00,5.00,4.0000,0.06
02:25:00,4,1,4.00,0,3.00,3.49,5.00,4.0000,0.00
02:30:00,4,1,4.00,0,3.00,3.00,5.00,4.0000,0.06
02:35:00,4,1,4.00,0,3.00,3.00,4.00,4.0000,0.00
02:40:00,4,1,4.00,0,3.00,3.00,4.00,4.0000,0.00
02:45:00,3,1,4.00,0,3.00,3.00,4.00,4.0000,0.00
02:50:00,3,1,4.00,0,3.00,3.00,4.00,4.0000,0.66
02:55:00,3,1,3.00,0,3.00,2.00,4.00,4.0000,0.00
03:00:00,3,1,3.00,0,3.00,2.00,4.00,4.0000,0.00
03:05:00,3,1,3.00,0,3.00,2.00,3.00,4.0000,1.00
03:10:00,3,1,3.00,0,3.00,2.00,4.00,4.0000,1.00
03:15:00,3,1,3.00,0,3.34,2.00,4.00,4.0000,1.00
03:20:00,3,1,3.00,0,2.49,2.00,4.00,4.0000,0.49
03:25:00,3,1,3.00,0,2.49,3.00,5.00,4.0000,0.49
03:30:00,3,1,3.00,0,2.49,3.00,5.00,4.0000,0.49
03:35:00,3,1,3.00,1,2.49,3.00,5.00,4.0000,0.49
03:40:00,3,1,3.00,1,3.00,3.00,5.00,4.0000,1.00
03:45:00,3,1,3.00,1,3.00,3.00,5.00,4.0000,0.51
03:50:00,3,1,3.00,1,3.00,3.00,5.00,4.0000,0.00
03:55:00,3,1,3.00,1,3.49,2.00,4.00,4.0000,0.49
04:00:00,3,1,3.00,1,2.68,2.00,4.00,4.0000,0.34
04:05:00,3,1,3.00,1,2.34,2.00,4.00,4.0000,0.34
04:10:00,3,1,3.00,1,2.34,2.34,3.00,4.0000,0.34
04:15:00,3,1,3.00,1,2.34,2.34,3.00,4.0000,0.34
04:20:00,3,1,3.00,1,2.34,2.34,3.00,4.0000,0.34
04:25:00,3,1,3.00,0,2.34,2.34,3.00,4.0000,0.34
04:30:00,3,1,3.00,0,3.00,3.00,3.00,4.0000,0.66
04:35:00,3,1,3.00,0,2.94,2.94,3.00,4.0000,0.00
04:40:00,3,1,3.00,0,2.94,2.94,3.00,4.0000,0.00
04:45:00,2,1,3.00,0,3.00,3.00,3.00,4.0000,0.00
04:50:00,2,1,3.00,0,3.00,3.00,3.00,4.0000,0.00
04:55:00,2,1,3.00,0,2.34,3.00,3.00,4.0000,0.00
05:00:00,2,1,2.00,0,2.94,3.00,3.00,4.0000,0.00
05:05:00,2,1,2.00,0,3.00,3.00,3.00,4.0000,0.00
05:10:00,3,1,2.00,0,2.00,2.94,3.00,4.0000,0.00
05:15:00,3,1,3.00,0,2.00,2.94,4.00,4.0000,0.00
05:20:00,3,1,3.00,1,2.00,2.00,4.00,4.0000,0.00
05:25:00,3,1,3.00,1,3.00,2.94,3.00,4.0000,0.00
05:30:00,3,1,3.00,1,3.00,2.00,4.00,4.0000,0.00
05:35:00,3,1,3.00,1,3.00,2.00,3.00,4.0000,0.00
05:40:00,3,1,3.00,1,2.94,2.00,3.00,4.0000,0.00
05:45:00,2,1,3.00,1,2.00,2.00,3.00,4.0000,0.00
05:50:00,2,1,3.00,1,3.00,2.00,3.00,4.0000,0.66
05:55:00,2,1,3.00,1,3.00,2.00,3.00,4.0000,0.66
06:00:00,2,1,3.00,0,3.00,2.00,3.00,4.0000,0.66
06:05:00,2,1,2.00,0,3.00,2.00,3.00,4.0000,0.00
06:10:00,3,1,3.00,0,2.00,2.00,3.00,4.0000,0.00
06:15:00,3,1,3.00,0,2.00,2.00,3.00,4.0000,0.00
06:20:00,3,1,3.00,0,2.00,2.00,3.00,4.0000,0.00
06:25:00,3,1,3.00,0,2.00,2.00,3.00,4.0000,0.00
06:30:00,3,1,3.00,0,2.94,2.94,3.00,4.0000,0.00
06:35:00,3,1,3.00,0,2.95,2.94,3.00,4.0000,0.00
06:40:00,3,1,3.00,0,2.00,2.94,3.00,4.0000,0.00
06:45:00,2,1,3.00,0,2.00,2.94,3.00,4.0000,0.00
06:50:00,2,1,3.00,0,2.34,2.34,3.00,4.0000,0.34
06:55:00,2,1,2.00,0,2.00,2.34,3.00,4.0000,0.00
07:00:00,2,1,2.00,1,2.00,2.34,3.00,4.0000,0.00
07:05:00,2,1,3.00,2,3.00,3.34,3.00,4.0000,1.00
07:10:00,4,1,3.00,2,3.00,3.00,3.00,4.0000,0.00
07:15:00,4,1,2.00,3,3.00,3.00,3.00,4.0000,0.00
07:20:00,4,1,3.00,3,3.00,3.00,3.00,4.0000,0.00
07:25:00,4,1,3.00,3,3.49,4.00,5.00,4.0000,0.15
07:30:00,4,1,4.00,2,3.49,4.00,6.00,4.0000,0.00
07:35:00,4,1,4.00,2,3.49,3.49,5.00,4.0000,0.15
07:40:00,4,1,4.00,3,4.00,4.00,4.00,4.0000,0.66
07:45:00,4,1,4.00,3,3.00,3.34,4.00,4.0000,0.00
07:50:00,4,1,4.00,3,3.00,3.34,4.00,4.0000,0.00
07:55:00,4,1,4.00,3,3.00,3.00,3.00,4.0000,0.00
08:00:00,4,1,4.00,3,3.00,3.94,4.00,4.0000,0.00
08:05:00,4,1,4.00,3,3.94,3.94,4.00,4.0000,0.94
08:10:00,5,1,5.00,3,3.00,3.00,3.00,4.0000,0.00
08:15:00,5,1,5.00,3,3.00,3.34,4.00,4.0000,0.00
08:20:00,5,1,5.00,4,3.63,4.00,4.00,4.0000,0.63
08:25:00,5,1,5.00,3,3.63,4.00,5.00,4.0000,0.00
08:30:00,5,1,5.00,3,4.00,4.00,5.00,4.0000,0.00
08:35:00,5,1,5.00,3,3.34,4.00,4.00,4.0000,0.34
08:40:00,5,1,5.00,3,3.00,3.00,5.00,4.0000,0.00
08:45:00,5,1,5.00,5,3.00,3.00,5.00,4.0000,0.00
08:50:00,5,1,5.00,5,4.04,4.00,5.00,4.0000,0.04
08:55:00,5,1,5.00,4,4.00,4.00,4.00,4.0000,0.66
09:00:00,5,1,5.00,3,3.34,4.00,4.00,5.0000,0.34
09:05:00,5,1,5.00,3,4.00,4.00,5.00,5.0000,1.00
09:10:00,5,1,5.00,3,4.00,4.00,5.00,5.0000,1.00
09:15:00,5,1,5.00,2,4.00,4.00,5.00,5.0000,0.00
09:20:00,5,1,5.00,1,4.00,4.00,5.00,5.0000,0.00
09:25:00,5,1,5.00,1,4.00,4.63,6.00,5.0000,0.00
09:30:00,5,1,5.00,2,5.00,5.00,6.00,5.0000,0.37
09:35:00,5,1,5.00,3,5.00,6.00,5.00,5.0000,0.00
09:40:00,5,1,5.00,3,5.00,6.00,5.00,5.0000,0.00
09:45:00,5,1,5.00,3,5.00,5.00,5.00,5.0000,1.00
09:50:00,5,1,5.00,3,5.00,6.00,5.00,5.0000,0.00
09:55:00,5,1,5.00,3,4.00,5.00,6.00,5.0000,0.00
10:00:00,5,1,5.00,3,5.00,5.00,6.00,6.0000,0.00
10:05:00,5,1,5.00,3,5.00,5.34,6.00,6.0000,0.00
10:10:00,6,1,5.00,3,4.94,5.00,6.00,6.0000,0.94
10:15:00,6,1,5.00,3,5.95,5.94,7.00,6.0000,0.95
10:20:00,6,1,5.00,3,6.95,6.95,8.00,6.0000,0.95
10:25:00,6,1,5.00,3,5.00,5.49,7.00,6.0000,0.00
10:30:00,6,1,5.00,3,5.94,5.00,7.00,6.0000,0.94
10:35:00,6,1,5.00,3,6.95,6.95,7.00,6.0000,0.95
10:40:00,6,1,5.00,3,6.00,6.00,6.00,6.0000,0.66
10:45:00,6,1,5.00,1,5.34,6.00,7.00,6.0000,0.34
10:50:00,6,1,6.00,2,5.00,5.00,6.00,6.0000,0.00
10:55:00,6,1,6.00,0,5.00,5.00,6.00,6.0000,0.00
11:00:00,6,1,6.00,1,5.00,5.00,5.00,6.0000,1.00
11:05:00,6,1,6.00,1,5.00,5.34,6.00,6.0000,0.00
11:10:00,7,1,6.00,1,5.00,5.63,6.00,6.0000,0.00
11:15:00,7,1,6.00,1,5.00,6.00,6.00,6.0000,0.00
11:20:00,7,1,6.00,1,5.00,5.34,6.00,6.0000,0.37
11:25:00,7,1,6.00,1,5.00,5.00,5.00,6.0000,1.00
11:30:00,7,1,6.00,3,5.00,6.00,6.00,6.0000,0.00
11:35:00,7,1,6.00,2,5.00,5.63,8.00,6.0000,0.00
11:40:00,7,1,6.00,4,5.00,5.63,8.00,6.0000,0.00
11:45:00,7,1,6.00,4,5.00,5.63,7.00,6.0000,0.00
11:50:00,7,1,6.00,2,5.34,6.00,7.00,6.0000,0.00
11:55:00,7,1,6.00,2,5.34,6.00,6.00,6.0000,0.00
12:00:00,7,1,6.00,2,6.00,6.34,8.00,6.0000,0.00
12:05:00,7,1,6.00,1,5.34,6.00,6.00,6.0000,0.34
12:10:00,7,1,6.00,1,5.34,6.00,6.00,6.0000,0.34
12:15:00,7,1,6.00,1,5.00,6.00,5.00,6.0000,0.00
12:20:00,7,1,6.00,3,5.00,6.00,5.00,6.0000,0.00
12:25:00,7,1,6.00,3,5.00,6.00,6.00,6.0000,0.00
12:30:00,7,1,6.00,2,5.00,5.63,6.00,6.0000,0.00
12:35:00,7,1,6.00,2,6.00,6.00,6.00,6.0000,1.00
12:40:00,7,1,6.00,2,6.00,6.34,7.00,6.0000,1.00
12:45:00,7,1,6.00,2,5.00,6.00,6.00,6.0000,0.00
12:50:00,7,1,6.00,2,6.00,6.63,6.00,6.0000,1.00
12:55:00,7,1,6.00,2,5.00,5.63,7.00,6.0000,0.00
13:00:00,7,1,6.00,2,5.34,5.00,7.00,6.0000,0.00
13:05:00,7,1,6.00,3,6.00,6.00,7.00,6.0000,0.00
13:10:00,7,1,6.00,3,6.00,5.00,7.00,6.0000,0.00
13:15:00,7,1,6.00,4,6.00,5.00,6.00,6.0000,1.00
13:20:00,7,1,6.00,5,6.00,6.00,6.00,6.0000,1.00
13:25:00,7,1,6.00,4,6.00,6.00,6.00,6.0000,1.00
13:30:00,7,1,6.00,4,5.00,5.00,7.00,6.0000,0.00
13:35:00,7,1,6.00,3,5.00,6.00,7.00,6.0000,0.00
13:40:00,7,1,6.00,3,6.00,7.00,7.00,6.0000,0.00
13:45:00,6,1,6.00,4,6.00,6.00,7.00,6.0000,0.00
13:50:00,6,1,6.00,3,6.00,6.00,6.00,6.0000,0.06
13:55:00,6,1,6.00,3,6.00,6.00,6.00,6.0000,0.06
14:00:00,6,1,5.00,3,6.00,6.00,6.00,7.0000,1.00
14:05:00,6,1,5.00,2,6.00,6.00,6.00,7.0000,1.00
14:10:00,7,1,6.00,2,6.00,6.00,6.00,7.0000,1.00
14:15:00,7,1,6.00,2,5.63,6.00,7.00,7.0000,0.63
14:20:00,7,1,6.00,2,6.00,6.00,8.00,7.0000,0.00
14:25:00,7,1,6.00,3,6.00,6.00,7.00,7.0000,0.00
14:30:00,7,1,6.00,5,7.00,7.00,7.00,7.0000,1.00
14:35:00,7,1,6.00,5,7.00,7.00,7.00,7.0000,0.66
14:40:00,7,1,6.00,4,7.00,7.00,8.00,7.0000,0.06
14:45:00,7,1,6.00,4,6.49,7.88,8.00,7.0000,0.49
14:50:00,7,1,6.00,4,6.49,6.94,8.00,7.0000,0.49
14:55:00,7,1,6.00,4,8.00,7.00,8.00,7.0000,0.66
15:00:00,7,1,6.00,4,6.63,6.00,9.00,7.0000,0.63
15:05:00,7,1,6.00,4,6.00,5.63,9.00,7.0000,0.00
15:10:00,7,1,6.00,4,6.00,5.00,9.00,7.0000,0.66
15:15:00,7,1,6.00,4,6.00,6.00,9.00,7.0000,1.00
15:20:00,7,1,6.00,3,6.00,6.00,7.00,7.0000,0.00
15:25:00,7,1,6.00,3,6.00,6.00,7.00,7.0000,0.00
15:30:00,7,1,6.00,1,6.04,6.00,7.00,7.0000,0.04
15:35:00,7,1,6.00,1,6.00,6.74,7.00,7.0000,1.00
15:40:00,7,1,6.00,2,6.00,6.00,7.00,7.0000,1.00
15:45:00,7,1,6.00,2,6.00,6.00,8.00,7.0000,0.00
15:50:00,7,1,6.00,2,6.00,6.00,7.00,7.0000,0.00
15:55:00,7,1,6.00,3,6.00,6.00,7.00,7.0000,0.00
16:00:00,7,1,6.00,3,6.00,6.00,7.00,6.0000,0.37
16:05:00,7,1,6.00,3,5.00,5.00,7.00,6.0000,0.00
16:10:00,7,1,6.00,4,5.00,5.00,7.00,6.0000,0.00
16:15:00,7,1,6.00,5,6.00,5.63,7.00,6.0000,0.00
16:20:00,7,1,6.00,3,6.00,5.00,6.00,6.0000,0.00
16:25:00,7,1,6.00,3,6.00,5.00,7.00,6.0000,0.00
16:30:00,7,1,6.00,3,6.00,5.63,7.00,6.0000,0.00
16:35:00,7,1,6.00,2,6.00,6.00,6.00,6.0000,0.66
16:40:00,7,1,6.00,3,6.00,6.00,7.00,6.0000,0.51
16:45:00,6,1,6.00,3,6.00,6.49,8.00,6.0000,0.00
16:50:00,6,1,6.00,5,6.00,6.00,6.00,6.0000,1.00
16:55:00,6,1,7.00,5,6.00,6.00,6.00,6.0000,1.00
17:00:00,6,1,6.00,4,6.49,7.34,8.00,7.0000,0.15
17:05:00,6,1,6.00,4,6.00,7.00,7.00,7.0000,0.00
17:10:00,7,1,6.00,4,6.94,7.94,7.00,7.0000,0.94
17:15:00,7,1,6.00,4,6.94,7.00,7.00,7.0000,0.94
17:20:00,7,1,6.00,5,6.34,7.00,7.00,7.0000,0.00
17:25:00,7,1,6.00,5,6.00,7.00,6.00,7.0000,0.00
17:30:00,7,1,6.00,5,6.00,6.94,8.00,7.0000,1.00
17:35:00,7,1,6.00,5,6.00,6.94,7.00,7.0000,0.06
17:40:00,7,1,6.00,4,6.00,7.00,7.00,7.0000,0.00
17:45:00,6,1,6.00,6,6.68,7.68,9.00,7.0000,0.19
17:50:00,6,1,7.00,6,6.98,7.02,9.00,7.0000,0.49
17:55:00,6,1,7.00,6,6.98,7.64,8.00,7.0000,0.49
18:00:00,6,1,7.00,6,6.49,7.64,8.00,7.0000,0.49
18:05:00,6,1,7.00,6,7.00,7.49,8.00,7.0000,1.00
18:10:00,7,1,7.00,6,6.00,7.00,7.00,7.0000,0.00
18:15:00,7,1,7.00,6,6.63,7.63,7.00,7.0000,0.63
18:20:00,7,1,7.00,7,7.00,7.00,8.00,7.0000,0.00
18:25:00,7,1,7.00,7,6.68,7.34,8.00,7.0000,0.19
18:30:00,7,1,7.00,7,6.34,7.00,7.00,7.0000,0.85
18:35:00,7,1,7.00,6,6.49,7.49,9.00,7.0000,0.49
18:40:00,7,1,7.00,5,6.49,7.34,8.00,7.0000,0.49
18:45:00,6,1,7.00,6,6.49,7.00,8.00,7.0000,0.52
18:50:00,6,1,7.00,6,6.00,6.00,7.00,7.0000,0.00
18:55:00,6,1,7.00,4,6.00,6.34,7.00,7.0000,1.00
19:00:00,6,1,7.00,4,5.34,6.34,7.00,6.0000,0.34
19:05:00,6,1,6.00,4,6.00,6.00,6.00,6.0000,1.00
19:10:00,7,1,6.00,2,5.00,5.34,6.00,6.0000,1.00
19:15:00,7,1,6.00,2,5.34,6.00,6.00,6.0000,0.34
19:20:00,7,1,5.00,2,5.00,5.34,5.00,6.0000,0.66
19:25:00,7,1,5.00,3,5.00,5.63,6.00,6.0000,0.00
19:30:00,7,1,5.00,3,4.94,5.00,6.00,6.0000,0.94
19:35:00,7,1,5.00,2,5.88,5.00,6.00,6.0000,1.88
19:40:00,7,1,5.00,2,6.00,5.34,6.00,6.0000,1.66
19:45:00,6,1,6.00,2,5.00,5.00,5.00,6.0000,1.00
19:50:00,6,1,6.00,2,5.00,5.00,6.00,6.0000,1.00
19:55:00,6,1,6.00,1,5.00,5.00,6.00,6.0000,0.66
20:00:00,6,1,6.00,1,5.00,5.00,5.00,5.0000,1.00
20:05:00,6,1,6.00,1,5.00,5.00,6.00,5.0000,0.06
20:10:00,6,1,5.00,1,5.00,5.00,5.00,5.0000,0.06
20:15:00,6,1,5.00,1,5.00,5.49,6.00,5.0000,0.00
20:20:00,6,1,5.00,1,5.00,5.49,6.00,5.0000,0.51
20:25:00,6,1,5.00,5,5.00,5.49,6.00,5.0000,0.00
20:30:00,6,1,5.00,5,5.00,5.74,6.00,5.0000,0.00
20:35:00,6,1,5.00,5,5.00,5.00,6.00,5.0000,0.26
20:40:00,6,1,5.00,5,5.00,5.00,5.00,5.0000,1.00
20:45:00,5,1,5.00,5,5.00,5.00,6.00,5.0000,0.00
20:50:00,5,1,5.00,5,5.00,5.34,6.00,5.0000,0.00
20:55:00,5,1,5.00,5,5.00,5.34,6.00,5.0000,0.00
21:00:00,5,1,5.00,5,5.00,5.34,6.00,5.0000,0.00
21:05:00,5,1,5.00,5,5.00,5.00,6.00,5.0000,0.00
21:10:00,5,1,5.00,5,5.00,5.00,6.00,5.0000,0.00
21:15:00,5,1,5.00,4,4.49,5.00,7.00,5.0000,0.00
21:20:00,5,1,5.00,3,4.49,5.00,7.00,5.0000,0.00
21:25:00,5,1,5.00,3,5.00,6.00,6.00,5.0000,0.00
21:30:00,5,1,5.00,3,4.34,5.00,5.00,5.0000,0.00
21:35:00,5,1,5.00,4,4.63,4.63,5.00,5.0000,0.63
21:40:00,5,1,5.00,4,3.63,4.00,5.00,5.0000,0.63
21:45:00,5,1,5.00,4,4.00,4.34,5.00,5.0000,0.00
21:50:00,5,1,5.00,4,4.94,5.00,5.00,5.0000,0.94
21:55:00,5,1,5.00,4,4.00,4.00,5.00,5.0000,0.51
22:00:00,5,1,5.00,4,4.34,5.00,5.00,5.0000,0.34
22:05:00,5,1,5.00,3,4.34,5.00,5.00,5.0000,0.34
22:10:00,5,1,5.00,3,4.00,5.00,5.00,5.0000,0.00
22:15:00,5,1,5.00,5,4.34,5.00,5.00,5.0000,0.00
22:20:00,5,1,5.00,5,5.00,5.94,6.00,5.0000,0.00
22:25:00,5,1,5.00,5,5.94,6.88,6.00,5.0000,0.94
22:30:00,5,1,5.00,5,5.00,5.94,6.00,5.0000,0.00
22:35:00,5,1,5.00,4,5.00,5.00,5.00,5.0000,1.00
22:40:00,5,1,5.00,4,5.00,5.00,5.00,5.0000,1.00
22:45:00,5,0,5.00,3,5.00,5.00,5.00,5.0000,1.00
22:50:00,5,0,5.00,1,5.00,5.00,6.00,5.0000,0.00
22:55:00,5,0,5.00,2,4.00,5.04,6.00,5.0000,0.00
23:00:00,5,0,5.00,3,5.00,5.34,5.00,4.0000,0.00
23:05:00,5,0,5.00,3,5.00,5.00,5.00,4.0000,0.00
23:10:00,5,0,5.00,4,4.00,4.00,5.00,4.0000,0.00
23:15:00,5,0,5.00,5,4.34,5.00,5.00,4.0000,0.34
23:20:00,5,0,6.00,6,4.34,4.00,7.00,4.0000,0.00
23:25:00,5,0,6.00,5,4.34,4.00,6.00,4.0000,0.00
23:30:00,5,0,6.00,5,4.04,4.04,5.00,4.0000,0.04
23:35:00,5,0,6.00,5,3.00,3.00,5.00,4.0000,0.00
23:40:00,5,0,6.00,5,3.34,3.34,6.00,4.0000,0.00
23:45:00,5,0,6.00,5,3.34,3.34,6.00,4.0000,0.00
23:50:00,5,0,6.00,4,3.34,3.00,5.00,4.0000,-0.15
23:55:00,5,0,6.00,3,3.34,3.00,4.00,4.0000,0.34
Rank 1
Rank 1
I just reverted my project from UI for ASP.NET AJAX Q3 2015 to UI for ASP.NET AJAX Q2 2015 and the excruciating slowness for the panel control and the chart went away. This older version works the way it should and the legend click responds in seconds instead of minutes.
There is something wrong with your Q3 version that makes everything run so slow that the company was talking of dumping Telerik. Unfortunately, we lost the spreadsheet UI by reverting to a prior release. Please advise when you have determined the problem and when there will be a fix. Thank you.
Please find my answers to your questions.
@Kandagatla - Such a feature request has already been logged in this feedback item here(http://feedback.telerik.com/Project/108/Feedback/Details/123802), so that you can monitor, comment and vote on it. You can also find possible solutions in the item.
I would also suggest when you have different questions to open a separate forum thread or write in the corresponding one.
Thank you for your cooperation.
@George - Could you please elaborate more about the issue with the panel? By the "panel"
term do you mean the RadPanelBar control or something else? Can you provide us with a runnable sample where the issue is reproducible? Can you also tell us whether the issue is reproducible with the Q1 2016 release?
Regarding the chart - there is some slowdown with the chart's redrawing and the mentioned scenario with the latest version of the controls. I have forwarded the case to the attention of our developers, so that I will get back to you once we have an update on the matter.
As for the empty categories I would suggest that you bind the axis and configure a particular BaseUnitStep and Labels Step. For example:
ASPX:
<XAxis MajorTickType="None" MinorTickType="None" BaseUnit="Minutes" BaseUnitStep="5"> <MinorGridLines Visible="false" /> <MajorGridLines Visible="false" /> <TitleAppearance Text="Time" Visible="false" /> <LabelsAppearance RotationAngle="-90" Step="5" /></XAxis>You can find such a sample in the attachment.
On a side note - considering the volume of the data shown on the chart I would suggest the following:
- Use the data navigation functionality of the chart - http://demos.telerik.com/aspnet-ajax/htmlchart/examples/functionality/datanavigation/defaultcs.aspx
- Take advantage of the pan and zoom functionality - http://demos.telerik.com/aspnet-ajax/htmlchart/examples/functionality/pan-zoom/defaultcs.aspx
Regards,
Danail Vasilev
Telerik
Rank 1
Thank you for the tips, Vasil.
The RadPanelBar is what I was talking about. It is simple use of this control that is slow. See code below. Reverting also fixed this issue with dramatic improvement of response time. It appears the way the new release is painting the screen is excruciatingly slow.
I should have some time in a few days to upgrade my Telerik and see if the speed is still poor with the latest release.
<div id="leftMenuScrollable" class="panelbar-scrollable">
<telerik:RadPanelBar OnClientItemClicking="checkOpenPopUp" runat="server" ID="leftMenu" OnItemClick="leftMenu_ItemClick" Skin="AMR" EnableEmbeddedSkins="false" Width="100%">
<Items>
</Items>
<ExpandAnimation Type="None" />
<CollapseAnimation Type="None" />
</telerik:RadPanelBar>
</div>
leftMenu.DataSource = cadIDArrayLeftMenu;
leftMenu.DataBind();
if (leftMenu.Items.Count > 0)
leftMenu.Items[0].Selected = true;
The provided information is not enough to determine the cause of the issue. I would suggest that you open a support ticket for the RadPanelBar where you can provide a runnable sample that reproduces the issue. Thus we will try to investigate the issue and provide a solution if possible.
Thank you for your cooperation.
Regards,
Danail Vasilev
Telerik
This post is to let you know that the issue with the chart's performance when many empty x-axis categories are present has been resolved. If everything is fine the fix will be available for the upcoming Q1 2016 SP1 release, scheduled for the end of this month.
Regards,
Danail Vasilev
Telerik