Timeline for mysql select count on same table slow subquery
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 13, 2015 at 6:55 | comment | added | Nimeshka Srimal | Omitting SQL_CALC_FOUND_ROWS doesn't make much difference (only reduces ~0.01s). cdr is still a small table with 1400 records, but eventually it would get bigger as they get more and more calls with time. | |
| Apr 13, 2015 at 6:50 | comment | added | Nimeshka Srimal | Data type of calldate is datetime. I added the index as you advised, but still it takes the same time. I guess it's because I use DATE() around the field as you said.removing the DATE() makes the query run very fast like in less than 1 sec, but the problem is then it gives me a different result because I get the count from the call date. (calldate field contains both date and time, so it doesn't count record by date only.) Do you have any solution to this? Thank u very much | |
| Apr 12, 2015 at 18:37 | history | answered | Rick James | CC BY-SA 3.0 |