[Jimmyhead521]

Hello,
I want to know what is better i have Mysql running but when i modify the data it dosent works, it saves the user data to the data base but it dosent work. when i edit it in scriptfiles it works
any ideas and yes, what is the diff?

[Chaprnks]

MySQL - More efficient if you know what your doing.
File Based - Easier to script, but very limited feature-wise.

[Jimmyhead521]

I got it working on mySQL well Im a advanced mySQL user but i dont know the diffance between the data based.. I mean my data base uses mySQL and the normal file system how can i stop it useing the normal file system

[RoBo]

SQLite = native to SA:MP and faster than both MySQL and files.

[iLinx]

delete all the file based parts of the script?

[Mina]

Quote:

Originally Posted by Jimmyhead521 Hello, I want to know what is better i have Mysql running but when i modify the data it dosent works, it saves the user data to the data base but it dosent work. when i edit it in scriptfiles it works any ideas and yes, what is the diff?

1. If you edit account files and it works then your script is NOT SQLized.
2. It's hard to list all the differents, but imagine a bike vs car. (bike = filing, car = SQL)
Now you can understand how powerful is SQL, but can you drive a car without a license ? Of course you can't.
But with a bike you may drive, and it don't need any license, of course it's not powerful as a car is.

Most of SQLized samp script which i saw, the scripter just added some fields in it and left anything else even didn't add a key !.
So if you are going to do this, just leave SQL and use filing, else if you know how to work with SQL(relations, etc) then use it.

[Mina]

Quote:

Originally Posted by Seif_ MySQL is better than using files. It works properly, you're just not doing it right.

Firstly it's SQL not MySQL (MySQL is just a server).
And then you can't say which is better, as i said, it depends on the scripter.

[Mina]

Quote:

Originally Posted by Seif_ Quote: Originally Posted by Mina Quote: Originally Posted by Seif_ MySQL is better than using files. It works properly, you're just not doing it right. Firstly it's SQL not MySQL (MySQL is just a server). And then you can't say which is better, as i said, it depends on the scripter. I'm well aware that it's SQL, I'm talking about MySQL. And yes you can say which is better obviously. Files will take lots of space and they're slower.

LOL, you talk about MySQL ?, may i please know what is your mean with that ?
And again you noticed wrongly, SQL does use very much more space than a file.
And may i know how you found out "Files will take lots of space" ?
Sorry but again there is one more wrong.
SQL is NOT faster than filing, and it's even slower,if you don't use it in standard ways, if you don't belive try to do this
Update a big SQL table like cars, with about 2000 records and 20 fields.
Now try to do it by file, you will see which is faster.
Anyway no one can say which is faster.
Again i have to say > It depends how you use it, yes if you use SQL in standard ways then it's faster. and if you are going to use it like newbies then i should say it's very slower than filing.

[iLinx]

Quote:

Originally Posted by Mina Quote: Originally Posted by Seif_ Quote: Originally Posted by Mina Quote: Originally Posted by Seif_ MySQL is better than using files. It works properly, you're just not doing it right. Firstly it's SQL not MySQL (MySQL is just a server). And then you can't say which is better, as i said, it depends on the scripter. I'm well aware that it's SQL, I'm talking about MySQL. And yes you can say which is better obviously. Files will take lots of space and they're slower. LOL, you talk about MySQL ?, may i please know what is your mean with that ? And again you noticed wrongly, SQL does use very much more space than a file. And may i know how you found out "Files will take lots of space" ? Sorry but again there is one more wrong. SQL is NOT faster than filing, and it's even slower,if you don't use it in standard ways, if you don't belive try to do this Update a big SQL table like cars, with about 2000 records and 20 fields. Now try to do it by file, you will see which is faster. Anyway no one can say which is faster. Again i have to say > It depends how you use it, yes if you use SQL in standard ways then it's faster. and if you are going to use it like newbies then i should say it's very slower than filing.

Okay first lets clear something up. SQL is Structured Query Language. It is the language that is used to access databases such as MySQL, MSAccess, SQLlite, etc. SQL is NOT a database, and it is NOT something that you store something in. It's a language used for accessing information in a database system using relational algebra

As Seif said, MySQL is much more efficient than files. Not only does it allow you manage your data easier, but by using relational algebra, SQL can scan through information quicker than a normal KEY=VALUE search as used by many samp servers today (with dini or dudb).

MySQL also allows you add website functionality using web scripting languages like PHP, although functionality can be added with scriptfiles, it's much harder that way and will have you ripping out your hair every step of the way.

[Mina]

Quote:

Originally Posted by iLinx Quote: Originally Posted by Mina Quote: Originally Posted by Seif_ Quote: Originally Posted by Mina Quote: Originally Posted by Seif_ MySQL is better than using files. It works properly, you're just not doing it right. Firstly it's SQL not MySQL (MySQL is just a server). And then you can't say which is better, as i said, it depends on the scripter. I'm well aware that it's SQL, I'm talking about MySQL. And yes you can say which is better obviously. Files will take lots of space and they're slower. You both are in big wrong, and i don't care about it. If anyone have doubt about it, just ask it from a professional programmer, i'm not talking about that guys who script, so i suggest Kye. LOL, you talk about MySQL ?, may i please know what is your mean with that ? And again you noticed wrongly, SQL does use very much more space than a file. And may i know how you found out "Files will take lots of space" ? Sorry but again there is one more wrong. SQL is NOT faster than filing, and it's even slower,if you don't use it in standard ways, if you don't belive try to do this Update a big SQL table like cars, with about 2000 records and 20 fields. Now try to do it by file, you will see which is faster. Anyway no one can say which is faster. Again i have to say > It depends how you use it, yes if you use SQL in standard ways then it's faster. and if you are going to use it like newbies then i should say it's very slower than filing. Okay first lets clear something up. SQL is Structured Query Language. It is the language that is used to access databases such as MySQL, MSAccess, SQLlite, etc. SQL is NOT a database, and it is NOT something that you store something in. It's a language used for accessing information in a database system using relational algebra As Seif said, MySQL is much more efficient than files. Not only does it allow you manage your data easier, but by using relational algebra, SQL can scan through information quicker than a normal KEY=VALUE search as used by many samp servers today (with dini or dudb). MySQL also allows you add website functionality using web scripting languages like PHP, although functionality can be added with scriptfiles, it's much harder that way and will have you ripping out your hair every step of the way.

You both are in big wrong, and i don't care about it.
If anyone have doubt about it, just ask it from a professional programmer, i'm not talking about that guys who script, so i suggest Kye.