[dba-issues] [Issue 73245] Base 2.1 odbc access to as /400 slower than in 2.0.4 (one SQLTables/SQLCo lumns call for *every* table)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73245 User mechtilde changed the following: What|Old value |New value Status whiteboard| |as/400 - 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 73245] Base 2.1 odbc access to as /400 slower than in 2.0.4 (one SQLTables/SQLCo lumns call for *every* table)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73245 --- Additional comments from [EMAIL PROTECTED] Sun Nov 11 19:53:47 + 2007 --- Congratulations! After I copied odbc32.dll to the program subdirectory, I was able to test the issue and it's fine. Times are like they were in 2.0.4. Thank you very much. - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 73245] Base 2.1 odbc access to as /400 slower than in 2.0.4 (one SQLTables/SQLCo lumns call for *every* table)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73245 User fs changed the following: What|Old value |New value Status|RESOLVED |VERIFIED --- Additional comments from [EMAIL PROTECTED] Sun Nov 11 21:06:17 + 2007 --- Okay, that's great to hear. Thanks for trying this out. - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 73245] Base 2.1 odbc access to as /400 slower than in 2.0.4 (one SQLTables/SQLCo lumns call for *every* table)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73245 --- Additional comments from [EMAIL PROTECTED] Thu Nov 8 08:03:46 + 2007 --- I tried both to open the existing .odb and enter the data source manually, but I always get some error with ODBC32.DLL in it. - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 73245] Base 2.1 odbc access to as /400 slower than in 2.0.4 (one SQLTables/SQLCo lumns call for *every* table)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73245 --- Additional comments from [EMAIL PROTECTED] Thu Nov 8 13:30:34 + 2007 --- Ah, yes, the driver itself (not only the ODBC UI) has this error I mentioned. Sigh. I am going to attach a fixed driver. - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 73245] Base 2.1 odbc access to as /400 slower than in 2.0.4 (one SQLTables/SQLCo lumns call for *every* table)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73245 --- Additional comments from [EMAIL PROTECTED] Thu Nov 8 13:50:54 + 2007 --- fs-tbrenk: please extract the attached zip into your installation's program directory, it will overwrite the existing odbc2.dll. After this, ODBC connections should work, again. - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 73245] Base 2.1 odbc access to as /400 slower than in 2.0.4 (one SQLTables/SQLCo lumns call for *every* table)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73245 --- Additional comments from [EMAIL PROTECTED] Thu Nov 8 13:47:51 + 2007 --- Created an attachment (id=49525) fix for the ODBC connection problem in the developer snapshot - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 73245] Base 2.1 odbc access to as /400 slower than in 2.0.4 (one SQLTables/SQLCo lumns call for *every* table)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73245 --- Additional comments from [EMAIL PROTECTED] Thu Nov 8 15:29:24 + 2007 --- I copied the odbc2.dll to the program subdirectory, but this did not help. Same error messages as before. - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 73245] Base 2.1 odbc access to as /400 slower than in 2.0.4 (one SQLTables/SQLCo lumns call for *every* table)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73245 --- Additional comments from [EMAIL PROTECTED] Thu Nov 8 20:53:23 + 2007 --- Ehm - sure? I did the same thing here, and it worked. Hmm. Try copying the odbc32.dll from your windows\system32 directory to the program folder. (Not sure if odbc32.dll is self-contained to allow this, but it's worth a try.) - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 73245] Base 2.1 odbc access to as /400 slower than in 2.0.4 (one SQLTables/SQLCo lumns call for *every* table)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73245 User fs changed the following: What|Old value |New value Target milestone|OOo 2.x |OOo 2.4 --- Additional comments from [EMAIL PROTECTED] Wed Nov 7 08:47:07 + 2007 --- targeting to 2.4, since the fix is part of a CWS aiming for this release - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 73245] Base 2.1 odbc access to as /400 slower than in 2.0.4 (one SQLTables/SQLCo lumns call for *every* table)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73245 --- Additional comments from [EMAIL PROTECTED] Wed Nov 7 08:55:46 + 2007 --- fs-tbrenk: Please find a snapshot of the CWS where this is fixed at http://ooo.services.openoffice.org/pub/OpenOffice.org/cws/upload/dba24c. This version will install in parallel to existing OOo releases (but will conflict with intermediate developer snapshots, in case you have installed them). If you could verify that this version solves your problem, I'd be most grateful. Thanks in advance. Please be aware that this is a version which is more advanced than the recent 2.3 release, which means there's some more features, and probably some more bugs therein - don't use it for production, please. - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 73245] Base 2.1 odbc access to as /400 slower than in 2.0.4 (one SQLTables/SQLCo lumns call for *every* table)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73245 --- Additional comments from [EMAIL PROTECTED] Wed Nov 7 23:21:46 + 2007 --- I tried to test the new build, but got an error: Could not load the program library ODBC32.DLL or it is corrupted. The Data source selection is not available. This happens not only for the selection, but also if I enter the data source manually. How can I fix this? - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 73245] Base 2.1 odbc access to as /400 slower than in 2.0.4 (one SQLTables/SQLCo lumns call for *every* table)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73245 --- Additional comments from [EMAIL PROTECTED] Thu Nov 8 06:29:20 + 2007 --- Argh. This is an issue introduced by somebody else on the main trunk, and the CWS inherited it. It's not fixed, yet, as far as I know. Can you try simply opening the .odb created with 2.3? You should not need the data source administration at all. Just open the existing database document on the same system, and see how long connecting takes. If you do not want to use the dev snapshot on the same system as 2.3, then you need to start the ODBC data source administration via the control panel. Then, in Base, just enter the ODBC data source name (without using the Browse button). - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 73245] Base 2.1 odbc access to as /400 slower than in 2.0.4 (one SQLTables/SQLCo lumns call for *every* table)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73245 --- Additional comments from [EMAIL PROTECTED] Mon Nov 5 06:28:27 + 2007 --- tbrenk-fs yes, I'd be glad to test it. - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 73245] Base 2.1 odbc access to as /400 slower than in 2.0.4 (one SQLTables/SQLCo lumns call for *every* table)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73245 --- Additional comments from [EMAIL PROTECTED] Sat Nov 3 14:46:09 + 2007 --- fs-tbrenk : If I would provide you a build of the child workspace where (I hope) this issue is fixed, would you be willing to test it and give me feedback? - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 73245] Base 2.1 odbc access to as /400 slower than in 2.0.4 (one SQLTables/SQLCo lumns call for *every* table)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73245 User fs changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED --- Additional comments from [EMAIL PROTECTED] Fri Oct 26 12:18:15 + 2007 --- fixed in CWS dba24c find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=SRC680%2Fdba24c - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 73245] Base 2.1 odbc access to as /400 slower than in 2.0.4 (one SQLTables/SQLCo lumns call for *every* table)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73245 User fs changed the following: What|Old value |New value Target milestone|--- |OOo 2.x --- Additional comments from [EMAIL PROTECTED] Fri Oct 26 05:58:10 + 2007 --- Okay, having seen another log from another user, where we also do one SQLTables and one SQLColumns for each table in the DB (and there were 756 of them), I think we should at least eliminate this tremendous amount of superfluous calls. I strongly suppose this will fix the problem, but cannot know until I get your feedback on the fix. - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 73245] Base 2.1 odbc access to as /400 slower than in 2.0.4 (one SQLTables/SQLCo lumns call for *every* table)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73245 --- Additional comments from [EMAIL PROTECTED] Wed Oct 10 14:32:31 + 2007 --- I just checked this issue with OOo 2.3.0. No change, as slow as before. - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 73245] Base 2.1 odbc access to as /400 slower than in 2.0.4 (one SQLTables/SQLCo lumns call for *every* table)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73245 --- Additional comments from [EMAIL PROTECTED] Wed Sep 12 18:55:14 + 2007 --- 1) AGDBPR is the table (physical file in as/400 terminology) AGDBPRL0 to L2 are indexes/views (logical files). Logical files can be accessed like views (you can do a select on them) and they are used as indexes by the system. If you create views or indexes using sql statements, the system will create logical files. 2) I did a performance comparison. We have a similar database (240 tables, 804 logical files) on two machines, one development machine with OS/400 V4.4 and a newer, faster production machine with OS/400 5.3. I have OpenOffice 2.0.4 on one pc and 2.2.1 on another. I just open the .odb file, click on 'Tables' and stop the time until I can see the tables in the bottom subwindow. development production OO 2.0.4 5 sec1 sec OO 2.2.1 4 min, 15 sec 27 sec Let me know if you need more info. - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 73245] Base 2.1 odbc access to as /400 slower than in 2.0.4 (one SQLTables/SQLCo lumns call for *every* table)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73245 User fs changed the following: What|Old value |New value Ever confirmed| |1 Status|UNCONFIRMED |NEW Summary|Base 2.1 odbc access to as|Base 2.1 odbc access to as |/400 slower than in 2.0.4 |/400 slower than in 2.0.4 | |(one SQLTables/SQLColumns | |call for *every* table) --- Additional comments from [EMAIL PROTECTED] Tue Sep 11 20:20:31 + 2007 --- Okay, seems we do an SQLColumn for every table in the database, right? (You mention three logical files, but the logs suggests there are tables named AGDBPRL0, AGDBPRL1, AGDBPRL2 and AGDBPR.) Besides this, it seems we do a SQLTablesW for each and every table in the DB, followed by an SQLColumnsW. I don't know which of those is worse, but can easily imagine that this adds to quite some time when the number of tables increases. Tilman, just to get an impression how this adds in your particular scenario: do you have numbers to quantify the much slower than before? I.e., how long does it take in 2.0.4, and how long in 2.1? - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]