Isaac Adewumi prettyirrelevant

sqlite index benchmark for event_metrics

comparing composite indexes from rotki PR #11464 against existing single-column indexes.

indexes

baseline (existing):

CREATE INDEX idx_event_metrics_event ON event_metrics(event_identifier);
CREATE INDEX idx_event_metrics_location_label ON event_metrics(location_label);

sqlite index benchmark for event_metrics

comparing composite indexes from rotki PR #11464 against existing single-column indexes.

indexes

baseline (existing):

CREATE INDEX idx_event_metrics_event ON event_metrics(event_identifier);
CREATE INDEX idx_event_metrics_location_label ON event_metrics(location_label);

SQLite Index Benchmark: Composite vs Single-Column

Benchmark comparing composite indexes (from rotki PR #11464) against single-column indexes for the event_metrics table.

Index Configurations

Single-Column Indexes (Baseline)

CREATE INDEX idx_em_event ON event_metrics(event_identifier);
CREATE INDEX idx_em_metric_key ON event_metrics(metric_key);

Keybase proof

I hereby claim:

I am prettyirrelevant on github.
I am isaacadewumi (https://keybase.io/isaacadewumi) on keybase.
I have a public key ASDGsfNVXfD7VEWRblNosg34ofocJlNHQKv8wgwe3zwNHQo

To claim this, I am signing this object:

Keybase proof

I hereby claim:

I am prettyirrelevant on github.
I am prettirrelevant (https://keybase.io/prettirrelevant) on keybase.
I have a public key ASABEQnY-rA-tXEkTvlki_bT2lTZhfZ9eYKktDeA4z8m4Ao

To claim this, I am signing this object:

	#!/usr/bin/env python3
	"""
	Test max token addresses for Etherscan eth_call before HTTP 414.

	Usage: python test_etherscan_url_limit.py --api-key YOUR_KEY
	Or set ETHERSCAN_API_KEY env variable.
	"""
	import argparse
	import os
	import sys

	import math
	from pathlib import Path

	import numpy as np
	from PIL import Image
	import imageio.v3 as iio
	from pillow_heif import register_heif_opener

	register_heif_opener()

	import pandas as pd
	from decimal import Decimal


	def clean_currency(value):
	"""Removes currency symbol and commas, then converts to `Decimal`."""
	if isinstance(value, Decimal):
	return value

	value = value.replace("₦", "").replace(",", "")

	import asyncio
	import json
	from typing import Any, Dict, List, Tuple

	import aiohttp
	from bs4 import BeautifulSoup


	async def main() -> None:
	async with aiohttp.ClientSession(connector=aiohttp.TCPConnector(ssl=False)) as session:

	package main

	import (
	"errors"
	"fmt"
	)

	type KeyValueSlice map[string]float64

	func main() {