Ciro Santilli $$ Sponsor Ciro $$ 中国独裁统治 China Dictatorship 新疆改造中心、六四事件、法轮功、郝海东、709大抓捕、2015巴拿马文件 邓家贵、低端人口、西藏骚乱
Issue report at: github.com/cirosantilli/ourbigbook/issues/198 Suppose you had:
programming-language.ciro
= Programming language

\Image[https://raw.githubusercontent.com/cirosantilli/media/master/python-logo.jpg]
{title=The \x[python-programming-language] logo}

== Python
{c}
{disambiguate=programming-language}
logos-i-like.ciro
= Logos I like

\x[image-the-python-logo]
Now, when rendering \x[image-the-python-logo], we would need to fetch two IDs:
  • image-the-python-logo for the The and logo part
  • python-programming-language itself, to know that \x[python-programming-language] should render as Python
But after group all SQL queries together was done, there was no way to know that rendering image-the-python-logo would imply also fetching python-programming-language.
This was solved by adding a new database entry type, REFS_TABLE_X_TITLE_TITLE to the existing References table, which tracks dependencies between IDs.
After this was setup, we can now know that image-the-python-logo depends on image-the-python-logo, and then fetch both of them together in a single JOIN.

Ancestors