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 - database-performance

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

Why INSERT query is 3-4 times slower than SELECT?

Application talks to YugabyteDB instance with YCQL driver(Gocql). We have below two queries (for example): SELECT col2, col3, col4, col5 FROM table1 WHERE primarykeycol = 11ab8...
test-img

overexchange

sql

database-performance

sql-execution-plan

explain

yugabytedb

Votes: 0

Answers: 2

Latest Answer

If your RF > 1, insert operations go through a distributed transaction cycle whereby records are stored on a majority of replicas (if RF=3, then 2; if RF=4, then 3, it RF=7, then 5). However, in th...
test-img

dh YB

Is there any performance loss when using ANSI data types in Oracle?

If I use any ANSI supported data types like INTEGER, NUMERIC, REAL etc., as a data type for a column, or a variable in PL/SQL, will it have an additional cost for the database? What are the pros and c...
test-img

oramas

oracle

query-optimization

database-performance

database-administration

sqlperformance

Votes: 0

Answers: 1

Latest Answer

ANSI data-types are just aliases for Oracle data types and will be converted to the equivalent Oracle data type. From the documentation: ANSI, DB2, and SQL/DS Data Types SQL statements that create ta...
test-img

MT0

Best indexes to optimize a large MySQL table?

So I have a MySQL table with over 10 millions rows. A new row is created every time a new download is made and this row is updated when the file is downloaded again (the download count is updated). To...
test-img

fraxool

mysql

sql

database-design

database-performance

Votes: 0

Answers: 3

Latest Answer

An index on the two columns (user_id, product_filed_id) would narrow down the search partially, but why not narrow it down exactly to the row you're searching for? ALTER TABLE `product_files_downloads...
test-img

Bill Karwin

Posts

Questions

Blogs

Jobs