SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Scripting Help > Discussion

Reply
 
Thread Tools Display Modes
Old 01/07/2019, 10:50 PM   #1
Mobtiesgangsa
Big Clucker
 
Join Date: Oct 2016
Posts: 121
Reputation: 16
Post General discussion data storage standards for MySQL\SA-MP

Hello community, my wondering are! What data storage to use for storing house "system" data values to the MySQL?
the standards as i see are (Data Engines):
  • CSV storage engine - CSV
  • Collection of identical MyISAM tables - MRGMYISAM
  • Supports transactions, row-level locking, and foreign keys - InnoDB
  • /dev/null storage engine (anything you write to it disappears) - BLACKHOLE
  • MyISAM storage engine - MyISAM
  • Performance Schema - PERFORMACE_SCHEMA
  • Archive storage engine - ARCHIVE
  • Hash based, stored in memory, useful for temporary tables - MEMORY

These are the specified ones that i have on my hosted php web server, asking witch one's are most preferable to its usage.
Mobtiesgangsa is online now   Reply With Quote
Old 01/07/2019, 10:53 PM   #2
Fuzzy
Little Clucker
 
Join Date: May 2019
Posts: 37
Reputation: 0
Default Re: General discussion data storage standards for MySQL\SA-MP

I work with InnoDB I think is the best.


As you can see this is my house table.

Code:
CREATE TABLE `houses` (
  `houseID` int(12) NOT NULL,
  `houseOwner` int(12) DEFAULT '0',
  `housePrice` int(12) DEFAULT '0',
  `houseAddress` varchar(32) DEFAULT NULL,
  `housePosX` float DEFAULT '0',
  `housePosY` float DEFAULT '0',
  `housePosZ` float DEFAULT '0',
  `housePosA` float DEFAULT '0',
  `houseIntX` float DEFAULT '0',
  `houseIntY` float DEFAULT '0',
  `houseIntZ` float DEFAULT '0',
  `houseIntA` float DEFAULT '0',
  `houseInterior` int(12) DEFAULT '0',
  `houseExterior` int(12) DEFAULT '0',
  `houseExteriorVW` int(12) DEFAULT '0',
  `houseLocked` int(4) DEFAULT '0',
  `houseWeapon1` int(12) DEFAULT '0',
  `houseAmmo1` int(12) DEFAULT '0',
  `houseWeapon2` int(12) DEFAULT '0',
  `houseAmmo2` int(12) DEFAULT '0',
  `houseWeapon3` int(12) DEFAULT '0',
  `houseAmmo3` int(12) DEFAULT '0',
  `houseWeapon4` int(12) DEFAULT '0',
  `houseAmmo4` int(12) DEFAULT '0',
  `houseWeapon5` int(12) DEFAULT '0',
  `houseAmmo5` int(12) DEFAULT '0',
  `houseWeapon6` int(12) DEFAULT '0',
  `houseAmmo6` int(12) DEFAULT '0',
  `houseWeapon7` int(12) DEFAULT '0',
  `houseAmmo7` int(12) DEFAULT '0',
  `houseWeapon8` int(12) DEFAULT '0',
  `houseAmmo8` int(12) DEFAULT '0',
  `houseWeapon9` int(12) DEFAULT '0',
  `houseAmmo9` int(12) DEFAULT '0',
  `houseWeapon10` int(12) DEFAULT '0',
  `houseAmmo10` int(12) DEFAULT '0',
  `houseMoney` int(12) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
__________________
My Releases:
Fuzzy is offline   Reply With Quote
Old 01/07/2019, 11:10 PM   #3
BlackBank
Gangsta
 
Join Date: Dec 2010
Location: The Netherlands
Posts: 524
Reputation: 437
Default Re: General discussion data storage standards for MySQL\SA-MP

InnoDB, since you can create relationships (foreign keys) between your houses table and accounts. Makes it a lot cleaner and faster. Also your table couldn't crash, like MyISAM can do.
BlackBank is offline   Reply With Quote
Old 02/07/2019, 12:52 AM   #4
Mobtiesgangsa
Big Clucker
 
Join Date: Oct 2016
Posts: 121
Reputation: 16
Default Re: General discussion data storage standards for MySQL\SA-MP

Quote:
Originally Posted by BlackBank View Post
InnoDB, since you can create relationships (foreign keys) between your houses table and accounts. Makes it a lot cleaner and faster. Also your table couldn't crash, like MyISAM can do.
ahm okay, what about CSV storage engine is there any good use for it?
Mobtiesgangsa is online now   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
When building a Role Play server...(general questions discussion) Aerotactics General 0 18/02/2014 03:39 AM
Who can give me RP GameMode MySQL storage. Thank you. wsll789 Scripting Help 2 24/07/2013 12:26 PM
how to make a soldier aotumaticly be general when the general dies ? AlbanianGuy Scripting Help 35 13/05/2012 03:35 PM
Problems with mysql result storage baske007 Help Archive 4 23/07/2010 04:17 PM
This is NOT a General Scripting Discussion Board. V1ceC1ty Help Archive 3 22/10/2009 12:53 PM


All times are GMT. The time now is 02:46 AM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.