Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When executing a SQL SELECT COUNT x statement is the data loaded into memory and then counted or is the count done in the DB and then returned?
Count is done in the DB and then returned to QV.
Count is done in the DB and then returned to QV.
Only the result of the request is loaded in memory.
Consequently, a "select *" will load all data of the DB table while "select count(*)" will just the load the result of the count.