64.1 - Time to update a query, pure M
I tried repeating video 64, this time using only M/Power Query to time how long it takes to update a query.
After many tries, I eventually gave up.
I tried physically printing a time stamp inside a row, that didn't work.
Table.Buffer showed some promise, but that's expensive
I tried DateTime.FixedLocalNow() but I don't trust it.
Ben Gribaudo, how tables think (tables are references, those references are immutable but the actual tables can change9
https://bengribaudo.com/blog/2019/12/...
Chris Webb, timing queries part 1
https://blog.crossjoin.co.uk/2014/11/...
Chris Webb, timing queries part 2
https://blog.crossjoin.co.uk/2016/04/...
00:25 Adding a time-stamp as a row in a table
02:30 Maybe Table.Buffer works?
02:50 Adding the time difference as meta-data
03:36 FixedLocalNow()
05:38 Do you actually need to time a query?
Смотрите видео 64.1 - Time to update a query, pure M онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь WesleySon 19 Май 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 43 раз и оно понравилось 1 людям.