Point ndi kuti Pamene kukula kwa tebulo kumakula, momwemonso "kuya" kwa ma index. - ngakhale logarithmically. Koma pakapita nthawi izi zimakakamiza seva kuti igwire ntchito zowerengera / kulemba zomwezo konza masamba ochulukirapo nthawi zambirikuposa pachiyambi.
Apa ndi pamene zimabwera kudzapulumutsa magawo.
Ndiloleni ndizindikire kuti sitikulankhula za sharding, ndiko kuti, kugawa deta pakati pa ma database osiyanasiyana kapena ma seva. Chifukwa ngakhale kugawa deta mu angapo ma seva, simudzachotsa vuto la indexes "kutupa" pakapita nthawi. Zikuwonekeratu kuti ngati mutha kuyika seva yatsopano tsiku lililonse, ndiye kuti mavuto anu sadzakhalanso mu ndege ya database inayake.
Sitidzalingalira zolemba zenizeni zogwiritsira ntchito magawo "mu hardware", koma njira yokhayokha - zomwe ziyenera "kudulidwa mu magawo", ndi zomwe chilakolako choterocho chimatsogolera.
Malingaliro
Tiyeni tifotokozenso cholinga chathu: tikufuna kuwonetsetsa kuti lero, mawa, ndi chaka chimodzi, kuchuluka kwa deta yowerengedwa ndi PostgreSQL pa ntchito iliyonse yowerengera / kulemba imakhalabe yofanana.
Kwa aliyense deta yosonkhanitsidwa motsatira nthawi (mauthenga, zikalata, zipika, zosungidwa, ...) kusankha kwachilengedwe ngati kiyi yogawa ndi tsiku/nthawi. Kwa ife, chochitika choterocho ndi mphindi yotumiza uthenga.
Popeza tinaganiza zodula mauthenga ndi madeti, ndizomveka kugawanso zinthu zomwe zimadalira iwo (mafayilo ophatikizidwa, mndandanda wa olandila), ndi komanso ndi tsiku la uthenga.
Popeza imodzi mwa ntchito zomwe timachita ndikuwonera zolemba zamauthenga (zosawerengeka, zobwera, zonse), ndizomveka "kuwakokera" kuti agawane ndi masiku a uthenga.