Save Loc and Gotoloc

Started by Ksna, Jul 16, 2015, 03:38 AM

Previous topic - Next topic
Print
Go Down Pages1
User actions

Ksna

Jul 16, 2015, 03:38 AM Last Edit: Jul 16, 2015, 04:09 AM by Ksna
Please tell me which one is better to use for save loc or gotoloc
If you say MySQL / ini / xml /...... tell me why it is better please give your own answers



Thijn

#1
Jul 16, 2015, 06:02 AM
Just use what you use for accounts and stats.

MatheuS

#2
Jul 16, 2015, 07:21 AM
I think better ini ::)
Code Select
if( !sucess ) tryAgain();
Thanks to the VCMP community. It was the happiest period of my life.

KAKAN

#3
Jul 16, 2015, 08:25 AM
Database is better, MySQL is good for accounts
oh no

Murdock

#4
Jul 16, 2015, 09:14 AM
Ini is the worst, you can use xml if you read the data more than you write, else you should go for SQL

Thijn

#5
Jul 16, 2015, 09:16 AM
MySQL is quicker with insert queries, SQLite is faster with select.
Stuff like player stats (which are more updated, then queried) are perfect for MySQL.
Stuff like gotoloc (which are most queried, then updated/inserted) is better with SQLite.

Over complicating your script with all kinds of different saving methods is in my opinion useless and will cause more overhead then actual benefit.

Murdock

#6
Jul 16, 2015, 09:50 AM Last Edit: Jul 16, 2015, 09:52 AM by Murdock
Quote from: Thijn on Jul 16, 2015, 09:16 AMOver complicating your script with all kinds of different saving methods is in my opinion useless and will cause more overhead then actual benefit.

Agreed, I use MySQL for pretty much anything and it goes along fine. The only thing you might want to consider is the right engine for every table (ie. ARCHIVE for logging tables) but still better than having different methods for everything

FarisDon

#7
Jul 16, 2015, 10:16 AM
Well as this topic is already started related with this when we make table so for what thing what kind of type is best?like for cash INT ( 15) // best for the cash so what is the best for the Name IP Reason//which contain more then one word ?So it will not cause lag or anything.

Murdock

#8
Jul 16, 2015, 10:47 AM Last Edit: Jul 16, 2015, 10:51 AM by Murdock
Quote from: Axel-Blaz on Jul 16, 2015, 10:16 AMWell as this topic is already started related with this when we make table so for what thing what kind of type is best?like for cash INT ( 15) // best for the cash so what is the best for the Name IP Reason//which contain more then one word ?So it will not cause lag or anything.

I think the max. length of a nickname in VC:MP is 30 characters, so VARCHAR(30) for Name,
an IPv4 address is built up from 4 sets of 3 digits including 3 seperating dots (255.255.255.255) so the length for IP would be VARCHAR(15)
Print
Go Up Pages1
User actions