This is a test case i have created . My actual appliaction may have upto
100000 records.
it is a medicine data base. There are thousands of medicines and each medicine may manufacured by hundreads of manufactures.

So if the user select all products of all manufacures, the number of records may more than 100000. My Current application displaying this with in 10 sec.

thanks