Get number of houses from array?

Linear Mode

Vince
Spam Machine

Posts: 10,066
Threads: 38
Joined: Sep 2007
Reputation: 0

29.05.2016, 16:23

If the only purpose of a query is to get a count of something then the COUNT() aggregate function should be used. Sending over a single value is obviously much faster than sending over an entire result set which isn't going to be used.

Find

« Next Oldest | Next Newest »

Messages In This Thread

Get number of houses from array? - by CloudLEL - 29.05.2016, 11:25

Re: Get number of houses from array? - by iKarim - 29.05.2016, 11:30

Re: Get number of houses from array? - by CloudLEL - 29.05.2016, 11:36

Re: Get number of houses from array? - by DRIFT_HUNTER - 29.05.2016, 11:52

Re: Get number of houses from array? - by Konstantinos - 29.05.2016, 11:59

Re: Get number of houses from array? - by DRIFT_HUNTER - 29.05.2016, 16:01

Re: Get number of houses from array? - by Vince - 29.05.2016, 16:23

Re: Get number of houses from array? - by AlexBlack - 29.05.2016, 16:25

View a Printable Version

Forum Jump:

Users browsing this thread: 1 Guest(s)

Login
Username:
Password:	Lost Password?
	Remember me