youngoat (youngoat) wrote in lj_dev,
youngoat
youngoat
lj_dev

Massively converting userid's to usernames.

The getevents protocol mode lets you specify 'usejournal' to retrieve events from a community, but it doesn't tell you who posted each event. This sucks.

I was looking into fixing this, but ran into trouble. I can add posterid to the select, but then how do I convert the posterid's to usernames? I could call LJ::get_username() 500 times1, but that's slow. If the useridmap table existed on cluster dbs, I could just do a join on it, but I think it's only on the master. Should I do a select on the master's useridmap table putting 500 items in the where clause? or... what?

1 I'm assuming worst case scenario, using the syncitems selecttype...
Subscribe

  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    switch
    default userpic

    Your reply will be screened

    Your IP address will be recorded 

    Help
  • 4 comments