[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.