MYSQL query slow SELECT DISTINCT – Phpmyadmin
I want to output the most used search items of my classifieds of the last 3 days I have an extra table where I save all search items together with the day and a counter which increments if the search…
Improve sql code performance for a mariaDB query – Phpmyadmin
I developed an application connected to mariaDB (Ver 15.1 Distrib 10.1.31-MariaDB, for Win32) in DelphiXE8. I want to improve query performance. Describe the simplified scenario: de_User Table (innoDB) (rows 81762) ID_U INT PRIMARY KEY Name VARCHAR(30) INDEX ID_U, Name de_doc…