How to optimize the database paging query method in the scenario of 100 million data volume?
Absrtact: paging query is required to turn the page of posts, and paging query is also required to search goods. When there are tens of millions or hundreds of millions of data, how can we quickly pull the full amount of data?
This article is shared from Huawei cloud community< Paging query for large data volume performance optimization &g ...
Posted by summerpewp on Sat, 26 Feb 2022 04:36:27 +0100
MyBatis caching mechanism
13.MyBatis caching mechanism
1. Why cache?
When users frequently query some fixed data, they query these data from the database for the first time and save them in the cache. When users query these data again, they do not need to query through the database, but query in the cache. Reduce the loss caused by network connection and database quer ...
Posted by lajollabob on Fri, 25 Feb 2022 01:37:11 +0100
Detailed explanation of Mybatis SQL mapping file
Before that, we learned the global configuration file of mybatis. Now we begin to learn the mapping file of mybatis. In the mapping file, you can write the following top-level element labels:
cache – Cache configuration for this namespace.
cache-ref – Cache configuration that references other namespaces.
resultMap – Describing how to load obje ...
Posted by Buddski on Wed, 23 Feb 2022 08:01:31 +0100
Second kill based on redis
For single process implementation
@RequestMapping("/miaosha1")
@ResponseBody
public String miaosha1() {
synchronized (this){
Map<String,Object> mapListmaps = new HashMap<>();
//Get inventory value in redis
int kucun = Integer.valueOf(redisUtil.getStrKV("kucun").toString()) ...
Posted by smudge on Tue, 22 Feb 2022 04:28:30 +0100
Dark horse programmer jvm notes -- some experience of JMM memory model
JMM memory model
1. Computer structure
Input device: our mouse and keyboard
Memory: corresponding to our memory, cache
The arithmetic unit and controller together constitute the cpu
Output devices, such as display screens and printers.
Let's focus on caching:
2. Cache
In fact, when we say that computers are inefficient and slow, they ...
Posted by router on Sun, 20 Feb 2022 13:52:36 +0100
Summarize the common commands of Redis operation under Linux
1. Install redis for Ubuntu / CentOS (redis5.0.8 does not need to update gcc)
https://blog.csdn.net/qq_34246965/article/details/115269542
2. Start redis service and verify
If it is in the bin directory under the redis file, the command: redis-server /etc/redis/redis.conf # start redis service
If it is in the redis file /bin/redis-server /et ...
Posted by killah on Sat, 19 Feb 2022 20:39:44 +0100
redis-3.redis's message subscription, pipeline, transaction, modules, bloom filter and cache LRU
redis
pipeline
Beer theory, for example, there are 24 bottles of beer in the store. You can't take one bottle home and drink another. You need to find a box to carry the beer home together The buffer mechanism can also be understood in this way to avoid calling back and forth
A request / response server can handle new requests even ...
Posted by linfidel on Sat, 19 Feb 2022 06:15:41 +0100
Cache optimization and practice of ten million shopping cart system
1, Analysis of shopping cart data model in E-commerce
Functions realized in shopping cart: add shopping cart, view shopping cart, edit shopping cart sku, edit commodity data, select multiple commodities in shopping cart to settle, view the total number of commodities in shopping cart, delete shopping cart, share shopping cart, etc
Current sho ...
Posted by mitwess on Fri, 18 Feb 2022 10:21:21 +0100
Installation, use and optimization of Redis (including python operation zset)
1, Redis installation
download
Redis
1. Decompress, compile and install
# Decompress, compile and install
(odc) [mca@clu01 software]$ tar -xvf redis-6.2.6.tar.gz
(odc) [mca@clu01 software]$ cd redis-6.2.6/
(odc) [mca@clu01 redis-6.2.6]$ make
(odc) [mca@clu01 redis-6.2.6]$ cd src
(odc) [mca@clu01 src]$ sudo make install
2. Director ...
Posted by agga.gaag on Tue, 15 Feb 2022 15:42:26 +0100
vue uses keep alive to cache page optimization projects
concept
Keep alive yes Vue When it wraps dynamic components, it caches inactive component instances instead of destroying them. Similar to transition, keep alive is an abstract component: it does not render itself as a DOM element or appear in the parent component chain.
effect
In the process of component switching, the switched components a ...
Posted by ozzmans on Tue, 15 Feb 2022 15:32:20 +0100