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...
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...