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.) Sorry for lot of questions and thanks for the answers!
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 The Ultimate Lua Tutorial! | MTA PHP SDK
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. If you want to contact me directly concerning Advanced-Gaming, please contact me at [email protected]
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? Sorry for lot of questions and thanks for the answers!
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 The Ultimate Lua Tutorial! | MTA PHP SDK
dugasz1 Posted August 11, 2013 Author Posted August 11, 2013 But you said SQLLite is faster Sorry for lot of questions and thanks for the answers!
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. The Ultimate Lua Tutorial! | MTA PHP SDK
dugasz1 Posted August 11, 2013 Author Posted August 11, 2013 ohh, thank you Sorry for lot of questions and thanks for the answers!
xXMADEXx Posted August 11, 2013 Posted August 11, 2013 ohh, thank you You're welcome. The Ultimate Lua Tutorial! | MTA PHP SDK
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