Quote:
Originally Posted by Terisa de morgan
Dalton, I have a question. If we weren't taking into account 100000 books (I think performance is the issue but I can be wrong), could we use directly MCS with inter book search, something like: - Left Side: authors <> authors
- Right side: #author_id = #author_id
Because I perhaps can use it in another kind of searches. |
Terisa,
My comment to Tanjamuse that "let me first say that this is worth doing only because you have 100,000 books..." was a recognition of the time and effort that the solution would take a non-technical person to find, install, learn and use the SQLite tool to implement it. The solution then becomes cost-effective for them only when a manual solution becomes impractical due to library size.
For a person who already has the requisite knowledge and skillset, it is cost-effective from the start.
MCS Inter-Book queries require the "=" operator on both sides, so it cannot derive the correct answer to this problem. See the attached image showing the results, and then compare that to the image in my prior post showing the correct results for Tanjamuse's scenario using an MCS Raw SQL query.
DaltonST