Post the EXPLAIN plan. Also CE version of query services is limited 4 cores and query services needs to get all the qualified data from index and do count. It also depends on how much data you count and size of indexer memory allocated, storage type etc.
@Lenty_Me , one option you can try is to give more memory for the indexer to increase the resident percent. With 17% resident, if any page needs to be fetched from the disk, that will increase the execution time.
You can experiment by running just a single scan with same input params repeatedly. If the execution time improves(and the single scan needs to access <17% of the data), that would indicate that the subsequent scans are having better cache hits.
Also, you can try using partitioned index. This can help spread out the index on multiple nodes and utilize the multiple cores, disk IO on the box and reduce the execution time significantly.
I want sum of activity by day and my work hours (8am-8pm), off hours (the rest). So for every day I’ll get 2 rows, group of work hours and … When you want to group by minute, hour , day , week, etc., you may be tempted to just group by your timestamp column. If you do that, clicker counter though, you’ll get one group … To add minutes to a datetime you can use DATE_ADD() function from MySQL . In PHP, you can use strtotime(). select date_add(yourColumnName,interval 30 minute) from yourTableName; To use the above syntax, let us create a table.
To add minutes to a datetime you can use DATE_ADD() function from MySQL* . In PHP, you can use strtotime(). select date_add(yourColumnName,interval 30 minute) from yourTableName; To use the above s clicker counter yntax, let us create a table. We can **use DATEADD() function like below to add hours to DateTime in Sql Server. DATEADD() functions first parameter value can be hour or hh all will return the same result.