• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Flex Combobox and Grid loads very very slowly for large data

 
Greenhorn
Posts: 1
Safari Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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

 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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?
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic