SL23W26: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 15: | Line 15: | ||
**Will speed up 10-100x search queries | **Will speed up 10-100x search queries | ||
**CREATE INDEX `stasi-time-test` ON stasi.etm20000.stasimeta(timeStamp); | **CREATE INDEX `stasi-time-test` ON stasi.etm20000.stasimeta(timeStamp); | ||
**select doc.* FROM `stasi`.`etm20000`.`stasimeta` as doc use index(`stasi- | **select doc.* FROM `stasi`.`etm20000`.`stasimeta` as doc use index(`stasi-time-test`) WHERE timeStamp > 1688162400000 AND timeStamp < 1688248800000 ORDER BY timeStamp ASC LIMIT 5000 |
Latest revision as of 13:50, 5 July 2023
DisplayBlocks:
- For some reason the yaw-distance between two states needs to be the opposite of the calculated value for the animation to be corrent.
float yawDist = -(rotTarget - rotSource);
- Interaction-hitbox does not support PITCH/ROLL for blocks; add warning to user
- Yaw of 360 deprecated, only use -180 to 180 at least for display entities
- Client still sends yRot as -6000 etc
- Client still sends yRot as -6000 etc
- Add working indexes to auto-creation for stasi
- Will speed up 10-100x search queries
- CREATE INDEX `stasi-time-test` ON stasi.etm20000.stasimeta(timeStamp);
- select doc.* FROM `stasi`.`etm20000`.`stasimeta` as doc use index(`stasi-time-test`) WHERE timeStamp > 1688162400000 AND timeStamp < 1688248800000 ORDER BY timeStamp ASC LIMIT 5000