Datasource using Infoset - running forever

hi Gurus,

I have a infoset created by joining tables QMEL & QMFE. I also have some extra fields in the infoset and coding for them.

Based on this infoset I have created a datasource & all the BW setup is done.

When I try to load the data for single or small number of notifications the ODS is loaded successfully however if I am loading it for certain notifcation type which has about 30,000 records or so the data extraction is timing out and no data is loaded.

Even when I try to test the datasource on SAP end using RSA3 the program just shows its executing but there is no outcome.

How can I resolve this problem?

Thanks,

Sonal