# Best practice for multilang website with multiple database tables

**URL:** <https://discuss.elastic.co/t/best-practice-for-multilang-website-with-multiple-database-tables/118673>\
**Category:** Elasticsearch\
**Created:** [February 6, 2018, 3:39pm UTC](https://discuss.elastic.co/t/best-practice-for-multilang-website-with-multiple-database-tables/118673 "2018-02-06T15:39:17Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![andreknieriem](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/andreknieriem/32/27422_2.png) [@andreknieriem](https://discuss.elastic.co/u/andreknieriem)\
**Post date:** [February 6, 2018, 3:39pm UTC](https://discuss.elastic.co/t/best-practice-for-multilang-website-with-multiple-database-tables/118673/1 "2018-02-06T15:39:17Z")

</div>

Hi there,  
I am new to the new elasticsearch version. My first try with elasticsearch was with version 2.x. Now I want to have a search for my multilang website with many tables I want to index. My idea was to create an index per language and add a type for each record type in my database. With version 6, it is saying, that this is not the best practice. Now my question is, what is the best practice?

The search should work like this:  
I am on the page and search something, I only want results in my language from all "tables".

The new idea was that I create as many indexes as I have records and languages, but I thinkt thats overkill.  
For example user\_en, user\_de, product\_en, product\_de and so on.

Maybe some of you can give me an good advice how to handle things like this.

Best regard

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [February 6, 2018, 4:03pm UTC](https://discuss.elastic.co/t/best-practice-for-multilang-website-with-multiple-database-tables/118673/2 "2018-02-06T16:03:25Z")

</div>

Did you see [https://www.elastic.co/guide/en/elasticsearch/guide/current/language-intro.html](https://www.elastic.co/guide/en/elasticsearch/guide/current/language-intro.html)?

It contains important informations about this.  
That might help.

---

<div class="post-metadata">

**Author:** ![andreknieriem](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/andreknieriem/32/27422_2.png) [@andreknieriem](https://discuss.elastic.co/u/andreknieriem)\
**Post date:** [February 7, 2018, 8:37am UTC](https://discuss.elastic.co/t/best-practice-for-multilang-website-with-multiple-database-tables/118673/3 "2018-02-07T08:37:35Z")

</div>

Thanks for the hint, I've not seen that. I will come back here, if any questions are left.

---

<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:** [March 7, 2018, 8:37am UTC](https://discuss.elastic.co/t/best-practice-for-multilang-website-with-multiple-database-tables/118673/4 "2018-03-07T08:37:43Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.