From what I understand, you are creating journal entries on-the-fly, which means when you run the report, the system creates the journal entries from the transactions. Some suggestions:

1. Create the journal and ledger entries at the same time that you save the transaction. That way, you do not have to generate those entries everytime you run the report.
2. Since you are generating GL reports, everytime a period is closed, transactions falling into closed periods should not be allowed into the system. For these closed periods, your reports can use journal entries summarized per account. In some ways, I think this is waht you are trying to suggest below.
3. See if you can optimize the indexes further.

I think a combination of (1) and (2) will work for you. For #3, make it a habit of checking and testing what indexes can speed up your app, but sometimes this does not work, and you need to redesign your application's architecture in order to achieve the best results.

HTH

>hi ,
>In app I used to convert All tracsactions (Invoice,Voucher..etc) into Accounting readable format the Journal Entry (DR,CR) before getting into Reports and other like GL and Subsidiary ledgers. My problem is as the our data get Larger (100MB) it becomes slower as the date excrease because every time i generate a report the app convert all transactions into JOurnal Entries then Process the reports.Im planning to Cache this JE (JOurnal Entries) by closing some periods and Save the Accoumulated Total of it into records.I just want to know if I am doing the right technique before I start doing the scripts? Any Idea or experience like this?
>tnx