Performance

Thanks Dan.  I had tried a query with worldid, but had entered it incorrectly.  When I saw it was also stuck, I preferd to ask rather than fire 5-6 test queries that would all take near 1 min to complete

I thought about that scenario as well Dethdlr.  It would definitely be ideal to have a unique id, but I think the dbid+worldid workaround is acceptable, especially since the last_killer field is quite likely to be updated regularily.

 

Don't forget to use c:explain=1 when you are stuck on stuff like this.

If you see a BasicCursor, you aren't taking advantage of an index.  The key thing to look at is the nscanned value - you want that to be as low as possible.

-dan

 

I knew I was using something that wasn't indexed (I sent a c:explain=1 query after my first test), was just wondering for a way to work around it.

Relying on the worldid is working just fine now  Performance is perfect.

<img src="http://www.lostrealm.ca/temp/pvp.png" width="835" height="489" />

 

Pretty sweet lookin' character sheet, Lantis!

-dan