Re: [sqlite] Is there a performance difference between COUNT(*) and COUNT(name)

2017-09-07 Thread John Found
On Tue, 5 Sep 2017 23:31:32 +0200 Cecil Westerhof wrote: > 2017-09-05 23:11 GMT+02:00 Simon Slavin : > > > > > > > On 5 Sep 2017, at 9:21pm, Cecil Westerhof wrote: > > > > > I want to know the number of teas I have in stock.

Re: [sqlite] Is there a performance difference between COUNT(*) and COUNT(name)

2017-09-05 Thread Cecil Westerhof
2017-09-05 23:11 GMT+02:00 Simon Slavin : > > > On 5 Sep 2017, at 9:21pm, Cecil Westerhof wrote: > > > I want to know the number of teas I have in stock. For this I use: > > SELECT COUNT(Tea) > > FROM teaInStock > > > > Tea cannot be NULL, so this

Re: [sqlite] Is there a performance difference between COUNT(*) and COUNT(name)

2017-09-05 Thread Simon Slavin
On 5 Sep 2017, at 9:21pm, Cecil Westerhof wrote: > I want to know the number of teas I have in stock. For this I use: > SELECT COUNT(Tea) > FROM teaInStock > > Tea cannot be NULL, so this is the same as: > SELECT COUNT(*) > FROM teaInStock > > ​But I find the

Re: [sqlite] Is there a performance difference between COUNT(*) and COUNT(name)

2017-09-05 Thread John McKown
On Tue, Sep 5, 2017 at 3:21 PM, Cecil Westerhof wrote: > I want to know the number of teas I have in stock. For this I use: > SELECT COUNT(Tea) > FROM teaInStock > > Tea cannot be NULL, so this is the same as: > SELECT COUNT(*) > FROM teaInStock > > ​But I find the

Re: [sqlite] Is there a performance difference between COUNT(*) and COUNT(name)

2017-09-05 Thread R Smith
On 2017/09/05 10:21 PM, Cecil Westerhof wrote: I want to know the number of teas I have in stock. For this I use: SELECT COUNT(Tea) FROM teaInStock Tea cannot be NULL, so this is the same as: SELECT COUNT(*) FROM teaInStock ​But I find the first more clear. I almost always see the second

[sqlite] Is there a performance difference between COUNT(*) and COUNT(name)

2017-09-05 Thread Cecil Westerhof
I want to know the number of teas I have in stock. For this I use: SELECT COUNT(Tea) FROM teaInStock Tea cannot be NULL, so this is the same as: SELECT COUNT(*) FROM teaInStock ​But I find the first more clear. I almost always see the second variant. Is this because it is more efficient, or