# Old design morphing into new design

**URL:** <https://discuss.elastic.co/t/old-design-morphing-into-new-design/45412>\
**Category:** Elasticsearch\
**Created:** [March 25, 2016, 4:54am UTC](https://discuss.elastic.co/t/old-design-morphing-into-new-design/45412 "2016-03-25T04:54:04Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![darrenm](https://avatars.discourse-cdn.com/v4/letter/d/d78d45/32.png) [@darrenm](https://discuss.elastic.co/u/darrenm)\
**Post date:** [March 25, 2016, 4:54am UTC](https://discuss.elastic.co/t/old-design-morphing-into-new-design/45412/1 "2016-03-25T04:54:04Z")

</div>

We are exploring options to move a portion of a legacy app into ES and ran into a situation I thought best to ask the community for help with. Again, legacy app.

This app has a rather heavy permission model with the peek user having about 1,000 assign groups they belong to. The documents indexed commonly have 1-6 groups assigned to them. There are about 30M documents and our peek user needs to filter on only the document they have access too. There are currently 120,000 groups in the system today and customers can add more if needed.

Crazy as it sounds, the legacy system in MySQL does a "select where group is in {1000 group id's}".

Suggested approaches?

---

<div class="post-metadata">

**Author:** ![darrenm](https://avatars.discourse-cdn.com/v4/letter/d/d78d45/32.png) [@darrenm](https://discuss.elastic.co/u/darrenm)\
**Post date:** [March 29, 2016, 7:01pm UTC](https://discuss.elastic.co/t/old-design-morphing-into-new-design/45412/2 "2016-03-29T19:01:24Z")

</div>

Does anyone have an example of using [Roaring Bitmap](https://www.elastic.co/blog/frame-of-reference-and-roaring-bitmaps) they can reference? I found an article but no examples to explore yet.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 5, 2017, 11:04pm UTC](https://discuss.elastic.co/t/old-design-morphing-into-new-design/45412/3 "2017-07-05T23:04:18Z")

</div>


