[MCOL-636] Performance improvement with string handling Created: 2017-03-24 Updated: 2017-12-01 Resolved: 2017-09-05 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 1.1.0 |
| Type: | New Feature | Priority: | Minor |
| Reporter: | Andrew Hutchings (Inactive) | Assignee: | Daniel Lee (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Sprint: | 2017-14, 2017-15, 2017-16, 2017-17, 2017-18 |
| Description |
|
With the blob feature I left a marker in ha_calpont_impl.cpp:470 to note that we are doing string copies where just using the pointer will do. There may be other places where we might be doing this too. |
| Comments |
| Comment by Andrew Hutchings (Inactive) [ 2017-07-18 ] |
|
Pull request for 1.1 open. For QA... I guess just make sure it doesn't break anything. Regression suite ran fine in my tests. VARCHAR/CHAR return performance between the plugin and MariaDB should be a little better. |
| Comment by Daniel Lee (Inactive) [ 2017-09-05 ] |
|
Build verified: 1.1.0 Github source /root/columnstore/mariadb-columnstore-server /root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine Not noticeable timing difference. On a 10g dbt3 database, I ran: select max(l_comment) from lineitem: 1.0.10-1: 12.41 sec |