Data Structure Speed Question

[Grant_Stead]

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.

[Aleksi]

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

[Grant_Stead]

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

[Aleksi]

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