dugasz1 Posted August 11, 2013 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.)
xXMADEXx Posted August 11, 2013 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
tosfera Posted August 11, 2013 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.
dugasz1 Posted August 11, 2013 Author 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?
xXMADEXx Posted August 11, 2013 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
xXMADEXx Posted August 11, 2013 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.
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