Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Arcticdb reads can be slow when reading many columns #1963

Open
G-D-Petrov opened this issue Oct 30, 2024 · 0 comments · May be fixed by #1964
Open

Arcticdb reads can be slow when reading many columns #1963

G-D-Petrov opened this issue Oct 30, 2024 · 0 comments · May be fixed by #1964
Assignees
Labels
bug Something isn't working

Comments

@G-D-Petrov
Copy link
Collaborator

Describe the bug

At the moment the post processing step of read scales linearly with the number of columns.
This is caused by the calls to make_block and when we have many columns(150k+) it is taking about half of the time of the total read.

Steps/Code to Reproduce

import pandas as pd
import numpy as np
from arcticdb import Arctic
import cProfile

N = 175000
df = pd.DataFrame(np.random.randn(1, N), columns=[f"col_{i}" for i in range(N)])

ac = Arctic("lmdb://test_wide_df?map_size=5GB")
lib = ac.get_library("test_wide_df", create_if_missing=True)
lib.write("test_wide_df", df)

cProfile.run("lib.read('test_wide_df')")

Expected Results

The post processing step should take too much time

OS, Python Version and ArcticDB Version

Python 3.10

Backend storage used

LMDB

Additional Context

No response

@G-D-Petrov G-D-Petrov added the bug Something isn't working label Oct 30, 2024
@G-D-Petrov G-D-Petrov self-assigned this Oct 30, 2024
@G-D-Petrov G-D-Petrov linked a pull request Oct 30, 2024 that will close this issue
5 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants