Beefy Boxes and Bandwidth Generously Provided by pair Networks BBQ
Problems? Is your data what you think it is?
 
PerlMonks  

Re^9: For a better efficiency and speed question!

by Anonymous Monk
on Oct 04, 2011 at 23:23 UTC ( #929687=note: print w/ replies, xml ) Need Help??


in reply to Re^8: For a better efficiency and speed question!
in thread For a better efficiency and speed question!

What is relative here is the 1 YEAR increment to the "date" and the 240 DAYS to the CURRENT_DATE. Therefore you are subtracting 1 YEAR from 240 DAYS which is 125 DAYS that you are using to add to the "date", which is relatively the something but less CPU processing time. I like that, I will try this and see how it will affect the performance of the query.


Comment on Re^9: For a better efficiency and speed question!

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://929687]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (8)
As of 2014-04-18 05:47 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    April first is:







    Results (462 votes), past polls