Question : I am developing a real time stock price alert system that gets new prices every 1 min. There […]
Category: Performance
MySQL 5.7.21 not releasing memory after writing partition to disk
Question : I’ve been testing extracting with SELECT * from a partition in a partitioned table in MySQL 5.7.21 and […]
how to test if XML = ” in sql server?
Question : I am working with sql server 2005 and I had a situation where many values can be passed […]
MariaDB Inner join is slow
Question : Here is my SQL (with explain): EXPLAIN SELECT * FROM GBI gbi INNER JOIN VF_KRED kred ON gbi.vendor […]
Order of operation with LTRIM/RTRIM/ISNULL
Question : Does the order of operation that you place your LTRIM and RTRIM matter when used in conjunction with […]
Understanding multiple indexes with MySQL (and performance)
Question : I have a “phones” table with around 120 000 records, it contains phone_id, phone_number, phone_user_name, phone_last_contacted, etc. The […]
format of mysql query log
Question : What is the format of the mysql query log? In particular, for lines like: 133 Query commit 133 […]
How to Optimise Query
Question : I have a database structure similar to this, CREATE TABLE [dbo].[Dispatch]( [DispatchId] [int] NOT NULL, [ContractId] [int] NOT […]
Is there an actual problem in my storage IO or is the data incorrect?
Question : Running SP_Blitz indicated that I have a slow read/write performance on my drives. Reading further, I eventually landed […]
Save performance with large update on Index with Included Column
Question : Points —————— PK QuestionId int (+30.000.000 distinct values) PK EventId int (large batches where 80.000 rows have the […]