I have a heavy site with over 200,000 articles When searching in WordPress, this search looks for the desired word in the title, content, and excerpt In this number of articles, the result of slow query is more than 50…
I have the following table in PostgreSQL v14: postgres=# d orders Table "public.orders" Column | Type | Collation | Nullable | Default -------------+---------+-----------+----------+------------------------------------ id | integer | | not null | nextval('orders_id_seq'::regclass) customer_id | integer | | not null |…
I want to optimize the following DB SELECT query: SELECT ls.caller_id, ls.caller_path_id, ls.caller_path_name, ls.caller_data->>'worker' AS worker, ls.caller_stage, ls.current_status, ls.date_inserted AS date_closed, ls.caller_data->>'name' AS firstname, ls.caller_data->>'surname' AS surname, ls.caller_data->>'cell' AS cell, ls.caller_data->>'home' AS home, ls.caller_data->>'work' AS work, ls.caller_data->>'other' AS other FROM…
I've a simple query that is taking way to much time to process, the query is very simple and the WHERE clause has just simple comparators but the query takes between 15 to 20 secs to process in a 256gb…
update 20M records in table and set col1 = col2 + col3 for each record using spring boot. try (Connection connection = dataSource.getConnection()) { String updateQuery = "UPDATE table SET col1 = ? WHERE id = ?"; PreparedStatement preparedStatement =…
I have 2 tables with flex one-to-many relationship, meaning the parent side may not have any child: Parent_table id dim1 quantity price 1 "abc" 1 1.00 child_table: id parent_id 1 1 2 1 The parent query is very straight forward:…
I have an archive table in which only the changes to a record are stored with a validity date. An example would be a price archive for products. And if you now want to select the status at a given…
Doing self join with same table with range condition. The below is sql statement. select current_rec .* ,compare_rec.employee_id as less_salary_employee from hr.employees current_rec left join hr.employees compare_rec on current_rec.hire_date < compare_rec .hire_date and current_rec.salary < compare_rec.salary order by current_rec .employee_id…
I have a query which first performs joins inside cte and then based on cte join with other table and perform group by with some aggregations and get the top 15 records. WITH join_table as ( SELECT pl.yearmonth, pl.pdid, pl.OrderId,…
I have the following two tables: CREATE TABLE `ip_info` ( `start_ip` int(10) unsigned NOT NULL, `end_ip` int(10) unsigned NOT NULL, `country_code` varchar(3) DEFAULT NULL, `country_name` varchar(255) DEFAULT NULL, `continent_code` varchar(3) DEFAULT NULL, `continent_name` varchar(255) DEFAULT NULL, `asn` int(10) unsigned DEFAULT…