Report rendering and sql execution using up too much memory

jing · Post by **jing** » Mon Feb 12, 2007 5:45 pm

Hi,

We have manually created a database and a datasource from the report designer.
The query for the datasource is "Select * From f_table"

f_table is a big table with many fields and many rows (millions)
When we click the sql "run" button, the designer is using up nearly 800MB of memory and seizes the computer. This happens again when we preview the report..

Is there a way around this?

Is there a way to release the memory after an sql statement execution? (the designer seems to be accumulating the memory and does not release it after it's closed..)

Thanks

Post by **Vital** » Mon Feb 12, 2007 5:50 pm

After report designer is closed you need dispose StiReport object and set reference to StiReport to null.
Thank you.

jing · Post by **jing** » Mon Feb 12, 2007 7:44 pm

Thanks for your reply.
I was already doing that.

I guess it is not much of a problem providing the table does not have millions of records.

So is there no way to manually release the memory when the report designer is running? (say after preview/after running sql)

Thanks again

jing · Post by **jing** » Wed Feb 14, 2007 4:17 pm

Any progress on this?

Is there a way to manually release the memory when the report designer is running? (Especially after preview and after running the sql query)

I have tried StiReport.ClearAllReportCache(), but it didn't make much difference...

Thanks very much

Post by **Edward** » Thu Feb 15, 2007 1:24 am

We've made some corrections in our code. Please download build from February, 15. It will be available today.

Thank you.