Kryptix Posted January 6, 2010 Share Posted January 6, 2010 I had a big problem with this game I run where logging in would take forever as I had the Index wrong on a table (which I still don't understand). Now I'm having issues with saving, it's taking forever to save one player and when it loops through 200 players it's taking like 200 seconds to save which just isn't good and is messing a lot of things up. Could indexing be causing this? I really don't know what I'm doing regarding to indexes, could anyone have a look through my tables and help me out at all? Quote Link to comment https://forums.phpfreaks.com/topic/187493-index-help-with-update-and-insert/ Share on other sites More sharing options...
premiso Posted January 6, 2010 Share Posted January 6, 2010 Post your table structure and the code that is taking 1 second per query (if it is in a loop post the whole loop code), as it could be causing it. Quote Link to comment https://forums.phpfreaks.com/topic/187493-index-help-with-update-and-insert/#findComment-989994 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.