flex 大数据怎么查询优化
sql语句放在数据库中查询百万条只需要1秒,但是前台一查询就崩!我用的是java交互在线等解决方案!
public var arrshow:ArrayCollection = new ArrayCollection();
public var arr_static:ArrayCollection ;
public function getStatic(event:ResultEvent):void
{
var boundcount:int = 0;
var movecount:int = 0;
var voltagecount:int = 0;
var lostcount:int = 0;
var newOne:Object = new Object();
arr_static = new ArrayCollection();
arr_static = event.result as ArrayCollection;
if(arr_static.length==0)
{
Alert.show("数据正常");
}
if(arr_static.length != 0)
exportXLS.visible = true;
for(var i:int = 0;i<arr_static.length;i++)
{
if(arr_static.getItemAt(i).LostSignal == "0")
newOne.state = "数据完好";
else arr_static.getItemAt(i).LostSignal = "1"
{
newOne.state = "数据丢失";
}
if(arr_static.getItemAt(i).BoundAlarm= "1")
boundcount++;
if(arr_static.getItemAt(i).MoveAlarm = "1")
movecount++;
if(arr_static.getItemAt(i).VoltageAlarm= "1")
voltagecount++;
if(arr_static.getItemAt(i).LostSignal !== "0")
lostcount++;
newOne.bound = arr_static.getItemAt(i).BoundAlarm;
newOne.move = arr_static.getItemAt(i).MoveAlarm;
newOne.voltage = arr_static.getItemAt(i).VoltageAlarm;
newOne.name = arr_static.getItemAt(i).Name;
newOne.time = arr_static.getItemAt(i).ReceiveTime;
arrshow.addItem(clone(newOne));
}
lbound.text = boundcount+"次";
lmove.text = movecount+"次";
lvoltage.text = voltagecount+"次";
llost.text = lostcount+"次";
PopUpManager.removePopUp(progWin);
}
<s:RemoteObject id="RO" destination="pmUserAction" fault="RO_faultHandler(event)">
<s:method name="getStatic" result="getStatic(event)"/>
<s:method name="getAlarm" result="getAlarm(event)"/>
<s:method name="getallstation" result="getallstation(event)"/>
</s:RemoteObject>