• Content count

  • Joined

  • Last visited

About joshtheflame

  • Rank
    Forum Newbie
  1. Dear Experts, I am developing an application for telecom industry actually its a business intelligence tool in evaluation version. I am dealing with billions of records so therefore I made summary tables and fetching records from there. Currently I followed "COMBINING FUSION CHARTS, ASP.NET & JAVASCRIPT (dataXML) method" from the help and populate months chart. when you click on any month it shows another chart below and populate all the operators summary of that particular month. But I am afraid its a very slow process as the blow mentioned code [script language=javascript" type="text/javascript] //Here, we use a mix of server side script (C#) and JavaScript to //render our data for factory chart in JavaScript variables. We'll later //utilize this data to dynamically plot charts. //All our data is stored in the data array. From C#, we iterate through //each recordset of data and then store it as nested arrays in this data array. [var data = new Array();] //Write the data as JavaScript variables here [<%=GetScript()%> ;] [] Code behind ----------------- public string GetScript() { //Here, we generate the JavaScript array code for the factory data. //String to store JavaScript variables StringBuilder jsVarString = new StringBuilder(); //Generate SQL querystring to get all months string monthsQuery = "select distinct months, replace(to_char(to_date('01'||months||'2010','DD-MON-YYYY'),'MM'),0,null) from vw_pre_probe_summary"; //Sets JavaScript Array Index int indexCount = 0; //Establish Database Connection Database db = DatabaseFactory.CreateDatabase(); //Create Command object DbCommand cmd = db.GetSqlStringCommand(monthsQuery); //Execute command and read data in a DataSet IDataReader idr = db.ExecuteReader(cmd); while (idr.Read()) { //Iterate through each record indexCount++; //Build JavaScript : Create a new JavaScript Array jsVarString.AppendFormat("tt data[{0}] = new Array();", idr[1]); jsVarString.Append(Environment.NewLine); //Create an SQL Query for the current month string detailsql = "select a.years, a.ldi_cd, a.months, b.operator_name, round(sum(a.cer_dur)/60) from vw_pre_probe_summary a, ldioperators b where a.months = " + "'" + idr[0] + "'" + " and a.ldi_cd = b.ldi_cd group by a.years, a.months, a.ldi_cd, b.operator_name"; //Create Command object DbCommand cmdDetail = db.GetSqlStringCommand(detailsql); //Execute command and read data in a DataSet IDataReader idrDetail = db.ExecuteReader(cmdDetail); //Iterate Through records while (idrDetail.Read()) { //Build JavaScript : Push Operators Data into JavaScript Array jsVarString.AppendFormat("tt data[{0}].push(new Array('{1}',{2}));", idr[1], idrDetail[3], idrDetail[4]); jsVarString.Append(Environment.NewLine); } } //Returns JavaScript variables return jsVarString.ToString(); } loading the whole XML in memory when the page executes and taking the page come up after such a long time. If I follow the above method and If I have 8 to 9 details drill downs I believe I need to query them first will be dead slow....So my question is that if I need to develop quick charts and if I am dealing with billions of records which approach is THE BEST in context of "Efficiency", Speed and performance of the whole application. Please guide accordingly .. Thanks
  2. Chart Messages

    yeah its not showing the loading i want to show message while its loading the data "Loading data please wait..." ...and when its in the processing of render the chart it should say "Rendering chart please wait...."...stuff like that..
  3. Chart Messages

    yeah its working perfectly but the data is huge so its taking so much time for loading...therefore wanted to show users a message that its loading....can you please suggest where to put my code to achieve this..please help. thanks
  4. Chart Messages

    well I did before ur post but dont know where to put as my method is different..any help according to my code??
  5. Chart Messages

    <%=GetFactorySummayChartHtml()%> <%=GetFactoryDetailedChartHtml()%>