[sc-issues] [Issue 67118] extremely slow odbc/jdbc a ccess
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67118 User kohei changed the following: What|Old value |New value CC|''|'kohei' - 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]
[sc-issues] [Issue 67118] extremely slow odbc/jdbc a ccess
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67118 User fst changed the following: What|Old value |New value Assigned to|spreadsheet |nn Ever confirmed| |1 Status|UNCONFIRMED |NEW Issue type|DEFECT|ENHANCEMENT Keywords|needmoreinfo, oooqa |oooqa Target milestone|--- |OOo Later --- Additional comments from [EMAIL PROTECTED] Thu Aug 31 04:26:45 -0700 2006 --- Hi, according to Marc the QA representative for the base component, the problem seems to be in the datapilot communicating with the Dtabase. So this is one for you Niklas. Frank - 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]
[sc-issues] [Issue 67118] extremely slow odbc/jdbc a ccess
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67118 User vincentkeunen changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |38747) Access DB showcasin | |g the problem --- Additional comments from [EMAIL PROTECTED] Thu Aug 24 01:18:14 -0700 2006 --- Created an attachment (id=38747) Access DB showcasing the problem - 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]
[sc-issues] [Issue 67118] extremely slow odbc/jdbc a ccess
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67118 User fst changed the following: What|Old value |New value Keywords| |needmoreinfo, oooqa --- Additional comments from [EMAIL PROTECTED] Thu Jul 27 05:20:19 -0700 2006 --- Hi, without a sample database it's hard if not impossible to tell there the problem is located. Spreadsheet or Base. If you take the MDB and alter the data, not the structure, could you attach such a file to the Issue as a ZIP file ? If the resulting file is to big, we can use an FTP server there you can upload it. Thanks for your help. Frank - 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]
[sc-issues] [Issue 67118] extremely slow odbc/jdbc a ccess
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67118 Issue #|67118 Summary|extremely slow odbc/jdbc access Component|Spreadsheet Version|OOo 2.0.3 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|vincentkeunen --- Additional comments from [EMAIL PROTECTED] Fri Jul 7 06:05:34 -0700 2006 --- Our client (planning to migrate 1500 persons to OOo...) regularly receives from an external institution an mdb (Access) file with 70k+ entries (more than the 65k barrier). The file contains 16 columns of var (we can't send the file, it's cinfidential). They used to open that file with excel and run some "data pilot" functionalities. Excel 2003 would do that in seconds. With OOo, opening the mdb file takes more than 20 minutes... Then, after opening it, operating a popup menu of displayed fields to operate a new computation takes minutes. We tried on mac and win: same problem. We tried with jdbc (on mac) against a postgresql db (after importing the mdb data). It still takes 5 minutes (excel takes seconds only). So the problem does not seem to be the mdb format directly. We noted (by sniffing the network) that there are many "select * from..." statements, each returning the full db (70k entries)... We noted that 2.0.2 is much slower even. So some progress has been made on 2.0.3. Thanks! - 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]