Indexing
Indexing MySQL supports several types of indexes, each designed for a specific scenario or use case. The most common types of indexes in MySQL are: B-tree Indexes: This is the most commonly used index type in MySQL, which stores data in a sorted tree structure. B-tree indexes work best for columns with high selectivity, meaning columns with a large number of unique values. B-tree indexes are suitable for queries that use comparison operators (such as =, >, <, etc.) on indexed columns. Hash Indexes: Hash indexes are designed for exact matches and work best for columns with low cardinality (few unique values). Hash indexes are faster than B-tree indexes for exact matches, but they cannot be used for range queries or partial matches. Full-Text Indexes: Full-text indexes are designed for searching large amounts of text data, such as articles or documents. Full-text indexes tokenize text data and create an index of the tokens, which allows for fast text searching. Full-text inde...
https://www.youtube.com/watch?v=vv4y_uOneC0
ReplyDeleteweb socket intro --> https://www.youtube.com/watch?v=i5OVcTdt_OU
ReplyDeleteSpring boot web socket demo ==> https://www.youtube.com/watch?v=OK2Fn6k7pwo
ReplyDeletehttps://www.javaguides.net/2019/06/spring-boot-websocket-stomp-sockjs-example.html
ReplyDeleteandroid WebSocket Linr ==> https://medium.com/@ssaurel/learn-to-use-websockets-on-android-with-okhttp-ba5f00aea988
ReplyDeletePHP Android Websocket ==> https://www.youtube.com/watch?v=wlRgaaBT76Y&list=PLsOU6EOcj51fGtiZ3mwHaPFJsMGrN7Pd7
ReplyDelete