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.

Sign up for GitHub

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

Jump to bottom

Speedup query time #64

Open

aruhela opened this issue Oct 3, 2024 · 0 comments

Assignees

Collaborator

aruhela commented Oct 3, 2024

There are couple of things that can be done here. Feel free to add more.

Filter out data which is least viewed or of less interests to the users.
Use Ajax instead of Python web interface
Some preprocessing of data at server end
Processing data at client end. (This might be part of 2)
New Indexing
New DB design (not required as of now)
Tuning Postgres for load sharing and scalability

aruhela self-assigned this

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment