Let's make this post quick, since I would like to get some real sleep...
is finally up and running for good (at least so it seems...)!!!! Thanks VERY VERY VERY much to a Paul
who helped me figure it out after several support staff members over the past 72 hours have just thrown me in several directions. Paul, you're a boss.
Fortunate for me, he had just finished creating data structures for a very similar purpose dealing with the Facebook API and had a lot to offer. Basically he told me:
The latter really saved the day. The biggest change he helped me make was changing the oauth ids to bigints rather than the current text in SQL and also indexing this. This made everything load at SUCH a faster speed. 100X better than originally, and at least 1000X better than the slow crappy times! K maybe exaggerating a bit.
But yeah. I believe this is our solution to keeping up a stable site for thousands of concurrent users. I will wake up in about 14 hours (longer if I'm lucky) and hope to see things going just as smoothly as I left them.
- Facebook/MySQL likes short bursty queries over long ones
- Ints are greater than strings