Tag: sql

The back-end

SQL Statement Optimization and “Best Practices” for MySQL in Big Data and High Concurrency Scenarios

January 23, 2024

by Denise Smith-Lewis

No Comments

Reduce the impact of the query result set and avoid full table scan. Impact result sets are at the heart of SQL optimization. The impact...

Read More

The back-end

MySQL transaction isolation level

January 23, 2024

by Melissa Evans

No Comments

Recently learning MySQL related knowledge, just learned this knowledge point, sorted out and everyone to learn together. All SQL statements contained in a transaction either...

Read More

reading

It’s time to learn the real Spark technology

January 23, 2024

by 徐馨儀

No Comments

Spark SQL is the best part of Spark. I think the overall complexity is more than 5 times that of Spark Streaming. Spark streaming maintenance...

Read More

The back-end

Decount using HyperLogLog on Postgres

January 23, 2024

by Antonio Robertson PhD

No Comments

It is very common to run SELECT COUNT (DISTINCT) on a database. In applications, there are usually large analysis screens that highlight the number of...

Read More

The back-end

General steps for tuning SQL statements

January 23, 2024

by Melissa Miranda

No Comments

Identify the problem and take the corresponding optimization measures, basically can confirm the cause of the problem. At this time, appropriate measures can be taken...

Read More

reading

The type of the mysql table field

January 23, 2024

by Shane Wright-Parkinson

No Comments

INT - An integer of normal size, which can be signed. If it is signed, it is allowed to range from -2147483648 to 2147483647. If...

Read More

The back-end

Mysql optimization

January 23, 2024

by Renee Rose

No Comments

1. Reduce IO times IO is always the database is the most easy bottleneck, which is determined by the responsibility of the database, most of...

Read More

The back-end

Find out: Use MaxCompute Studio to analyze SQL jobs

January 23, 2024

by Manikya Bhatti

No Comments

A common question for MaxCompute users is: Why is the same periodic task slower in recent days than before? Or why a job that used...

Read More

The code of life

Five years of Java development career, a bloody project firefighting (why programmers suffer programmer)

January 23, 2024

by 周琬婷

No Comments

I am now working in a medium-sized Internet enterprise. The salary and treatment I got at the end of last year are very good, but...

Read More

The back-end

From SQL Server to MySQL (3) : Open Source power

January 23, 2024

by Anna Saunders-Baker

No Comments

Introduce our problems and solutions. The core ETL tool is YuGONG. It and Otter/Canal are both products of ali middleware team. Otter, on top of...

Read More

The back-end

Some restrictions on timestamp from MySQL·5.6

January 23, 2024

by Charles Cervantes

No Comments

At first I thought it was the SQL that was written wrong, so I routinely checked the SQL, but still did not find the problem....

Read More

The back-end

Oracle APEX series article 9: Why use Oracle APEX

January 23, 2024

by 崔淑華

No Comments

This article is a translation of Oracle APEX. If you don't already know what Oracle APEX is, please read another article of mine: Oracle APEX:...

Read More

reading

JEESZ module development

January 23, 2024

by Frances Jones

No Comments

Do not omit these fields when creating a table.

Read More

The back-end

“Shallow in shallow out” MySQL and InnoDB

January 23, 2024

by Riley Cochran

No Comments

As a developer, it is inevitable to come into contact with database in daily work, whether it is file-based SQLite or MySQL and PostgreSQL, which...

Read More

The back-end

Druid nested groupBy for precise recalculation

January 23, 2024

by Matthew Brennan

No Comments

Druid nested groupBy exact de-count of sample SQL corresponding to JSON

Read More

The back-end

Ten Java optimization Strategies that Java Programmers should know to make your System run

January 23, 2024

by 余雅琪

No Comments

StingBuilder should be used by default in our Java code and the + operator should be avoided. You might disagree with the syntax sugar for...

Read More

reading

PreparedStatment [PreparedStatment, batch processing, binary processing, automatic primary key, call stored procedures, functions]

January 23, 2024

by Molly Sellers

No Comments

Tags: JDBC1. PreparedStatement object PreparedStatement object inheritance Statement object, it is more powerful than the Statement object, use rise more simple Statement object compilation

Read More

reading

SparkSQL: Convert RDD to DataFrame using reflection, programmatically

January 23, 2024

by Lisa Davis

No Comments

Why convert RDD to DataFrame? In this way, Spark SQL can be used for SQL queries directly against any data that can be built as...

Read More

reading

Mysql Stored Procedure Basics (Example + Code)

January 23, 2024

by 郝淑華

No Comments

I have been using stored procedures a lot in my recent project development, so I want to share a basic stored PROCEDURE with a simple...

Read More

The back-end

Jingdong architect said: distributed database system evolution road

January 23, 2024

by Aniruddh Sule

No Comments

Regarding the use of database, there are several trends in JD. In the early stage, JD mainly used SqlServer and Oracle, and MySQL was also...

Read More

reading

Teach you to use a SINGLE SQL to solve cross-database query problems

January 23, 2024

by Debra Atkinson

No Comments

After a database is split, data is distributed to different database instances, reducing the amount of data and increasing the number of database instances. However,...

Read More

reading

MySQL prefix index and a similar implementation of Oracle

January 23, 2024

by Lori May

No Comments

MySQL has an interesting index type called prefix index, which can reduce the index size by indexing the first part of a text field separately....

Read More

reading

JEESZ module development documentation

January 23, 2024

by Mamooty Din

No Comments

Create_by, create_date, update_BY, update_date, Remarks, and del_flag are indispensable. Do not omit these fields when creating a table.

Read More

The back-end

Chapter 29 SQL Commands DISTINCT

January 23, 2024

by Vedika Dube

No Comments

Small knowledge, big challenge! This article is participating in the creation activity of "Essential Tips for Programmers". Chapter 29 THE SQL command DISTINCT specifies a...

Read More

reading

Talk about the three major databases which you prefer

January 23, 2024

by Emily Brown

No Comments

Oracle runs on all major platforms (including Windows). Fully supports all industry standards. Adopt a fully open strategy. Customers can be enabled to choose the...

Read More

The back-end

Proficient in SpringBoot: Integrate Druid to monitor SQL execution

January 23, 2024

by Ellie Taylor

No Comments

Cough, today we do something simple and practical, using Springboot to integrate Alibaba's Driud database monitoring tool.

Read More

The back-end

Usql – an open source multi-database unified command line tool

January 23, 2024

by Yasmin Sachar

No Comments

Supports PostgreSQL, MySQL, Oracle, SQLite, and Microsoft SQL Server.

Read More

The back-end

MySQL UPDATE statement a “classic” pit

January 23, 2024

by 梁信宏

No Comments

One careless fall for it!

Read More

reading

Oracle waits for events and solutions

January 23, 2024

by Jonathan Johnson

No Comments

The v$session_wait view can be used to view the current wait events on the system and the information about the resources corresponding to the wait...

Read More

The back-end

A slow SQL is causing the shopping cart service to be unusable

January 23, 2024

by Joanna Murphy

No Comments

I have dealt with a shopping cart malfunction before, and I think it is quite classic. I would like to share it with you here....

Read More