[oKzrh]

Hi guys, how are ya'?
I was wondering... Can a Y_INI-based roleplay gamemode could be perfect? or at least, as good as a MySQL one?
If I'm correct, all of the big RP servers are based on MySQL.
What do you say?
Maybe I should move to MySQL...
Thanks

[Cjgogo]

Well,I have started a ROlePlay Server based on Y_INI,what can I say,I like it,but if you wish(as any big RolePlay communities) to have a site and a forum,etc.,then MySQL is better,but as for SERVER only,I'd say there's pretty much no difference,JUST that,as mentioned before,you cannot acces Y_INI data through a site,as far as I'm concerned,so,if you want a site,move to MySQL,but I don't really like the language(looks weird to me LOL).I like Y_INI language better .

[oKzrh]

Quote:

Originally Posted by Cjgogo Well,I have started a ROlePlay Server based on Y_INI,what can I say,I like it,but if you wish(as any big RolePlay communities) to have a site and a forum,etc.,then MySQL is better,but as for SERVER only,I'd say there's pretty much no difference,JUST that,as mentioned before,you cannot acces Y_INI data through a site,as far as I'm concerned,so,if you want a site,move to MySQL,but I don't really like the language(looks weird to me LOL).I like Y_INI language better .

Yep, I know what :P I know both languages (MySQL better), but I just want to know about the server itself, what would be better for a big community - MySQL or Y_INI?

[ReneG]

MySQL

• Very high level, exactly like writing a letter to your computer.
• It's fast, and very practical not only for useraccounts, but for houses, businesses, etc.

Also, don't use old methods of MySQL. Use threaded queries, and make use of the cache functions. A huge mode doesn't need to be coded in MySQL, but it's definitely a plus.

[oKzrh]

Quote:

Originally Posted by VincentDunn MySQL Very high level, exactly like writing a letter to your computer. It's fast, and very practical not only for useraccounts, but for houses, businesses, etc. Also, don't use old methods of MySQL. Use threaded queries, and make use of the cache functions. A huge mode doesn't need to be coded in MySQL, but it's definitely a plus.

Thanks, I think I'll go with MySQL.
I need to learn about how to use threaded queries and cache functions. It would be great if you could give me a link to a thread/site that explains it with PAWN.

[ReneG]

https://sampforum.blast.hk/showthread.php?tid=337810

[playbox12]

Just adding to that, cache and threaded queries are actually really simple when you get used to it. Not to mention the enormous performance gain.

[Vince]

MySQL provides a lot of extra functionality within the MySQL server. But if you're not saving lots and lots of data (personally I have 21 tables at the moment) or are not using its extended functionality then you can stick to just file writing.

[Slice]

Quote:

Originally Posted by Vince MySQL provides a lot of extra functionality within the MySQL server. But if you're not saving lots and lots of data (personally I have 21 tables at the moment) or are not using its extended functionality then you can stick to just file writing.

Or SQLite, which a lot of people seem to be forgetting about.

[Steven82]

Pinewood is currently using Y_INI as it's whole saving system throughout the server. I love it so far. Although I really am turning into an SQLite fanboy.

Quote:

Originally Posted by Slice Or SQLite, which a lot of people seem to be forgetting about.

You sir are the SQLite master


I am loving using SQLite on another "side" mode I am developing when I get bored with Pinewood. And I honestly love it so far. It's great. Although, at times I am getting a bit confused and have to read up on syntax and learn how to do things but that's no problem at all.