To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101280
------- Additional comments from [email protected] Wed Jun 24 11:37:31 +0000 2009 ------- 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. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
