Hello. I want to incorporate data from an external MySQL DB into wordpress. The reason is that the particular DB has roughly 10 million rows, and I don't want to overload the WP DB.
I can display the data quite easily using $wpdb (for example, a list of titles, as if it were a category page).
What I would like is that when clicking on any title, that the data can be pulled from the external DB and showed in the same was as a post, in a single page.
I've tried for several days but no success.
Has anyone had similar experience?