Re: [PERFORM] MYSQL Stats

2016-10-03 Thread Gavin Flower
On 01/10/16 01:03, Joe Proietti wrote: Hi, I am relatively new to MYSQL and not really sure I am in the right forum for this. [...] If your data is important to you, then PostgreSQL is safer! I've used both MySQL & PostgreSQL, and that latter is easier to use. Cheers, Gavin -- Sent vi

Re: [PERFORM] MYSQL Stats

2016-09-30 Thread Joe Proietti
@postgresql.org Subject: [PERFORM] MYSQL Stats Hi, I am relatively new to MYSQL and not really sure I am in the right forum for this. I have a situation which I am not understanding. I am performing a simple query : Select * from tableA Where date >= ‘2016’06-01’ And date < ‘2016-07-01’ Index is o

[PERFORM] MYSQL Stats

2016-09-30 Thread Joe Proietti
Hi, I am relatively new to MYSQL and not really sure I am in the right forum for this. I have a situation which I am not understanding. I am performing a simple query : Select * from tableA Where date >= ‘2016’06-01’ And date < ‘2016-07-01’ Index is on date Query returns 6271 rows When doing