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

Convert to AJAX DataTable content for accounts/by_host #121

Open
grutz opened this issue Jul 30, 2014 · 0 comments
Open

Convert to AJAX DataTable content for accounts/by_host #121

grutz opened this issue Jul 30, 2014 · 0 comments
Assignees
Milestone

Comments

@grutz
Copy link
Contributor

grutz commented Jul 30, 2014

When DataTables content get too big it takes too long for full results to process or appear on the screen. Overall tables SHOULD come from a RESTful-like source with limits and offsets.

Lets start with a typically overloaded t_accounts. accounts/by_host.json may take more than 3 minutes to return after loading 30,000+ records. This is probably because the query join is too much to handle..

https://github.com/KvasirSecurity/Kvasir/blob/master/controllers/accounts.py#L546

db(query).select(db.t_accounts.ALL, db.t_services.ALL, left=db.t_services.on(db.t_accounts.f_services_id==db.t_services.id))

Two things may help: first is AJAX with limit/offset, the second is a better query.

@grutz grutz added this to the 1.1.0 milestone Jul 30, 2014
@grutz grutz self-assigned this Jul 30, 2014
@grutz grutz modified the milestones: 1.1.0, 1.1.1 Aug 16, 2014
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant