Any time anything is used that makes a SQL query my server will get a severe lag spike and/or a total server timeout. I've tried 3 different SQL servers that are not affiliated and same results for all of them. Anyone else had this problem?
And therefor reflects on server performance? I see. How terrible is just using the default local setting most plugins come with for all of my plugins?
Well what are the advantages to using SQL over just default local is what I am really getting at. Sorry for all the questions, SQL and data querying isn't exactly my strong point.
@THG3 It isn't mine either. However, there will be no lag between querying the SQL server, for example, every time LWC checks protection (that isn't in cache), it queries the server. So, the difference is: - local: about 10-200 msec - on other server: 1-2 seconds.
To answer your first question. SQL is easier to manager and handle in certain circumstances. I use mine to match permissions from forums to in game. As well as player editable titles, using the website. Its just easier to use SQL sometimes, esp with php and other scripts. SQL only really makes a noticable positive performance in very large databases (like bigbrother, logblock, hawkeye, maybe a huge warp db, so on)