Showing entries 161 to 170 of 43504
« 10 Newer Entries | 10 Older Entries »
Performance Improvements in MySQL 8.0.35

This blog post highlights the significant performance improvement made in the latest 8.0 version of MySQL Enterprise Edition

EXPLAIN INTO and EXPLAIN FOR SCHEMA in MySQL

In MySQL 8.1 and 8.2 we introduced EXPLAIN INTO and EXPLAIN FOR SCHEMA respectively, two extensions to the EXPLAIN query that can help doing most of your query optimization in the server, rather than a client program. These two features lay the groundwork for automatically running multiple EXPLAINs over multiple schemas without having to manually USE each schema or reenter the EXPLAIN output.

MySQL Workshop at HKCE and PyCon HK2023 - recap.

PyCon & HKCE 2023

Index Selectivity

Introduction In this article, we are going to see how Index Selectivity works in relational database systems and why the database Optimizer might choose to avoid using an index if the number of matching records is large. Index selectivity is inversely proportional to the number of index entries matched by a given value. So, a unique index has the highest selectivity because only a single entry can be matched by any given value. On the other hand, if column values are skewed, then a column value matching a large number of table... Read More

The post Index Selectivity appeared first on Vlad Mihalcea.

Node.js MySQL Insert Record

We already have a tutorial on how to connect to the MySQL database using Node.js. Well, you can read it if you want to know, but it only allows you to interact with the database, what if you want to insert some new records directly from Node.js? You can also easily do this by executing […]

Thoughts on the October 2023 MySQL Releases

A few days ago, Oracle released three new MySQL GA versions: 8.2.0, 8.0.35 and 5.7.44.  I skimmed the release notes (8.2.0, 8.0.35 and 5.7.44), and I am not impressed.  I guess that I would be even less impressed / more disappointed if I had checked in greater detail, and if I had reviewed the 8.1.0, 8.0.34 and 5.7.43 release notes.  The subject of my disappointment is Oracle not

Newsletter Repost: Developer Interview With Marian Pop – OpenLampTech

PHP developer and Laravel content creator Marian Pop shares a fantastic developer interview with the OpenLampTech newsletter readers.

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

Welcome to this OpenLampTech text-based developer interview.

PHP developer Marian Pop is very active in the Laravel community.

Marian writes a daily blog, and a newsletter, and has a podcast – all covering Laravel.

Subscribe to OpenLampTech to read this interview and more.

[Read more]
Three surprising benefits of sharding a MySQL database

There is more to sharding than simply increasing data throughput. In this article, we explore three different benefits of sharding your database.

Newsletter Repost – OpenLampTech issue #105

SQL Upserts | WordPress nonces | WordPress CLI | Microservices with PHP | Laravel vs Symfony. OpenLampTech is a media and content source for PHP, MySQL, and the LAMP stack.

Custom WooCommerce and Shopify Solutions

Discover useful WooCommerce and Shopify custom solutions for your online store today at affordable prices!

Learn More

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

Thanks for your interest in the OpenLampTech newsletter. …

[Read more]
How to Connect to SQL Server in Delphi with Devart SDAC

We will walk you through the process of connecting to SQL Server using Devart SDAC, including installation and examples of how to interact with the components.

The post How to Connect to SQL Server in Delphi with Devart SDAC appeared first on Devart Blog.

Showing entries 161 to 170 of 43504
« 10 Newer Entries | 10 Older Entries »