What is the difference between utf8? General? Ci and UTF8? Unicode? Ci
Is there a performance difference between utf8? General? Ci and UTF8? Unicode? CI?
#1 building
I want to know the performance difference between utf8 ﹣ general ﹣ Ci and UTF8 ﹣ Unicode ﹣ Ci, but I didn't find any benchmarks on the Internet, so I decided to create my own.
I created a very simple table with 500000 rows:
CREATE TABL ...
Posted by delphipgmr on Fri, 13 Dec 2019 04:00:15 -0800
Correction of tile coordinate deviation in Gaud offline map
For map coordinate migration, take leaflet as an example, there are the following solutions
Method 1. Modify the source code of leaflet to solve the problem of map coordinate migration
Method 2. Add the true latitude and longitude of the point to the encrypted map through the offset algorithm
Method 3. Rectify the off-line map tile directly
...
Posted by nic9 on Thu, 12 Dec 2019 22:42:55 -0800
GridManager format data
GridManager When processing data, it is necessary to use the specified data format. In the actual scene, there are some format differences more or less.
How to deal with these differences will be explained here
1. Only return field name is inconsistent
Data and totals in the primary data can be adjusted by using dataKey and totalsKey.
The back- ...
Posted by xray_griff on Thu, 12 Dec 2019 06:16:29 -0800
JAVA - parse JSON from the file and write it to the JSON file (details)
1.json introduction
json is less descriptive than XML, but its data volume is smaller and its transfer speed is faster
The writing format of json data is "Name: value pair", for example:
"Name" : "John" //name For name,The value pairs are"john"Character string
The value pair types are divided into:
Number (in ...
Posted by theycallmepj on Thu, 12 Dec 2019 02:50:55 -0800
Spring cloud learning - Hystrix first understands Hystrix, and calls Feign remotely
[TOC]
1. Get to know Hystrix
Hystrix is a delay and fault-tolerant library, which aims to isolate remote systems, services and third-party libraries, organize cascading failures, and realize recovery capability in distributed systems with load.
In the case of multiple systems and microservices, a mechanism is needed to deal with delays and fail ...
Posted by Highland3r on Wed, 11 Dec 2019 20:50:56 -0800
J.U.C Analysis and Interpretation 2 (Origin of AQS)
Preface
Previously, you showed how JDK implements exclusive and shared locks by implementing custom ReentrantLock and custom ReentrantReadWriteLock.
So how do ReentrantLock and ReentrantReadWritreLock in the actual JDK source work?Can our existing custom code go any further?
The answer is yes.Note that if you look at my two previous Lock friend ...
Posted by eddie21leeds on Wed, 11 Dec 2019 18:49:38 -0800
The use and difference of Java Comparator and Comparable
First, reference
1,Usage of [java] Comparator
2,Comparison between Comparable and Comparator in Java
II. Knowledge points
1. Usage scenarios: sorting and grouping
2. Usage:
2.1 ,Arrays.sort(T[],Comparator<? super T> c);
2.2, Collections.sort(List<T> list,Comparator<? super T> c);
3. Difference:
3.1. C ...
Posted by jehardesty on Wed, 11 Dec 2019 07:43:02 -0800
Java data structure and algorithm series -- stack
Catalog
1. Basic concept of stack2. Java simulation simple sequential stack implementation3. Enhanced function stack4. Using stack to realize string reverse order5. Use stack to judge whether separator matches 6, summary
1. Basic concept of stack
Stack is also called stack or stack. As a data structure, stack is a special linear table that can ...
Posted by mattdarnold on Wed, 11 Dec 2019 00:57:25 -0800
Details of VCF file format
VCF file is called Variant Call Format, which represents the variation information of genome, usually obtained by GATK and Samtools software. The VCF file can be roughly divided into two parts:
1. Header file information starting with ×××
##fileformat=VCFv4.2
##FILTER=<ID=LowQual,Description="Low quality">
##FORMAT= ...
Posted by kla0005 on Wed, 11 Dec 2019 00:31:01 -0800
LeetCode 240 -- search two-dimensional matrix II
1. topic
2. answers
2.1. Method I
Compare from the bottom left corner of the matrix
Return true if the target value is equal to the current element;
If the target value is greater than the current element, increase j by 1 and search to the right to exclude the data above this column (all smaller than the current element);
If the target value ...
Posted by bestpricehost on Tue, 10 Dec 2019 19:32:45 -0800