Where are the related questions stored in the database?

Question

Hi, I am searching the related answers in the database but canot find them.

I have hundred thousands of questions imported and the recalculating of the related questions (reindexing) takes some days. So I have another idea to calculate them but I cant find them in the database so I don't know where to insert my own calculated related questions.

Can you help me?

Thanks Fabian

Comments

Do you know qa_suspend_*() functions? These functions are used when processing large amounts of data in own importig program.
Reference:
http://www.question2answer.org/functions.php

Answer 1

There is no overhead in the post recalculations regarding related questions as there is no ad hoc structure to hold them.

In fact, they are just dynamically calculated when they are displayed in the widget. The logic uses a score assigned to each question and the score determines how much a question matches a given question. Then the questions with the higher score are displayed.

If you are interested in how the score is assigned you can take a look at the qa_db_related_qs_selectspec function. You'll see the score involves matching words in question titles, tags and categories.

So I wouldn't advise you to go deep in there to decrease post reindexing times.

Comments

Thank you for your answer now I understand a little bit more the function of related posts.