SEARCH KEYWORD -- Block
Why (offset, limit) is slow in database select?
Starting from a problem Five years ago when I was working at Tencent, I found that MySQL request speed was very slow in the pagination scenario. With only 100,000 data, a select query on a single machine took about 2-3 seconds. I asked my mentor why, and he asked in return, "In an indexing scenario, what is the time complexity to get the nth largest number in MySQL?" The pursuit of the answer Confirming the scenario Assuming there is an index on the "status" column, a query like "select * from t...
Install and use GSpace to install apps from Google Play on Huawei Harmony OS
Huawei has released its own branded mobile OS Harmony OS sometime back and some Huawei device models now support installing or upgrading to use Harmony OS. Since this OS is Huawei's own OS and it doesn't come with Google Play by default which most of the current Android apps are hosted on. In this case, how can someone install the apps from Google Play on Huawei Harmony OS or use GMS services like Google Play, Google Maps? The solution provided by Huawei is to install GSpace which is an APP cont...
HUAWEI,GOOGLE PLAY,HARMONYOS 2021-08-01 04:23:58
Google transferred a domain name to a Chinese company for free
Google just completed a domain transfer to another company in China. The interesting part is that this domain transfer is for free. The story begins with a recent tweet from the CEO Dash Huang of a Chinese game company called X.D. Network Inc who claims that they obtained the domain name taptap.cn from Google for free. From the tweet, Mr. Huang expressed his appreciation to Google for freely transferring the domain name taptap.cn to their company. Their company launched some product ...
Encrypting and decrypting PGP file or text on MacOS
When doing data exchange among different parties, there is a frequent need of encrypting data or file and sending it to partner and asking partner to use corresponding key to decrypt the data or file. A famous way of exchanging data is using asymmetric keys where no secret key needs to be shared. One party can just use the public key shared by partner to encrypt the data and the other party uses the private key to decrypt the data. Today, we will introduce how to use PGP to encrypt and decrypt d...
PGP,GPG,ENCRYPTION,DECRYPTION,TUTORIAL 2020-10-29 05:06:09
Certificate is invalid for localhost in Chrome
...
CHROME,LOCALHOST,HTTPS,CERTIFICATE,ELASTICSEARCH 2022-03-16 08:21:27
Why Math.min() > Math.max() is true in JavaScript
...
JAVASCRIPT,MATH.MIN(),MATH.MAX(),COMPARISON 2022-05-02 05:27:07
RECENT
- Tips for Socializing With Friends During College
- Proximity Cards Do More Than Just Open Doors
- How to choose quality painted auto parts
- Oval engagement rings from MoonOcean: Elegance of form and individual approach
- Hologres vs AWS Redshift
- GoLand connect to Hologres
- A journey to investigate a goroutine leakage case
- Understanding Slice Behavior in Go
- Breaking Barriers: How 3D Printing is Democratizing Product Development
- The Power of Efficiency: 10 Practical Energy-Saving Tips for Tech Startups
- more>>