I am using Oracle 8i as database. And my frontend application is in VB 6.0.

I have arround 50000 records in one Master Table which i wants to populate in a third party(Sheriden Datawidget) combo. To make record filling routine fast i have bounded this ComboBox to a ADODC control. Its polpulating all records in 2-3 minuts. But this much speed will not also bearable.

Can anyone tell me, how to speed up this process.

This is actual code for binding third party control to a ADODC data control.
'**************************
'Setting recordsource to ADODC Control
ADODC1.RecordSource = "Select a.ItemPart_No || Case When a.ItemPart_No
Is Null Or a.ItemPart_No='' Then '' Else ' ' End || a.Item_Desc_ENG
Item_Desc_ENG,b.Type_Desc,a.Item_Code,b.Type_Category,
ab.Supp_Name,a.ItemGrp_Code From Item_Mst a, Type_Mst b, Supp_Mst ab Where
a.Item_Unit=b.Type_Category And a.Comp_Code=b.Comp_Code And
a.Comp_Code='01' And b.Type_Code='UN' And a.Supp_Code=ab.Supp_Code (+) And
a.Comp_Code=ab.Comp_Code (+) And (a.Supp_Code='ABC0' or a.Supp_Code='' or
a.Supp_Code Is Null) Order by 1"

ADODC1.Refresh ''Here it is taking time

'Setting datasource to sheridan dropdown oledb control
Set ssdboleDropDown.DataSource = ado_All
ssdboleDropDown.Columns(0).DataField = ADODC1.Recordset.Fields(0).Name
'**************************