Explore the pros and cons of using CQRS with either a shared database or separate databases to optimize system architecture.