Sergey sergey-chechaev

mkdir /opt/arm64 && cd /opt/arm64 
git clone https://github.com/aerokube/images
cd images/selenium/base

Put Dockerfile.base to this directory. For building image, you need to set your hub.docker.com account and name for the image

If you create this built on Silicon M1 you need to use flag platform linux/amd64

export DOCKER_CLI_EXPERIMENTAL=enabled

docker buildx version

Готовый образ под M1 selenoid dumbdumbych/selenium_vnc_chrome_arm64:91.0.b

docker pull dumbdumbych/selenium_vnc_chrome_arm64:91.0.b

	Benchmarking Preload with select...
	Benchmarking Preload without select...

	Memory usage statistics:

	Name average deviation median 99th %
	Preload with select 39.28 KB ±0.12% 39.30 KB 39.30 KB
	Preload without select 89.21 KB ±0.09% 89.22 KB 89.23 KB

	Comparison:

	def list_user_posts_select(user_id) do
	Post
	\|> where([p], p.user_id == ^user_id)
	\|> join(
	:inner,
	[post],
	user in User,
	on: user.id == post.user_id and is_nil(user.deleted_at) == true and
	is_nil(user.blocked_at) == true
	)

	def list_user_posts(user_id) do
	Post
	\|> where([p], p.user_id == ^user_id)
	\|> preload(post_photos: ^from(p in PostPhoto, order_by: p.position))
	end

	def list_user_posts(user_id) do
	Post
	\|> where([p], p.user_id == ^user_id)
	\|> join(
	:inner,
	[post],
	user in User,
	on: user.id == post.user_id and is_nil(user.deleted_at) == true and
	is_nil(user.blocked_at) == true
	)

	Benchee.run(%{
	"Preload 1 query sync" => fn -> one_query \|> Repo.all(in_parallel: false) end,
	"Preload 1 query async" => fn -> one_query \|> Repo.all(in_parallel: true) end,
	"Preload 5 query async" => fn -> five_query \|> Repo.all(in_parallel: true) end,
	"Preload 5 query sync" => fn -> five_query \|> Repo.all(in_parallel: false) end
	}, time: 10, memory_time: 2, warmup: 5)


	Name ips average deviation median 99th %
	Preload 5 query async 191.25 5.23 ms ±25.81% 4.96 ms 10.02 ms

	def list_user_posts(user_id) do
	Post
	\|> distinct(true)
	\|> where([p], p.user_id == ^user_id)
	\|> join(:left, [p], d in assoc(p, :user))
	\|> join(:left, [_p, d], co in assoc(d, :country))
	\|> join(:left, [_p, d], ci in assoc(d, :city))
	\|> join(:left, [p, _d], ph in assoc(p, :post_photos))
	\|> preload([_p, d, co, ci, ph], user: {d, country: co, city: ci}, post_photos: ph)
	end