Qhov kev tso tawm ntawm SQLite 3.36, lub teeb DBMS tsim los ua lub tsev qiv ntawv plug-in, tau luam tawm. SQLite code yog muab faib rau hauv pej xeem sau, i.e. tuaj yeem siv yam tsis muaj kev txwv thiab pub dawb rau txhua lub hom phiaj. Kev them nyiaj yug rau SQLite developers yog muab los ntawm ib tug tshwj xeeb tsim consortium, uas muaj xws li cov tuam txhab xws li Adobe, Oracle, Mozilla, Bentley thiab Bloomberg.
Cov kev hloov loj:
- Cov zis ntawm EXPLAIN QUERY PLAN cov lus txib tau ua kom nkag siab yooj yim dua.
- Xyuas kom meej tias qhov yuam kev raug tsim thaum sim nkag mus rau ib qho rowid hauv VIEW lossis subquery. Txhawm rau rov qab muaj peev xwm nkag mus rau rowid rau kev pom, kev xaiv sib dhos "-DSQLITE_ALLOW_ROWID_IN_VIEW" yog muab
- Lub sqlite3_deserialize() thiab sqlite3_serialize() interfaces tau qhib los ntawm lub neej ntawd. Txhawm rau lov tes taw, qhov kev xaiv sib dhos "-DSQLITE_OMIT_DESERIALIZE" yog muab
- VFS "memdb" tso cai rau kev sib koom ntawm cov ntaub ntawv hauv lub cim xeeb hla kev sib txuas sib txawv rau tib txoj kev ntev npaum li lub npe database pib nrog "/".
- Qhov "EXISTS-rau-IN" optimization tau qhia nyob rau hauv qhov kev tso tawm kawg, uas ua rau qeeb qee cov lus nug, tau thim rov qab.
- Kev ua kom zoo rau kev sib txuas cov kev kuaj xyuas tas mus li tau raug kho kom ua haujlwm nrog cov lus nug yam tsis muaj kev sib koom ua ke (sib koom).
- REGEXP txuas ntxiv suav nrog hauv CLI.
Tau qhov twg los: opennet.ru