[dba-issues] [Issue 102625] Table Data View + ODBC issues select * from table to get only key data

2011-01-14 Thread oj
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=102625


User oj changed the following:

What|Old value |New value

 Assigned to|oj|msc





--- Additional comments from o...@openoffice.org Fri Jan 14 08:05:47 + 
2011 ---
Please verify. Thanks.

repro:

- enable ODBC tracing
- Open any db with ODBC
- Open any table with a primary key
- Close OOo
- Search for the table name in the log file from ODBC tracing

= There less calls for SELECT * from 

-
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: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org



[dba-issues] [Issue 102625] Table Data View + ODBC issues select * from table to get only key data

2011-01-14 Thread ludob
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=102625





--- Additional comments from lu...@openoffice.org Fri Jan 14 08:33:51 + 
2011 ---
Did anything change from Dec 3? Or is this request just for msc?

I did verify the dba34c: #i102625# only fetch rows when the
view moves outside the scope of the rowset window  changes and made my
comments. There are indeed less select * from y where key = ?. If you only
scroll forward there are just a few when fetching the last page. That is an
improvement. 

I'm not going to repeat my Dec 6 comments but the main issue is not the select
* from y where key = ? but the initial select * from y. Plus, the select *
from y where key = ? still retrieves blob data while not used in table view.



-
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: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org