dugasz1 Posted August 11, 2013 Share Posted August 11, 2013 Hello! Question1: I just wanan ask us. Whats the better if a wanna save many data (like for a RP server) use mySQL or SQLlite? What is the better, faster? Question2: And its a good way to controll datas when players are playing to setElementData(onPlayerJoin from sql set it him, onPlayerQuit it get from player and save to sql)? Its made lagg or dont? (Just the very important what the system will use offen.) Link to comment
xXMADEXx Posted August 11, 2013 Share Posted August 11, 2013 1. I recommend SQLite because it is faster... 2. Not really sure what you mean... But I think your tyring to get data from a database. You should just use setAccountData & getAccountData Link to comment
tosfera Posted August 11, 2013 Share Posted August 11, 2013 just save all the data to your SQLITE database. Its only a query of a few bytes that are being sent. Its wont bring any lag if you manage to get the queries bugless. Link to comment
dugasz1 Posted August 11, 2013 Author Share Posted August 11, 2013 Thanks all the answers One more: Am i think correct whit this: http://www.php.net/manual/en/sqlite.installation.php i can make querys whit php in my sqlLite database? Link to comment
xXMADEXx Posted August 11, 2013 Share Posted August 11, 2013 Thanks all the answers One more:Am i think correct whit this: http://www.php.net/manual/en/sqlite.installation.php i can make querys whit php in my sqlLite database? If you wanted your website to be able to share the same database as your server, you would need to use MySQL. These are the (Just incase, here are the PHP functions: ) mysqli_connect mysqli_query mysqli_fetch_array Link to comment
dugasz1 Posted August 11, 2013 Author Share Posted August 11, 2013 But you said SQLLite is faster Link to comment
xXMADEXx Posted August 11, 2013 Share Posted August 11, 2013 But you said SQLLite is faster SQLite is faster, but the file is saved in the resource, its its much more complicated to be able to make it work with a website, so if your planning on using the same database for the server and website, you need to use MySQL. Link to comment
xXMADEXx Posted August 11, 2013 Share Posted August 11, 2013 ohh, thank you You're welcome. Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now