Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Flex Combobox and Grid loads very very slowly for large data

 
Atif Agha
Greenhorn
Posts: 1
Java Safari
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi



I am doing an Enterprise Application in Flex-LCDs-Java.

All was going well,

but suddenly when i had made a complete module of it, in next module, i loaded the data in combo box, dynamically using data service, there are 6 million records which need to be added,

backend db is sql server, sql fetches information of 6 million records with in 9 to 13 seconds, where as flex combo box takes 3 minutes to load the same data, now the question can be, java is slow, but ofcourse this is not, because if i test it in java compiler, java takes the same time which sql server takes to load data, but may be some thing wrong in technique or lcd or blaze ds is weak in such case.



For Flex

I am using Flash Builder 4 with LCDs, and this is the code

<s:Combobox


x="213" y="52" id="comboBox" creationComplete="comboBox_creationCompleteHandler(event)" labelField="text">

<s:AsyncListView list="{fetchYarnArrivalResult.lastResult}" />


</s:ComboBox>




protected function comboBox_creationCompleteHandler(event:FlexEvent):void

{


fetchYarnArrivalResult.token = contactService.fetchYarnArrival();

}






For Java,


A simple ArrayList of Class having an Id and a name, nothing else.


fetchYarnArrival is a function which brings data from database and loads in ArrayList and return it at the end.



Please let me know, how to speed up these combo boxes, same thing happens with data grid.



Regards

Atif

 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You are loading 6 million records in a combo box? Why do you need to show the user 6 million records at once?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic