termie posted to #devku:

termie

some comments being dropped from feeds now, very intense query that was slowing down all the feeds

2 months, 3 weeks ago.

8 comments so far

  • lemonad

    The public feed is up but seems stuck and ten hours behind, is that intentional?

    2 months, 3 weeks ago by lemonad.

  • malach

    I think it'll be catching up :)

    2 months, 3 weeks ago by malach.

  • CAW

    I assume this is why the JSON API is no-longer providing comments when querying our overview? Mauku is only showing new Jaikus, comments are gone now. This pretty much kills the usefulness of API clients, since the overview is 90% comments.

    2 months, 3 weeks ago by CAW.

  • FyreFiend

    Still no comments with API clients. Like CAW said, it pretty much makes clients useless

    2 months, 3 weeks ago by FyreFiend.

  • termie

    tried a few variations of the queries to try to clear this up, none have so far been able to handle the high usage users :/ will take some more work to get them back up, I might be able to put some time in on the weekend

    2 months, 3 weeks ago by termie.

  • randomfrequency

    identify high usage users and use triggers/materialzed views?

    2 months, 3 weeks ago by randomfrequency.

  • lemonad

    @termie: I accidentally clicked the "mark as spam" next to you and got a "Sorry - the page you are looking for can't be found." Perhaps that's old news, just thought I'd let you know.

    2 months, 3 weeks ago by lemonad.

  • hhedberg

    I hope the solution is found quickly! There are plenty of external client users, and I think Jaiku should be loyal for those too.

    2 months, 2 weeks ago by hhedberg.

Sign in to add a comment