aspose file tools*
The moose likes Flex and the fly likes Flex Combobox and Grid loads very very slowly for large data Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Frameworks » Flex
Bookmark "Flex Combobox and Grid loads very very slowly for large data" Watch "Flex Combobox and Grid loads very very slowly for large data" New topic
Author

Flex Combobox and Grid loads very very slowly for large data

Atif Agha
Greenhorn

Joined: Apr 01, 2011
Posts: 1

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

Joined: Apr 14, 2004
Posts: 10336

You are loading 6 million records in a combo box? Why do you need to show the user 6 million records at once?


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Flex Combobox and Grid loads very very slowly for large data
 
Similar Threads
Combo box that load data automatically when mouse over the combo box
ComboBox Item Display
Flex-LCDS
problem in giving onChange event in s:combobox
load data automatically when mouse over the combobox