csharpfritz / CoreWiki

A simple ASP.NET Core wiki that we are working on during live coding streams
MIT License
417 stars 157 forks source link

Use CQRS Pattern #15

Open IvandroFabiaeFilhos opened 6 years ago

IvandroFabiaeFilhos commented 6 years ago

CoreWiki, seems to be simple to 10 users.

Now, let's imagine to 300mil users concurrents:

200.000 Queries concurrents (features search, track changes, article ratings 50.000 Updates concurrents (update comments, update images, update article ratings) 50.000 Inserts concurrents (add comments, add images, add article ratings)

My suggestions is:

  1. To explorer the CQRS Pattern
  2. Use an docker container to ( Queries)
  3. Use an docker container to ( Update, Delete, Insert)

OBS: See, I first think to change the database platform to SQL Server 2017. And both docker containers connected in another docker container with SQL Server 2017.

@csharpfritz, What do you think about that?

csharpfritz commented 6 years ago

This is a great idea, and I am going to keep a good separation between user interface and business logic concerns so that we can adapt to this architecture once the base functionality is completed.

This is intended as a learning project, and I think this would be a good lesson.

Thanks for the suggestion. I'm going to mark this as an enhancement and we'll revisit soon.