python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - query-optimization

Which is faster for checking, sql/database query or file_get_content?

I have this type of data which i call ids I have 8.6M of these ids which i use for "validity" check. tt9916820 tt9916822 tt9916824 tt9916826 I was wondering which would be better & fast...
test-img

Amenadiel

mysql

performance

query-optimization

file-get-contents

database-performance

Votes: 0

Answers: 2

Latest Answer

If the file does not change often then you should import it into a table and create an index on the column you want to search on. A query on an indexed column should be much faster than: fetching an ...
test-img

Salman A

PostgreSQL check if values in a given list exist in a table

Given below table in Postgres: id some_col 1 a 1 b 2 a 3 a I want to get output as id and true (if at least one row with that id is present in the table) or false (if no rows with th...
test-img

Forece85

sql

postgresql

performance

optimization

query-optimization

Votes: 0

Answers: 1

Latest Answer

The in clause won't do it. You need to build a list of values somehow (the values table valued constructor works in most rdbms) and outer join with it: SELECT x.id, EXISTS ( SELECT * FROM t ...
test-img

Salman A

MariaDB: Using PK for inner query result

I have three tables (MariaDB 10.6.5): person, private_person and corporate_person. In the person are Ids stored, in the other tables are names stored, both connected to the person per FK: CREATE TABLE...
test-img

Dave_B.

mysql

indexing

mariadb

subquery

query-optimization

Votes: 0

Answers: 2

Latest Answer

It's the OR operations that doom your query. WHERE `p0`.`FirstName` = 'Test' OR p0.LastName = 'Test' OR `c0`.`Name` = 'Test'; This is a common problem with query optimization, given that MySQL uses...
test-img

Bill Karwin

SQL Server non-clustered index and the query optimizer

In one of the projects I am working on, there is a table which has about one million records. For better performance I created a non-clustered index and defined sid field as index key column. When I e...
test-img

mahooresorkh

sql

sql-server

query-optimization

Votes: 0

Answers: 1

Latest Answer

I believe that the problem is in the size of your result. You are selecting ten thousand records from your database which is quite a lot if you consider the necessary query plan that would include ind...
test-img

Radim Bača

Posts

Questions

Blogs

Jobs