Hi @neorobot

These are all some pretty loaded questions that are hard to give simple answers to as each and every project requirements are going to be different 😉

What kind of structure do you use ? (all movies in the same table ? Seperate table according the langage ?)

TMDb is actually a MongoDB project, so there aren't tables per-say. Each media type or object is generally in their own collection (which is basically the equivalent to a table in the MySQL world).

i'm using mysql, what kind of DB would you recommend ? InnoDB ? MyISAM ? others ?

My understanding is that InnoDB is a good choice. I do use MySQL for the new lists and use InnoDB for them.

indexing is enough to have a "fast search" in a so huge DB ?

This is going to be purely based on your use case(s) and schema. I store a lot of things in Elasticsearch--not to necessarily get more performance but rather, a more dynamic and powerful querying system.

Thank you for your Answer Travis, I'll check that !