Difference between revisions of "Base/Performance"
From Apache OpenOffice Wiki
< Base
(→Row Fetching) |
(→Test Cases) |
||
| Line 16: | Line 16: | ||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
| − | ! Test Case !! Source Database !! Destination Database | + | ! Nr || Test Case !! Source Database !! Destination Database |
|- | |- | ||
| + | | 1. | ||
| Jump to last row (65514 rows x 21 columns) | | Jump to last row (65514 rows x 21 columns) | ||
| Flat (csv) | | Flat (csv) | ||
| Flat (csv) | | Flat (csv) | ||
|- | |- | ||
| + | | 2. | ||
| Jump to last row (20000 rows x 11 columns) | | Jump to last row (20000 rows x 11 columns) | ||
| MySQL (JDBC) | | MySQL (JDBC) | ||
| MySQL (JDBC) | | MySQL (JDBC) | ||
|- | |- | ||
| + | | 3. | ||
| Open a spreadsheet file with one table (65514 rows x 21 columns) | | Open a spreadsheet file with one table (65514 rows x 21 columns) | ||
| Spreadsheet | | Spreadsheet | ||
| Spreadsheet | | Spreadsheet | ||
|- | |- | ||
| + | | 4. | ||
| Jump to last row (65514 rows x 21 columns) | | Jump to last row (65514 rows x 21 columns) | ||
| Spreadsheet | | Spreadsheet | ||
| Spreadsheet | | Spreadsheet | ||
|- | |- | ||
| + | | 5. | ||
| Copy a table (13000 rows x 19 columns) | | Copy a table (13000 rows x 19 columns) | ||
| HsqlDB (native) | | HsqlDB (native) | ||
| HsqlDB (native) | | HsqlDB (native) | ||
|- | |- | ||
| + | | 6. | ||
| Copy a table (13000 rows x 19 columns) | | Copy a table (13000 rows x 19 columns) | ||
| Spreadsheet | | Spreadsheet | ||
| HsqlDB (native) | | HsqlDB (native) | ||
|} | |} | ||
| + | === Test Results === | ||
| + | First results which could be achieved so far (less is better): | ||
| + | * Test Case 1 | ||
| + | [[Image:Base_TestCase_1.gif]] | ||
| + | * Test Case 2 | ||
| + | [[Image:Base_TestCase_2.gif]] | ||
| + | * Test Case 3 | ||
| + | [[Image:Base_TestCase_3.gif]] | ||
| + | * Test Case 4 | ||
| + | [[Image:Base_TestCase_4.gif]] | ||
| + | * Test Case 5 | ||
| + | [[Image:Base_TestCase_5.gif]] | ||
| + | * Test Case 6 | ||
| + | [[Image:Base_TestCase_6.gif]] | ||
| + | |||
[[Category:Performance]] | [[Category:Performance]] | ||
Revision as of 10:59, 25 February 2009
Performance
This page contains all thought and ideas we have around performance.
General
At the moment, this is just a basket to hold items I needed to remove from other pages. On the medium term, this is to be the central entry point for performance considerations in Base.
- opening forms
- starting the Java-based wizards
- creating a new HSQLDB (which implies starting the JVM)
- saving a form
- flickering when starting the New Database wizard from within the start center
Row Fetching
We currently evaluate how row fetching can be accelerated. Fetching thousands of rows isn't as fast as it could be.
Test Cases
| Nr | Test Case | Source Database | Destination Database |
|---|---|---|---|
| 1. | Jump to last row (65514 rows x 21 columns) | Flat (csv) | Flat (csv) |
| 2. | Jump to last row (20000 rows x 11 columns) | MySQL (JDBC) | MySQL (JDBC) |
| 3. | Open a spreadsheet file with one table (65514 rows x 21 columns) | Spreadsheet | Spreadsheet |
| 4. | Jump to last row (65514 rows x 21 columns) | Spreadsheet | Spreadsheet |
| 5. | Copy a table (13000 rows x 19 columns) | HsqlDB (native) | HsqlDB (native) |
| 6. | Copy a table (13000 rows x 19 columns) | Spreadsheet | HsqlDB (native) |
Test Results
First results which could be achieved so far (less is better):
- Test Case 1
- Test Case 2
- Test Case 3
- Test Case 4
- Test Case 5
- Test Case 6
