[Buildroot] [PATCH] package/systemd: needs glibc
Arnout Vandecappelle
arnout at mind.be
Tue Nov 27 21:20:37 UTC 2018
On 23/11/2018 09:27, Thomas Petazzoni wrote:
[snip]
> mysql> select * from (select * from results where builddate > '2018-09-01') as foo inner join symbol_per_result on symbol_per_result.result_id=foo.id where symbol_per_result.symbol_id=(select id from config_symbol where name="BR2_INIT_SYSTEMD" and value="y");
[snip]
> If anybody knows how to speed up this SQL query and/or adjust the SQL
> database schema to make it faster, it would be nice. I can provide a
> dump of the SQL database.
It's hard to predict the efficiency of SQL statements, but I would expect
something like this to be more efficient:
select * from results
inner join (select result_id from symbol_per_result A, symbol_per_result B
where A.result_id = B.result_id
and A.symbol_id = (select id from config_symbol
where name = "BR2_INIT_SYSTEMD")
and A.value = "y"
and B.symbol_id = (select id from config_symbol
where name = "BR2_TOOLCHAIN_USES_UCLIBC")
and B.value = "y")
as foo
on foo.result_id = results.id
where builddate > '2018-09-01';
I do assume that symbol_per_result is indexed or keyed on symbol_id so lookups
are fast, right?
The filtering on builddate could of course be made a lot faster if the
builddate was also added to the symbol_per_result table. But the again, you
could add all of results to the symbol_per_result table...
Regards,
Arnout
More information about the buildroot
mailing list