![\"Versioni](\"\/wp-content\/uploads\/2024\/12\/8cac8a61b8daee1fbf8027a4aec2de1e.png\")
<\/center> ![\"Versioni](\"\/wp-content\/uploads\/2024\/12\/39e3a4f1943e4263d0f0960ac5f45366.png\")
<\/center> ![\"Versioni](\"\/wp-content\/uploads\/2024\/12\/a6a1d6e1c9b09b10dcc2d9b4bc61c805.png\")
<\/center> <\/p>\nVersion beta7 e motorit t\u00eb ruajtjes OrioleDB \u00ebsht\u00eb prezantuar dhe jan\u00eb publikuar rezultatet e testimeve t\u00eb reja q\u00eb demonstrojn\u00eb nj\u00eb rritje t\u00eb konsiderueshme t\u00eb performanc\u00ebs krahasuar me PostgreSQL-in tradicional. N\u00eb versionin beta7 jan\u00eb implementuar optimizime p\u00ebr t\u00eb p\u00ebrmir\u00ebsuar funksionimin me ngarkesa me shum\u00eb pjes\u00ebmarr\u00ebs dhe p\u00ebr t\u00eb p\u00ebrshpejtuar operacionet e leximit dhe shkruajtur. L\u00ebshimi i par\u00eb stabil i OrioleDB pritet t\u00eb formohet n\u00eb vitin 2025. Motorri \u00ebsht\u00eb shkruar n\u00eb gjuh\u00ebn C dhe shp\u00ebrndahet n\u00ebn licenc\u00ebn PostgreSQL, e ngjashme me licencat BSD dhe MIT. <\/p>\n
Projekti OrioleDB zhvillon nj\u00eb motor alternativ t\u00eb ruajtjes p\u00ebr PostgreSQL, i zhvilluar me q\u00ebllim p\u00ebr t\u00eb kap\u00ebrcyer kufizimet e mekanizmit standard t\u00eb ruajtjes dhe p\u00ebr t\u00eb rritur efikasitetin e p\u00ebrgjithsh\u00ebm t\u00eb sistemit. P\u00ebr shembull, OrioleDB lejon shmangien e ekzekutimit periodic t\u00eb operacionit VACUUM p\u00ebr grumbullimin e mbeturinave, fal\u00eb implementimit t\u00eb mekanizmit MVCC (Kontrolli i Konkurenc\u00ebs me Versione t\u00eb Shumta) mbi baz\u00ebn e regjistrave t\u00eb t\u00ebrheqjes (undo logs), q\u00eb punojn\u00eb n\u00eb nivelin e blloqeve dhe rreshtave individual\u00eb, si dhe nj\u00eb sistemi automatik t\u00eb bashkimit t\u00eb faqeve q\u00eb p\u00ebrmbajn\u00eb t\u00eb dh\u00ebna. OrioleDB gjithashtu p\u00ebrdor identifikues 64-bit\u00ebsh t\u00eb transaksioneve, q\u00eb zgjidh problemin e mbushjes s\u00eb num\u00ebruesve. <\/p>\n
P\u00ebr t\u00eb thjeshtuar p\u00ebrdorimin n\u00eb sisteme t\u00eb shp\u00ebrndara dhe p\u00ebr t\u00eb paralelizuar operacionet, OrioleDB ka organizuar mbajtjen e regjistrit WAL t\u00eb transaksioneve n\u00eb nivelin e rreshtave. Kur ekzekutohet operacioni UPDATE, mb\u00ebshtetet z\u00ebvend\u00ebsimi i t\u00eb dh\u00ebnave n\u00eb vend (pa \u00e7liruar regjistrin aktual dhe krijuar nj\u00eb t\u00eb ri), \u00e7ka ka nj\u00eb ndikim pozitiv n\u00eb performanc\u00eb. N\u00eb OrioleDB gjithashtu jan\u00eb implementuar mund\u00ebsi t\u00eb tilla si leximi i faqeve me t\u00eb dh\u00ebna pa p\u00ebrdorur bllokime, lidhja direkte e faqeve n\u00eb memorjen operative me faqet n\u00eb ruajtjen e p\u00ebrhershme, aplikimi i mekanizmit CoW (copy-on-write) gjat\u00eb konfirmimit t\u00eb pikave kontrolluese p\u00ebr t\u00eb krijuar snapshot-e t\u00eb q\u00ebndrueshme n\u00eb \u00e7do moment dhe m\u00ebnyra e ruajtjes s\u00eb t\u00eb dh\u00ebnave n\u00eb format t\u00eb kompresuar duke p\u00ebrdorur algoritmin ZSTD. <\/p>\n
N\u00eb beta-n e saj t\u00eb shtat\u00eb, OrioleDB ka disa kufizime, duke p\u00ebrfshir\u00eb p\u00ebrdorimin e indekseve vet\u00ebm n\u00eb formatin B-tree (mb\u00ebshtetje p\u00ebr t\u00eb gjitha llojet e indekseve PostgreSQL do t\u00eb shtohet n\u00eb t\u00eb ardhmen), si dhe munges\u00ebn e mb\u00ebshtetjes p\u00ebr transaksionet e p\u00ebrgatitura paraprakisht (PREPARE TRANSACTION) dhe komand\u00ebn \u00abREINDEX\u00bb n\u00eb modalitetin \u00abCONCURRENTLY\u00bb. OrioleDB implementohet si nj\u00eb zgjerim q\u00eb k\u00ebrkon ndryshime n\u00eb baz\u00ebn e kodit kryesor t\u00eb PostgreSQL. <\/p>\n
N\u00eb testet e performanc\u00ebs TPC-C, t\u00eb cilat simulojn\u00eb ngarkes\u00ebn e p\u00ebrpunimit t\u00eb transaksioneve n\u00eb kushte reale, versioni i shtat\u00eb beta i OrioleDB tregoi nj\u00eb superioritet t\u00eb duksh\u00ebm mbi motorin standard PostgreSQL. Testimi u realizua me nj\u00eb num\u00ebr t\u00eb ndrysh\u00ebm klient\u00ebsh q\u00eb punonin nj\u00ebkoh\u00ebsisht, p\u00ebr t\u00eb vler\u00ebsuar shkall\u00ebzueshm\u00ebrin\u00eb dhe performanc\u00ebn e sistemit me rritjen e ngarkes\u00ebs. <\/p>\n
N\u00eb testet q\u00eb vler\u00ebsojn\u00eb kapacitetin e transaksioneve, motori OrioleDB arrin nj\u00eb kapacitet m\u00eb t\u00eb lart\u00eb, i matur n\u00eb transaksione p\u00ebr minut\u00eb (tpmC). Nd\u00ebrsa rritej numri i klient\u00ebve, performanca e OrioleDB vazhdoi t\u00eb rritet n\u00eb m\u00ebnyr\u00eb lineare, nd\u00ebrsa motori Heap n\u00eb PostgreSQL tregonte nj\u00eb tendenc\u00eb p\u00ebr stagnim dhe madje r\u00ebnie pas nj\u00eb kufiri t\u00eb caktuar.
<\/center> <\/center> <\/center> <\/p>\n