Example if I query a million row of data, what is the best way to optimize it?Can you elaborate and provide example scenario?
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?
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?