You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@druid.apache.org by GitBox <gi...@apache.org> on 2020/02/01 02:26:37 UTC
[GitHub] [druid] ccaominh commented on issue #9278: Speed up joins on
indexed tables with string keys
ccaominh commented on issue #9278: Speed up joins on indexed tables with string keys
URL: https://github.com/apache/druid/pull/9278#issuecomment-580981349
Benchmark numbers with the improved cache implementation:
#### Original
```
Benchmark (columnCacheSizeBytes) Score Error Units
joinIndexedTableStringKey 0 42.339 ± 0.323 ms/op
joinIndexedTableStringKey 16384 22.634 ± 0.247 ms/op
joinIndexedTableStringKeyWithFilter 0 38.170 ± 0.268 ms/op
joinIndexedTableStringKeyWithFilter 16384 24.974 ± 0.462 ms/op
lookupVirtualColumnStringKey 0 4.040 ± 0.042 ms/op
lookupVirtualColumnStringKey 16384 3.194 ± 0.011 ms/op
lookupVirtualColumnStringKeyWithFilter 0 5.288 ± 0.027 ms/op
lookupVirtualColumnStringKeyWithFilter 16384 5.175 ± 0.042 ms/op
```
#### Int2IntListLruCache
```
Benchmark (columnCacheSizeBytes) Score Error Units
joinIndexedTableStringKey 0 14.557 ± 0.151 ms/op
joinIndexedTableStringKey 16384 15.167 ± 0.075 ms/op
joinIndexedTableStringKeyWithFilter 0 16.093 ± 0.517 ms/op
joinIndexedTableStringKeyWithFilter 16384 16.434 ± 0.185 ms/op
```
#### Int2IntListLookupTable
```
Benchmark (columnCacheSizeBytes) Score Error Units
joinIndexedTableStringKey 0 12.759 ± 0.125 ms/op
joinIndexedTableStringKey 16384 12.439 ± 0.481 ms/op
joinIndexedTableStringKeyWithFilter 0 14.139 ± 0.127 ms/op
joinIndexedTableStringKeyWithFilter 16384 14.163 ± 0.176 ms/op
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org