A maeʻa le lua ma le afa tausaga o le atinaʻeina, ua faʻalauiloa mai le Firebird 5.0, o se DBMS faʻafesoʻotaʻi. O loʻo faʻaauau pea ona atiaʻe e le Firebird le code o le InterBase 6.0 DBMS, lea na tatala i le 2000 e Borland. O loʻo tufatufa atu le Firebird i lalo o le laisene MPL e leai se totogi ma lagolagoina tulaga faʻatonuina o le ANSI SQL, e aofia ai foliga e pei o faʻagaoioi, faʻagasologa teuina, ma le toe faia. O loʻo avanoa le binary builds mo Linux, Windows, macOS и Android.
Fa'afouga autu:
- O le gafatia e faʻatino ai gaioiga i le tele-threaded mode ua faʻatinoina. Fa'atasi i filo e tele e fa'aoga pe a fai fa'asino igoa, aoina o lapisi (otometi ma fa'agaoioiga salu tusi), faia fa'amaumauga ma toe fa'afo'i mai ia i latou. gfix -sweep -parallel 4 dbname gbak -b -par 4 -user username -pass password dbname backupname
- Fa'aopoopo le lagolago mo fa'ailoga fa'apitoa e aofia ai na'o fa'amaumauga filifilia e fetaui ma tu'utu'uga fa'amaoti pe a fai le fa'ailoga. FAITAU INDEX IT1_COL I LE T1 (COL) LEA COL <100;
- O faʻamatalaga SELECT WITH LOCK, UPDATE, ma DELETE o loʻo faʻaaogaina le "SKIP LOCKED" syntax, lea e mafai ai ona e vavaeeseina faamaumauga o loʻo i ai se loka i le taimi e lafo ai le talosaga (mo se faʻataʻitaʻiga, ina ia aua neʻi faʻatali mo le loka e tatala pe a fesoʻotaʻi ma se isi fefaʻatauaiga).
- Faʻaopoopo le gafatia e faʻafou le faʻamaumauga i le taimi nei o loʻo i ai nei le vaeluaga o le teuina (ODS - On-Disk-Structure) i luga o le lele (inline update) e aunoa ma le fatuina ma le toe faʻaleleia mai se faʻamaumauga. Mo se faʻataʻitaʻiga, e mafai nei ona e faʻaliliu se faʻamaumauga i le Firebird 4.0 (ODS 13.0) faʻasologa i le Firebird 5.0 (ODS 13.1) faʻasologa i luga o le lele.
- Faʻatinoina se faʻamaumauga o faʻamatalaga SQL tuʻufaʻatasia e otometi ona tausia (faʻamalo faʻamaumauga e kilia pe a manaʻomia). Ole tele ole cache e fa'atulaga ile MaxStatementCacheSize parameter ile firebird.conf.
- Ua fa'aopoopoina se atina'e mo le fa'ailoaina o le SQL ma le PSQL, e mafai ai ona e fa'atatauina le taimi e fa'atino ai fesili ta'itasi, fa'aputu fa'amaumauga i le aofa'i o fesili, ma fa'ailoa fa'afitauli fa'atino.
- Fa'aopoopoina le lagolago i le fa'aaliga MERGE mo le poloka fa'atutuuga "WHEN NOT MATCHED BY SOURCE", lea e mu pe a le fetaui le fa'amaumauga fa'apogai ma so'o se fa'amaumauga i le fa'atulagaina. FA'ASA'I I totonu o tagata fa'atau c FA'A'OGA new_customers nc ON (c.id = nc.id) PE A FESOASOANI ONA FA'AVAE LE SET igoa = nc.name PE'A LE'I FA'ATASI I LE SOURCE Ona tape lea.
- Ua mafai nei ona toe fa'afo'i laina se tele e fa'aaoga ai se fa'aaliga RETURNING pe a fai o se fa'aaliga DML ua tu'uina atu e tele laina (muamua, o le mea sese "laina tele i le filifilia tasi" na fa'aalia i ia tulaga).
- Ua fa'aopoopoina galuega fou fou: UNICODE_CHAR e toe fa'afo'i le uiga unicode e fetaui ma le fa'ailoga ua tu'uina atu, ma UNICODE_VAL e toe fa'afo'i ai le fa'ailoga mo le tagata ua tu'uina atu. O le QUARTER parameter ua faaopoopo i le EXTRACT, FIRST_DAY ma LAST_DAY galuega e fuafua ai le numera kuata.
- Ua fa'aopoopoina se pusa fou RDB$BLOB_UTIL ma se filifiliga o galuega BLOB mo fa'aoga PSQL.
- Ua fa'aleleia le fa'amaumauga fa'amaumau algorithm e fa'aoga ai se fa'ailoga umi e fesuisuia'i e fa'apipi'i lelei ai fa'asologa o fa'amaumauga. O le fa'ata'ita'iga ua matua fa'aleleia atili le fua fa'atatau o va'a VARCHAR umi e le'i fa'atumuina ma fa'amaumauga UTF-8.
- Fa'aopoopoina le tomai e galue ai i fa'aupuga fa'a-lua (scrollable) pe a maua se fa'amaumauga mamao i luga o se feso'otaiga.
- Ua fa'asilisiliina le fa'atinoga o le kopiina o pa'u.
- Fa'aopoopoina le lagolago atoatoa mo le fa'auigaina o le manoa o lo'o fa'amatalaina ile tulaga SQL. Mo se faʻataʻitaʻiga, e mafai nei ona motusia laina e ala i faʻamatalaga poʻo avanoa: filifili 'ab' /* faʻamatalaga */ 'cd' mai RDB$DATABASE; filifili 'ab' 'cd' mai RDB$DATABASE;
puna: opennet.ru
