sql - Calculate no of rows created on daily basis from a huge table in mysql -

-

i need calculate num of rows created on daily basis huge table in mysql. i'm using

select count(1) table_name group date

the query taking more 2000sec , counting. wondering if there's optimized query or way optimize query.

if you're interested in items created on dates, calculate count @ end-of-day , store table.

that lets run count query on smaller data set (use date(now()) = date , drop group by)

then query new table when need data.


Comments

Post a Comment

Popular posts from this blog

html - Cut text on left side inside button while centering -

-
i need have button text (f.e. "add basket") fluid in width. if button width little show "add basket" must cut "basket" only. did achieve of splitting <span class="text">add basket</span> into 2 parts , reverse order them in dom <span class="text">basket</span><span class="text text-prefix">add to&nbsp;</span> and show them in correct order adding .text{ float: right; } however, text inside button must centered, not work far. here fiddle, i'd appreciate ideas: https://jsfiddle.net/5cavrrhc/ under circumstances, want avoid using js this. solution ok, here go: https://jsfiddle.net/6etabchg/4/ ok, co-worker , found solution works nicely. make button position: relative make wrapper display: flex; flex-wrap: wrap-reverse; justify-content: center; reverse order make both inner spans display: inline-block;flex-shrink: 0; make 1 span should remain or...
Read more

java - Last square of 8x8 grid not drawn, using two nested FOR loops -

-
i'm having trouble understanding why code isn't working. should display checkerboard grid 8x8, but last square doesn't drawn ! idea why? i searched see if had been asked before, , didn't find anything. in advance! code: /* * file:checkerboard.java * ---------------------- */ import acm.graphics.*; import acm.program.*; public class checkerboard extends graphicsprogram { int row, column, x, y; public void run() { // checkerboard (row = 0; row < 8; row++) { (column = 0; column < 8; column++) { // x, y, x width, y width add(new grect(x, y, 50, 50)); x = column * 50; y = row * 50; } } } } btw: book i'm reading asks use 2 nested loops ( "the art , science of java" , chapter 4, exercise 11, cs-106a) you need set x , y before drawing rectangle. otherwise, last rectangle not going display: for (row = 0; row <...
Read more

What design pattern is this code in Javascript? -

-
this question has answer here: why write “.call(this)” @ end of javascript anonymous function? [duplicate] 4 answers what kind of design pattern , significance of using closure? (function(){ // code here }).call(this); edit then difference between above code , following this keyword still refer same object in both ways. (function(){ // code here })(); thats invoked function expression. more info here: http://benalman.com/news/2010/11/immediately-invoked-function-expression/ the purpose run code while protecting scope (so variables declared within don't leak out global scope. update call sets value of this function being applied on. without it, value set window object, there set outer scope.
Read more