user9990110 wrote:How do I ask a question on the forums?
I have 2 huge tables, Bookmark and ExistingURLS, both of which have a nodeid column, the nodeids being effectively all my valid urls in the system.
The ExistingURLS table is not maintained absolutely uptodate, but reasonably so. At nightly intervals, I first update ExistingURLS with deltas, removing and adding appropriate columns for nodeid's that are still extant.
Then, I want to make a difference query between the Bookmarks and the ExistingURLS, where the bookmarks are all the nodeids that each user has bookmarked.
I want to get all the existing bookmark rows which have a nodeid NOT in the ExistingURLS table at that moment. I could do this in two queries and create a list, but that would be way to big. Is there one query that can return the row ids of the bookmark rows whose nodeid is no longer valid, obviously taking no query params? What would the indices be on each table for this query?