[Buildroot] [PATCH 1/2] package/libtirpc: fix build with gcc 10

[Thomas Petazzoni <thomas.petazzoni@bootlin.com>]

Hello Petr,

On Mon, 23 Mar 2020 20:42:37 +0100
Petr Vorel <petr.vorel@gmail.com> wrote:

> > You can search the autobuilders for successful build results, filtering
> > per config options. See http://autobuild.buildroot.net/search.php.  
> 
> > For example:  
> 
> >   http://autobuild.buildroot.net/index.php?status=OK&symbols%5BBR2_PACKAGE_LIBTIRPC%5D=y  
> 
> > will search all successful builds that had BR2_PACKAGE_LIBTIRPC enabled.  
> 
> Thanks! Not sure if it's just a slow net on my side, but search takes ages.
> Not sure whether you still maintain this web service, but adding index on column
> which stores symbols might help (suppose it uses database).

The search has indeed never been "fast", but it's true that it's
particular slow now, much slower than it was. Not sure what happened,
as nothing changed.

You can find the schema of the MySQL database at
https://git.buildroot.org/buildroot-test/tree/web/schema.sql. It does
have indexes. However, the symbol_for_result table really has (tens
of?) millions of entries.

Last summer, we had an intern at Bootlin who worked on this, and
greatly improved the performance of those queries. But it seems like
this have worsen again, for some reason. I can share a dump of the
database if anybody wants to play with it.

Best regards,

Thomas
-- 
Thomas Petazzoni, CTO, Bootlin
Embedded Linux and Kernel engineering
https://bootlin.com