Make logs fields indexed

Created on 21 June 2023, over 1 year ago
Updated 22 June 2023, over 1 year ago

Problem/Motivation

During fetching logs i have to load logs which are unread only, i'm doing it many times during script. But problem is "read" field is not indexed and each query takes lot of time with 500K rows inside.

Steps to reproduce

Generate 500K logs and try to fetch some logs with DB query (my current time to fetch unread logs takes ~0.8 sec.)

Proposed resolution

Make this indexed

Data model changes

Need to change Log entity by adding indexed keys.

📌 Task
Status

Needs review

Version

1.0

Component

Code

Created by

🇷🇺Russia YurkinPark

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Production build 0.71.5 2024