Flex Combobox and Grid loads very very slowly for large data

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

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