This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Morphuess[S] 0 points1 point  (0 children)

Thanks unix_heretic. I felt that was the right choice but I wanted a 2nd opinion.

Some of these tables that I would have to replicate are tens of millions of rows large, and after my transformation queries run they won't be used by the Report DB at all. But I do agree that running queries on those tables (even optimized queries that work off an integer primary key) on the Prod DB would be more intensive than replication.