I see I can't get around that site without revealing email and more. So all I can see is the sign up page. May have folk turned off from the beginning.
As to SQL speed I rarely see any speed drop with 100K records so I'd talk to your DBA about your code. I'll note the classic goof is SELECT *. While they teach that in classes, you get to unlearn it later.
We need suggestions from some programmers with background in coding.We are planning to build a macro rather than micro blogging site similar to twitter.The site is temporarily called MeetMega(http://meetme.ga).
1.too much similarity.Why would anyone switch to our website just for increasing tweet size(1000 chars)
2. Would we merge facebook and twitter and is there any issue(legal or practical) e.g. like, pages, tweete etc.
3. How to scale the website as more than 5000 visitors, the site starts to lag using mysql, ngix(apache)
this is link
Your comments would be highly appreciated