Recherche avancée

Sur d’autres sites (11995)

• Evolution #3916 : perf mysql : ne pas surcharger les recherches

  8 janvier 2018, par jluc -

  Le patch proposé se veut respectueux au maximum de l’historique, puisque le comportement final est toujours identique, et pour cela il garde la recherche de l’expression complète quand il y a des petits mots. Mais pour éviter les slow queries, j’ai dû en fait totalement désactiver la recherche de l’expression complète, même quand il y a des petits mots. Les résultats sont les mêmes puisque si on cherche chacun des mots individuellement, qu’il y ait ou non des petits mots, l’expression complète sera trouvée. Et ça se confirme en pratique. Par contre, s’il n’y a QUE des petits mots, c’est la seule expression originelle qu’il faut rechercher au final.
  Ça ne serait utile de chercher l’expression complète en plus des mots isolés que si il y avait une pondération des résultats (mais ce n’est pas le cas).

• Compressing videos from a smartphone

  21 septembre 2019, par fejesjoco

  I have a Nexus 6p with the stock camera. It’s set to record at 1080p, 30fps. Here’s a 5 second sample (11 MB).

  Videos from this phone come out at about 17 Mbps on average. I tried to compress it with ffmpeg with -c:v libx264 -crf 23 -preset veryslow, the result comes out at about 5.5 MB, which is about 9 Mbps.

  I think this bitrate is a bit too much. When I look at torrent file listings, I can see high quality videos at 3 GB in size on average, and if such a movie is 90 minutes long on average, that is about 4-5 Mbps which sounds okay.

  I’m wondering, why the big difference ? I can notice that my video is noisy/grainy (which is expected from a phone), and that might reduce compressibility. I tried a few ffmpeg filters, like hqdn3d and atadenoise, but the noise mostly remained (maybe I didn’t play with it enough). Then I figured, the video is also shaky (which is also expected), and that might reduce compressibility too (and even makes temporal noise filtering less effective). I tried to stabilize it with the deshake filter, but that didn’t help either.

  I know I could just limit the bandwidth to whatever I like, but there must be a reason why ffmpeg thinks it needs a high bandwidth to maintain a certain quality, and a lower bandwidth would just decrease the quality.

  Why do these videos have such a high bitrate ? What’s the best way to compress them more while keeping or even increasing their quality ?

• Compressing videos from a smartphone

  9 novembre 2016, par fejesjoco

  I have a Nexus 6p with the stock camera. It’s set to record at 1080p, 30fps. Here’s a 5 second sample (11 MB).

  Videos from this phone come out at about 17 Mbps on average. I tried to compress it with ffmpeg with -c:v libx264 -crf 23 -preset veryslow, the result comes out at about 5.5 MB, which is about 9 Mbps.

  I think this bitrate is a bit too much. When I look at torrent file listings, I can see high quality videos at 3 GB in size on average, and if such a movie is 90 minutes long on average, that is about 4-5 Mbps which sounds okay.

  I’m wondering, why the big difference ? I can notice that my video is noisy/grainy (which is expected from a phone), and that might reduce compressibility. I tried a few ffmpeg filters, like hqdn3d and atadenoise, but the noise mostly remained (maybe I didn’t play with it enough). Then I figured, the video is also shaky (which is also expected), and that might reduce compressibility too (and even makes temporal noise filtering less effective). I tried to stabilize it with the deshake filter, but that didn’t help either.

  I know I could just limit the bandwidth to whatever I like, but there must be a reason why ffmpeg thinks it needs a high bandwidth to maintain a certain quality, and a lower bandwidth would just decrease the quality.

  Why do these videos have such a high bitrate ? What’s the best way to compress them more while keeping or even increasing their quality ?