Database scalability. Yay or Nay?

mikke · 2020-10-06T15:07:46.098Z

Hi,
I am building an enterprise app. Much like a CRM system.

I am 6 month into the build now and I think that I actually can make something with this venture. Here is my concern.

I’ve been learning as I go and I am a bit concern with my database and how I’ve designed the UI with heavy searches to view data.

One example: A user can invite a new user to get referral points. When they do I need to check if the user already exist as a customer, or is already invited by someone else.

See attached picture, I think that you bubblers will understand. To my question. Then I have 10 000 users (hopefully ), how will this query perform? Right now it’s all instant.

image719×453 65.9 KB

deadpoetnsp · 2020-10-06T15:19:07.962Z

I (currently) have 5000 notifications, and Do a search for a User’s notifications is instantaneous

mikke · 2020-10-06T17:22:28.669Z

Thanks mate. Now I can go to bed tonight and have a good nights sleep.