Issue 101280

Looks like OOO is reading here also the whole table just to get the key values
as reported in issue 102625. When you look at the memory usage you will probably
see that OOO is eating up al your memory.

can you please test it with OpenOffice.org 3.1 and SRB 1.1?

The select * from table is also in OOO310m11 and not related to SRB. When
accessing data from a table, view table or report or...,  the select * is
executed.   

and what do you expect?

In issue 102625 I explained in detail that in order to get the key values from
the table, OOO executes a "select * from table". It then gets the fields needed
by a "select fields from table where id=?" for every row needed. So, not only is
OOO getting every record twice from the db but also ,if for example you need
only 4 decimal columns out of 95 columns, ooo still retrieves all the columns in
the first query wasting sometimes an enormuous amount of memory.
My suggested fix was to do a "select id from table" followed by the "select
fields from table where id=?" queries to retrieve individual rows.

If ludob's comments are correct, that easily explains why the report creation
was taking so long. The table itself is about 400 MB but the data selected in
the report should be about 1 MB. While the way it currently retrieves data is
certainly inefficient, I am not sure that is a bug-just the wrong way about things.

The bug I was reporting was the fact that clicking "Stop" does not interrupt the
report creation.

I have no intention to hijack this bug. "Stop" should return to user control.

When your PC has been churning 5 hours on a 400 MB table I guess you run out of
physical memory and start swapping. Even if OOO sends an SQLCancel to the driver
while doing the select * from table, which I couldn't verify, and the driver
does cancel the operation correctly, I would expect that cleaning up the
resultset in the driver and OOO would take also a lot of time because of
swapping and cause a long delay to regain user control. Shouldn't take hours
though. 
Could you check memory usage before and after stop? After you push stop, is OOO
consuming CPU or is it idling?

Some ODBC drivers are reported to have problems with SQLCancel not doing
anything.(mysql 3.51, oracle 9.2.0.7.0 with oracle server on NT, DB2 client 7.?,
...). This would also cause ooo to hang around not releasing user control.
What driver are you using?

Issue 66846 reports OOO crashing on out of memory conditions opening large
tables. JDBC apparently reports an out of heap memory condition. Not sure what
your odbc driver is doing: stop and report or just sit there.

If getting 1MB of data out of a 400MB database isn't possible because of "just
the wrong way about things", I for sure call that a bug. Even a show stopper.
I'm considering raising priority on issue 102625....

I have psqlODBC 8.03.04 installed. After clicking "Stop", memory consumption
continues to rise(slowly) and CPU load is 50%. I have a dual core processor, so
it's maxing out one core.

Oddly enough, memory consumption rises very slowly. About 4-8KB per second. 

which database backend do you use with ODBC?

do you also try to get the results with another frontend?

Is it an intranet or an internet connection?

This Issue requires more information ('needmoreinfo'), but has not been updated
within the last year. Please provide feedback as requested and re-test with the the latest version of OpenOffice - the problem(s) may already be addressed. 

You can download Apache OpenOffice 3.4.1 from http://www.openoffice.org/download

Please report back the outcome of your testing, so this Issue may be closed or
progressed as necessary - otherwise the issue may be Resolved as Invalid in the
future.

No news from OP