search

jmstefans / FlavorOfTheMonth

Website to figure out the best World of Warcraft arena team compositions.
2 stars 1 forks source link

fix multiple threading on api calls / clustering #7

Closed andrewnoyes closed 8 years ago

andrewnoyes commented 8 years ago

@jmstefans example of the weird duplicates (maybe?) being created in query:

select t.TeamID, 
       tm.RatingChangeValue, 
       tm.CurrentRating, 
       tm.CharacterID, 
       s.BlizzName, 
       t.ModifiedDate 
from team t 
join TeamMember tm 
on tm.TeamID = t.TeamID
join Character c 
on c.CharacterID = tm.CharacterID
join spec s 
on s.SpecID = tm.SpecID
where t.TeamID in (2622,2626,2630)
order by t.ModifiedDate asc
jmstefans commented 8 years ago

I don't see anything wrong with that query, so maybe still an issue with threads :( I'll take a look at the threads.

andrewnoyes commented 8 years ago

Reopening. Team duplicates are still being made, just a couple seconds apart...

andrewnoyes commented 8 years ago

Going to close this one for now. The duplicates issue seems to be resolved, but now we're not as performant...:x