Viewing 4 posts - 1 through 5 (of 5 total)
There is an interesting mention about NOLOCK in
https://learn.microsoft.com/en-us/power-apps/developer/data-platform/dataverse-sql-query
Don't use NOLOCK When building queries, don't use the table hint NOLOCK. This hint prevents Dataverse from optimizing queries.
So, don't use...
December 13, 2024 at 5:42 pm
1,000 units a minute is only 17 per second. I’ve managed systems with 50,000 transactions per second on a four-core CPU with 64 GB RAM. NOLOCK has no place...
December 13, 2024 at 12:10 pm
Randolf - He he aren’t you the clever one 😉 but my example was just plucked out of the air and nothing at all to do with system throughput. The...
December 10, 2024 at 11:44 am
Good use of common sense. Ignore the obvious comments from people who don’t understand the needs of say a live, production reporting system where 1000 units a minute can be...
December 9, 2024 at 11:22 am
Viewing 4 posts - 1 through 5 (of 5 total)