SA-MP Forums

SA-MP Forums (https://forum.sa-mp.com/index.php)
-   Discussion (https://forum.sa-mp.com/forumdisplay.php?f=84)
-   -   General discussion data storage standards for MySQL\SA-MP (https://forum.sa-mp.com/showthread.php?t=667665)

Mobtiesgangsa 01/07/2019 10:50 PM

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.

Fuzzy 01/07/2019 10:53 PM

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;


BlackBank 01/07/2019 11:10 PM

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.

Mobtiesgangsa 02/07/2019 12:52 AM

Re: General discussion data storage standards for MySQL\SA-MP
 
Quote:

Originally Posted by BlackBank (Post 4104542)
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?


All times are GMT. The time now is 06:25 PM.

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