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

Need to make data fetch more efficient #76

Closed
danielsuo opened this issue Jun 8, 2014 · 3 comments
Closed

Need to make data fetch more efficient #76

danielsuo opened this issue Jun 8, 2014 · 3 comments

Comments

@danielsuo
Copy link
Member

It's getting really slow. One month of LAC data is ~1.9mb. This should be more like 20kb.

  • changing the request format; there's a lot of overhead here (currently wide format)
  • lazy-loading only x amount of data before displaying
@suo suo self-assigned this Jun 20, 2014
@suo
Copy link
Contributor

suo commented Jun 23, 2014

week/month view has sped up the data download to basically negligible speed, but a request spends 99% of its lifetime (currently ~2.5s) waiting, which means that our server is fetching from the database inefficiently. I will deal with this next.

@danielsuo
Copy link
Member Author

It's still grabbing all data before slicing down and transferring to client right? This might be the issue.

On Jun 23, 2014, at 12:57 AM, michaelsuo notifications@github.com wrote:

week/month view has sped up the data download to basically negligible speed, but a request spends 99% of its lifetime (currently ~2.5s) waiting, which means that our server is fetching from the database inefficiently. I will deal with this next.


Reply to this email directly or view it on GitHub.

@suo
Copy link
Contributor

suo commented Jun 23, 2014

Yes exactly. I just have to learn how to use sequelize mer

On Mon, Jun 23, 2014 at 8:35 AM, Daniel Suo notifications@github.com
wrote:

It's still grabbing all data before slicing down and transferring to client right? This might be the issue.

On Jun 23, 2014, at 12:57 AM, michaelsuo notifications@github.com wrote:

week/month view has sped up the data download to basically negligible speed, but a request spends 99% of its lifetime (currently ~2.5s) waiting, which means that our server is fetching from the database inefficiently. I will deal with this next.

Reply to this email directly or view it on GitHub.

Reply to this email directly or view it on GitHub:
#76 (comment)

@suo suo removed their assignment Jul 24, 2015
@suo suo closed this as completed Jul 24, 2015
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

2 participants