Write in front Organizing notes related to exams The blog post covers a simple understanding of Linux tuned tuning tools A brief description of tuning configuration files and an introduction to custom tuning solutions If you don’t understand enough, please help me correct it. There is only one true responsibility for everyone: to find themselves. […]
Tag: orm
Thoughts on MySQL optimization two [Performance analysis tools, optimization principles]
In actual work, we inevitably need to analyze and optimize SQL predictions. Today we will take a look at the relevant content: SQL performance analysis SQL optimization principles 1 SQL performance analysis Performance analysis of SQL mainly includes: View slow SQL View through profile details explain execution plan 1.1 View slow SQL SQL execution frequency […]
Explosive performance! Python multi-process mode implements multi-core CPU parallel computing
Article directory Preface 1. Multi-process mode in Python 2. Methods to improve program execution efficiency 1. Multiple processes execute tasks concurrently 2. Process pool 3.Message queue 4. Shared memory 5.Asynchronous IO Summarize About Python technical reserves 1. Learning routes in all directions of Python 2. Python basic learning video 3. Excellent Python learning books 4. […]
Designing IIR digital filter using bilinear transformation method
1. Experimental purpose 1. Be familiar with the principles and methods of designing IIR digital filters using bilinear transformation method. 2. Master the computer simulation method of digital filters. 3. Obtain perceptual knowledge of digital filtering by observing the filtering effect on actual electrocardiogram signals. 2. Experimental content 1. Use bilinear transformation method to design […]
Use R language to export pictures in various formats
Welcome to follow the WeChat official account (Medical Bioinformatics), medical students’ student notes to record the learning process. Common image formats include: pdf, jpeg, tiff, png, svg, wmf. pdf, svg and wmf are vector graphics formats, so there will be no blur when enlarging the picture. jpeg, tiff and png are bitmap formats and will […]
Android performance optimization – startup optimization improved by 60%
Application startup speed The startup speed of an application can affect the user’s first experience. An application with a slow startup speed (perceptually) may cause the user to decrease the intention to open the app again, or uninstall and abandon the application. This article will optimize the application startup speed from two directions: 1. Visual […]
WinForm application interface development practice – how to integrate external API interface calls in a hybrid framework
In our regular business processing, most of the internal processing interfaces are database-related and based on the Winform development framework of hybrid development. Although when the client calls, the general choice is also based on Web API calls, but the back-end We may not only process our business database, but also call other external interfaces, […]
Windows enumerates device information
Enumeration of device information is mainly implemented through the interface in the SetupAPI module, in conjunction with the corresponding device class GUID. Here we take enumerating USB device information as an example, including device instance addresses, etc.: #include <stdio.h> #include <Windows.h> #include <SetupAPI.h> #pragma comment(lib, “SetupAPI.lib”) #include <devguid.h> // The specific device GUID requires initguid, […]
Storage structure and query performance optimization of ClickHouse primary key index
Table of Contents Storage structure and query performance optimization of ClickHouse primary key index 1. Storage structure of primary key index 2. Query performance optimization methods 2.1. Use primary key index table 2.2. Column storage and data compression 2.3. Merge engine (MergeTree) 2.4. Data copy in conclusion Sample code: Use ClickHouse for e-commerce sales data […]
Onnx export swin transformer
1. Configure the swin transformer environment according to the repo. https://github.com/microsoft/Swin-Transformer 2. Create the file export.py in the repo directory. run `python export.py –eval –cfg configs/swin/swin_based_patch4_window7_224.yaml –resume ../weights/swin_tiny_patch4_window7_224.pth –data-path data/ –lock_rank 0` # ———————————————– ———- #SwinTransformer # Copyright (c) 2021 Microsoft # Licensed under The MIT License [see LICENSE for details] # Written by Ze […]