HITMAN 17 Posted October 22, 2008 Share Posted October 22, 2008 why is view user for v2 always slow the standard version is there anyway you can make it faster Quote Link to comment Share on other sites More sharing options...
HITMAN 17 Posted October 23, 2008 Author Share Posted October 23, 2008 Re: Why? can you give me an example plz Quote Link to comment Share on other sites More sharing options...
Floydian Posted October 23, 2008 Share Posted October 23, 2008 Re: Why? select * from users that is not optimized select username from users that is If we only needed the username column, we don't want to use *. Quote Link to comment Share on other sites More sharing options...
HITMAN 17 Posted October 23, 2008 Author Share Posted October 23, 2008 Re: Why? do you mean this and if so what do change it to $q=$db->query("SELECT u.*,us.*,c.*,h.*,g.*,f.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid LEFT JOIN cities c ON u.location=c.cityid LEFT JOIN houses h ON u.maxwill=h.hWILL LEFT JOIN gangs g ON g.gangID=u.gang LEFT JOIN fedjail f ON f.fed_userid=u.userid WHERE u.userid={$_GET['u']}"); Quote Link to comment Share on other sites More sharing options...
AlabamaHit Posted October 24, 2008 Share Posted October 24, 2008 Re: Why? thats exactly what he means....on view user for example there is no need for userstats...so dont query that... Find out what you need and only call it.... Quote Link to comment Share on other sites More sharing options...
chaoswar4u Posted October 24, 2008 Share Posted October 24, 2008 Re: Why? V2 userprofiles are slow for staff only that display IP information. Normal members have no lag effect. Its something to do with the IP info that has to resolve the host name I beleave. Quote Link to comment Share on other sites More sharing options...
AlabamaHit Posted October 25, 2008 Share Posted October 25, 2008 Re: Why? that could be true....but personally there is no lag on my game from view users....staff or non staff...but even if its from the staff...He should defently clean up his codes... Quote Link to comment Share on other sites More sharing options...
ColdK Posted October 25, 2008 Share Posted October 25, 2008 Re: Why? Get Fire fox its much faster and my viewuser is norma speed check your server load mine is always below 0.49 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.