It appears the problem was a very bad SQL JOIN query --- which rendered any other follow up query to que and wait for the JOIN to finish.
I think I have it sorted --- but, we will test it out. Sadly I can't do it, coz of the 'role' I play within the site. So if anybody can try the 'messages' page and navigate throughout (reading threads, adding contacts, sending messages) then we will know if it worked.
the query involved checking to see if you and 'a friend' are contacts --- that is to say it checked if you have made them a contact AND they too have made you their contact.
that JOIN created a massive data response from the Database --- on the local dev machine there is only 20-30 pple, whereas on 75 there is about 300, so, 300 multiplied by 300 resulted 90,000 records being returned, hence the pseudo crashing of the site.
with these kindsa stats, Growth is indeed inevitable! awesome stuff! happy anniversary to 75, or 75th should i say, hope more awesomeness is coming in the near future! respect!
Taking Jan Smuts Ave from town towards randburg taxi Rank, Pass Hyde Park Mall on your right, Pass McDonalds on your left keep left, 3 roobots down turn left in a slip road into Conrad Drive, Pass 1st robots (There's a Nandos on the Corner) and block of flats, pass Blairegowrie Drive, Three house from the corner .... 88 Conrad drive
I am not changing --- I will be moving from a framework to another: which is more robust, and allows for API's (internal and external) --- then I'll be adding a few other things.
I will be adding a few other things, e.g.: slideshow, books (which are like 1 year overdue), email notification (where application),
I will be re-doing the messages/contacts sections: get the design right, add a bit more Ajax to them.
But, ja, I hear you --- to be honest, I don't think I even have the time to finish all these things I want to complete.
æ
yay! a new dawn!!! zum... err... hehe... I meant Lebogang, Lebogang!
Happy daze on 75th apples!!!
lebogang nkoane
well, almost --- we got hit by some problems, which I am not actually sure, what they are --- but will see if they replicate.
in essence I'm putting this 'stable', till it survives a week at the least.
(bow)
lebogang nkoane
and, now it turns out ie8 doesn't work as well.
*arggggg, I need my sleeeeeeeeeeeep.
Daz
I'll test in Firefox and Chrome. I don't play in the IE world if I can help it.
Well done Lebogang ... Apple's LIVÉ!
lebogang nkoane
Ah, tested on ie8 (service pack 3) --- it seems okay, but Kunta/Kinte insists there is something wrong.
*sigh
(bow)
lebogang nkoane
ups and downs --- I honestly do not know why it keeps dying ---
when I get home, I pulling out the an afro-comb and go through the code line, by line,,
lebogang nkoane
ol'right --- we figured it out --- it's not the code, well, not entirely.
it's mysql --- something-about-something-that keeps queries in a 'lock(ed)' state.
We are investigating why.
lebogang nkoane
Okay, I think we got it sorted, just a little bit.
Now, we wait for tomorrow, peak traffic.
lebogang nkoane
It appears the problem was a very bad SQL JOIN query --- which rendered any other follow up query to que and wait for the JOIN to finish.
I think I have it sorted --- but, we will test it out. Sadly I can't do it, coz of the 'role' I play within the site. So if anybody can try the 'messages' page and navigate throughout (reading threads, adding contacts, sending messages) then we will know if it worked.
the query involved checking to see if you and 'a friend' are contacts --- that is to say it checked if you have made them a contact AND they too have made you their contact.
that JOIN created a massive data response from the Database --- on the local dev machine there is only 20-30 pple, whereas on 75 there is about 300, so, 300 multiplied by 300 resulted 90,000 records being returned, hence the pseudo crashing of the site.
seilatsatsi
the new version is awesome
lebogang nkoane
ta!