Data Structure Speed Question

I’m using Azure SQL DB.
I have 10 clients with 10,000 records each…
What is faster…

  1. All records in one table and a simple security filter to separate so each client only sees their portion.
  2. Each client has their own table and utilize database partitioning to select the table by client.

Good question… I would say option #2 because of 1 to 1 connection from SQL to device without filtering.

1 Like

That’s what I was thinking.
Have your experienced this? Or do you have any other advice regarding SQL and meeting things fast…

Haven’t tested in this way… it’s quite difficult to say which one is better if you don’t test it with exactly the same app structure. I would say… with strong feeling :slight_smile:

1 Like