[dba-issues] [Issue 76606] Performance problen - "pas ting" 65000x20 table from Calc to Base takes h ours on 2.4GHz Pentium4
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76606 --- Additional comments from [EMAIL PROTECTED] Mon Apr 30 05:25:25 + 2007 --- Yes, all my test runs had included creating a primary key field. Looking at your times does seem to show that removing the system clipboard from the equation makes quite a difference. But it is hardly the only factor to be considered. Here is another test run - on the same machine, but a new software configuration. Two differences only - First I changed OOo to use JRE 1.5.0_11 instead of 1.6.0 as the other night, second in getting ready for some contract work I shutdown the MySQL server and fired up an Oracle 10g server on this machine. I preformed the same record import test as before using 2.3 M_210, and with no primary key being added, for this run my time was horrendous: 54 Minutes 20 Seconds. OK - how many people are really going to have an Oracle server running on their workstation - not many. So we can probably just toss this number out, but to be sure: Next I left Oracle running and changed OOo to use JRE 1.6 again. Started the transfer again. ( Just to be clear each time the HSQL embedded database is empty ) - I killed the process after 20 minutes. So - I shutdown everything Oracle service ( server, recovery, agent, listener ). I left OOo using JRE 1.6 and I performed the transfer one more time, again no primary key. Run time: 4 minutes 06 seconds Finally - for the last test I changed OOo back to use JRE 1.5.0_11. Run time 5 Minutes 28 Seconds. All the test runs where with 2.3m_210 - 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 76606] Performance problen - "pas ting" 65000x20 table from Calc to Base takes h ours on 2.4GHz Pentium4
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76606 User kpalagin changed the following: What|Old value |New value CC|'clu' |'atjensen,clu' --- Additional comments from [EMAIL PROTECTED] Sun Apr 29 06:07:57 + 2007 --- I have tried m210 and it is roughly the same. I have discovered that if I do not enable primary key creation then import finishes almost 4 times faster: 2.2 no PK - 1m40s 2.2 with PK - 6m (competitive analisys - Office 2003 takes 45s) atjensen, please make sure that you have timed copy with PK creation. - 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 76606] Performance problen - "pas ting" 65000x20 table from Calc to Base takes h ours on 2.4GHz Pentium4
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76606 --- Additional comments from [EMAIL PROTECTED] Fri Apr 27 06:09:41 + 2007 --- I thought others might want to check out the performance on their machines so I saved the spreadsheet to a csv file and zipped for attachment here. - 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 76606] Performance problen - "pas ting" 65000x20 table from Calc to Base takes h ours on 2.4GHz Pentium4
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76606 User atjensen changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |44723) Data as csv file --- Additional comments from [EMAIL PROTECTED] Fri Apr 27 06:08:27 + 2007 --- Created an attachment (id=44723) Data as csv file - 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 76606] Performance problen - "pas ting" 65000x20 table from Calc to Base takes h ours on 2.4GHz Pentium4
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76606 --- Additional comments from [EMAIL PROTECTED] Fri Apr 27 05:19:46 + 2007 --- This deserves an update. I preformed the same steps tonight as I did the other night, bringing the calc data into an embedded Base database - My machine was running just about the same mix as the other night also but using 2.3m_210 Time to import data dropped to 10 min 2 seconds. Another BIG difference - system responsiveness. The CPU is still pegged during the transfer BUT OOo is offering up clock cycles much, much more often now. I could work with the other applications almost as if the process was not screaming along. Someone put the word 'Cooperative' into Base on Windows it seems :>) It also appeared that total memory used by the soffice.bin process was less then on 2.2, but I will need to run a few more tests before I can say for sure. - 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 76606] Performance problen - "pas ting" 65000x20 table from Calc to Base takes h ours on 2.4GHz Pentium4
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76606 --- Additional comments from [EMAIL PROTECTED] Wed Apr 25 08:09:10 + 2007 --- You might want to separate two things here - The clipboard and importing to base. I did the following: Created a Calc file with 65,515 rows of 21 columns. Mixed data: decimal, date, strings. Created a Base file that connected to this Calc file. Created a new embedded database Base file. Dragged the table Sheet1 from the first Base file to the second Base file. The import is not speedy but it finished in just under 18 minutes. This is on an HP 810n ( AMD 3300, 640 Meg Ram ), WinXP Sp2 and a good mix of other applications running at the time. Firefox ( 4 windows, 5 tabs in one - gmail, Issue trakcker ( 2 tabs), OOoForum, local file ), 2 cmd windows, HSQLdb running as server, MySQL 5 running, iTunes playing music from an internet feed. Total of 11 open documents ( 4 base files, 2 forms, 5 query data views ) in OOo. The PC was sluggish but I was still able to work in Firefox entering 2 posts at the forum without too much discomfort at all...and the music never stopped playing :>) - 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 76606] Performance problen - "pas ting" 65000x20 table from Calc to Base takes h ours on 2.4GHz Pentium4
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76606 User clu changed the following: What|Old value |New value CC|''|'clu' Assigned to|dbaneedsconfirm |fs --- Additional comments from [EMAIL PROTECTED] Tue Apr 24 15:42:11 + 2007 --- tested on test pc p1800 (512mb ram) => two crashes (one of them after more than a hour) clu->fs: what is an appropriate time for 65000 datasets? - 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 76606] Performance problen - "pas ting" 65000x20 table from Calc to Base takes h ours on 2.4GHz Pentium4
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76606 --- Additional comments from [EMAIL PROTECTED] Mon Apr 23 09:19:52 + 2007 --- P.S. Import is completely CPU-bound - I see 100% CPU utilization during import. - 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 76606] Performance problen - "pas ting" 65000x20 table from Calc to Base takes h ours on 2.4GHz Pentium4
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76606 Issue #|76606 Summary|Performance problen - "pasting" 65000x20 table from Ca |lc to Base takes hours on 2.4GHz Pentium4 Component|Database access Version|OOo 2.2 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|kpalagin --- Additional comments from [EMAIL PROTECTED] Mon Apr 23 09:00:03 + 2007 --- Subject says it all. Repro steps: 1. Select data in Calc, Edit - Copy. 2. Start Base, Create new db, click Tables, right-click - Paste. 3. In Copy table wizard click "Definition and data", "Create primary key", Next, add all columns to the right, Next, Create. I can supply .ods file (2.7MB, confidential), which contains the data to reproduce the problem. It takes 3 hours on 2.4GHz Pentium4 (1GB of RAM) to import all of the data into database. What makes the problem even worse is that Office is unusable for any other task during import and machine becomes sluggish (apparently some thread is running at high priority). - 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]