Increasing Performance on 3 Chained Drop Downs

[LeonelSanchezJr]

I have 2 Drop Down boxes that are chained.
They work great until I add the third Chained Drop Down.

1st Drop Down = Region
2nd Drop Down = Country
3rd Drop Down = Station

I have 3 separate FEXES which create XML files.
The first works by who the current user is.
The 2nd works by who the current user is and which REGION was chosen.
The 3rd worsk by who the current user is and which COUNTRY was chosen.

When I chain all 3 together, they take 1 minute to populate. There are 15,000 records in the source table (ORACLE). The FEXES point to a Synonym.

I am using Webfocus Developer Studio version 7.1.3.

I tried the Cached Runtime, but that did not help.






Thanks,

Leo ;-)