HITMAN 17 Posted October 22, 2008 Posted October 22, 2008 why is view user for v2 always slow the standard version is there anyway you can make it faster Quote
HITMAN 17 Posted October 23, 2008 Author Posted October 23, 2008 Re: Why? can you give me an example plz Quote
Floydian Posted October 23, 2008 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
HITMAN 17 Posted October 23, 2008 Author 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
AlabamaHit Posted October 24, 2008 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
chaoswar4u Posted October 24, 2008 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
AlabamaHit Posted October 25, 2008 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
ColdK Posted October 25, 2008 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
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.