Questions about query-optimization
Read more about query-optimization
python (65.2k questions)
javascript (44.3k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (13k questions)
SQL Match Against Fulltext Index is slow when searching common terms
Simple PHP search page with three fields querying a MySQL database with millions of rows. The data consists of profiles, mostly USA.
Fulltext indexing increases speed by a factor of 9.6 when the searc...
Ned Hulton
Votes: 0
Answers: 2
Improving the performance of a MYSQL query with a one-to-many relationship
I have a query in my DB that is taking 25 seconds to return results, which is way too long. It seems like it should be pretty simple. Two tables; the main table (document) is a standard table with som...
William
Votes: 0
Answers: 1
MySQL Explain plain doesn't show index used when it should be
I'm trying to run a query in MySQL that's timing out after a couple of minutes on a QA system with 8 million+ rows. It runs fine for me locally, but obviously less data.
Here's the query:
SELECT
...
Jack BeNimble
Votes: 0
Answers: 0
mariadb - join/order by clauses cause slow query
have a small blog site, host provider runs Server version: 5.5.5-10.3.34-MariaDB-cll-lve MariaDB Server. The last weeks i noticed fetching the posts is slower, and it turns out the query now takes 6 s...
ilias-sp
Votes: 0
Answers: 1