🔒 Closed How do you optimize the query in database

[Zyzz]

How do you optimize the query if it's fetching large data? I'm using PHP and MySQL.

Thank you.

 

[Heks]

Can you elaborate and provide example scenario?

 

[Zyzz]

Can you elaborate and provide example scenario?

Example if I query a million row of data, what is the best way to optimize it?

 

[2kmol]

Example if I query a million row of data, what is the best way to optimize it?

considering normalized database mo. dapat cguro ung mainam sa paggamit ng mga predefined functions sa sql. specific mo ung query. ex. Ung SELECT <field1>, <field2>... instead of SELECT *.

 

[pineng]

Kailangan naka normalize mga data para hindi yan redundant. Isa factor rin ang pagpili ng database. RDS vs nonrelational. SQL vs NoSQL. As well as database engine

 

[Splekenesis]

avoid redundant
kunin mo lang ung data na gusto mo if gagamit ng SELECT

 

[dev-ace]

use pagination instead

 

[Heks]

[XX='alasacelui, c: 1385425, m: 714257'][/XX] Right! pagination would make the data you display optimized.

 

[Zinchronize]

Pagination, indexing, query caching it depends on database engine

 

[IKAH]

https://phcorner.org/threads/fetchi...nput-credentials-from-mysql-database.1192027/

mga lods pa check nyu naman codes ko anong mali at kulang TIA. ta try ko pa yung select query na naka identify per td

Pagination, indexing, query caching it depends on database engine

[XX='alasacelui, c: 1385425, m: 714257'][/XX] Right! pagination would make the data you display optimized.

use pagination instead

avoid redundant
kunin mo lang ung data na gusto mo if gagamit ng SELECT

Kailangan naka normalize mga data para hindi yan redundant. Isa factor rin ang pagpili ng database. RDS vs nonrelational. SQL vs NoSQL. As well as database engine

considering normalized database mo. dapat cguro ung mainam sa paggamit ng mga predefined functions sa sql. specific mo ung query. ex. Ung SELECT <field1>, <field2>... instead of SELECT *.

Example if I query a million row of data, what is the best way to optimize it?