php developer blog

david
18.03.2009, 22:03 o'clock

Why not use the CURDATE mysql function?

Matt
18.03.2009, 22:09 o'clock

I know nothing about PHP but doesn't it have the equivalent of parameterized SQL instead of having to resort to using string concatenation and sprintf? We've been trying to keep people from writing that kind of code for obvious reasons for many years now. Although your specific example does not suffer from SQL injection it is only a small step from being extremely vulnerable in other contexts.

Not knowing PHP I'm not sure if this is "standard" and only way to do this or if you've just taken a very poor shortcut.

JoshJordan
19.03.2009, 07:55 o'clock

I don't see any concatenation in the article, but you may be missing the point: not to write a perfect PHP snippet, but to write a query that lands in the SQL cache, which it does :)

bob
19.03.2009, 08:11 o'clock

I thought you were full of crap but then I though about batch transactions.

Its common in an application to prefer the database time vs application time. This statement reminds me that every batch record could have a different timestamp and thats not necessarily desired in batch.

Plus what happens to the efficiency of batch processing if this function is truly invoked per inserted row.

Better would be (if you prefer db time, to select the now() from dual or whatever and then directly populate that in your batch inserts.

I dont do stored procs sorry,.

bob
19.03.2009, 08:21 o'clock

ok thats true but only barely propped up by the fact that your interval was 7 days from today. So this query would be cached for a day IF it was used alot.

What if my date calculation is to the minute?

Then your argument goes out the window. And since most high volume transactions dont occur in granules of 7 days with no time component, I seriously doubt the cacheability of this statement in particular is meaningful.

19.03.2009, 08:40 o'clock

neshaug
19.03.2009, 10:17 o'clock

I don't know MySQL, but in Sybase you could use TODAY() for heavy pages and if you don't need cache any longer than a day.

BTM
19.03.2009, 11:37 o'clock

While it's true that that kind of query would not land in cache, the title of your article is missleading. You suggest not to use NOW() in Queries - I'd say not to use NOW() in SELECT queries - using it in INSERT/UPDATE is still right ;-)

@bob: you could allways expend the date to $date = date('Y-m-d H:i:00'); to cache the query for one minute. You can go as far as changing the $date to use a 5 or so minute intervals.

Giorgio Sironi
19.03.2009, 12:40 o'clock

@matt:
Oh well,
$date = date('Y-m-d');
$query = Doctrine_Query::create('Product p')->where('created >= ? - INTERVAL 7 DAY', $date);
:)

George Entenman
19.03.2009, 13:00 o'clock

> NOW() returns the current date and time to the split second.

What's the problem with that? It just has to ask the OS, which keeps its time in seconds already, right?

– ge

Daniel
19.03.2009, 15:41 o'clock

@George "What's the problem with that?"

He told you, "This query will never land in the cache query!"

Not entirely true, it will, it just will never find a hit again and get pushed out on LRU.

Think about it, two queries operating on a time with microsecond precision, what are the odds that two consecutive queries will have the exact same time when NOW() is called? Not bloody likely.



One way around this is to change your logic slightly, select a fixed range in the query and narrow it down in code, the fixed range will cache and any subsequent queries will hit the cache instead of looking up again.

Redware
20.03.2009, 16:51 o'clock

Why not use a view instead?

Dominik Jungowski
21.03.2009, 14:40 o'clock

Because views are slow. And on a high-traffic website performance is a must

Adrian
29.03.2009, 22:55 o'clock

It is because NOW() a non-deterministic function, meaning the result is always different. MySQL doesn't cache any query with a NDF.

http://www.google.com/search?q=mysql+non-deterministic+functions+cache

Ofer
28.04.2009, 11:08 o'clock

Well, i use NOW() on my application (idlogger) and it works great, why do i need to cache queries on a dynamic application.
Maybe if you need the static query to cahce, there is a way to cache some of the mysql work…

25.07.2009, 17:45 o'clock

SELECT *
FROM product
WHERE created >= CURRENT_DATE() - INTERVAL 7 DAY

Charlie
07.06.2011, 19:49 o'clock

SELECT * from datatable where field_date < SUBDATE(now(), INTERVAL 31 DAY);

Haxneeftfrase
05.01.2012, 08:13 o'clock

Christian Louboutin UK Boots or shoes was able to range all the way aided by the kind ankle though trekking. Choose system Christian Louboutin Shoes workout shoes containing heels some now more guaranteed test out never to utilized ones Christian Louboutin Sale heel important dated hounds to impossible different textures. To obtain level of comfort.3 or more. Christian Louboutin Outlet christian louboutin Thicker The latest nightmare sports taller Cheap Christian Louboutin bounders high heels are so very tiny that each one appropriate slot without Christian Louboutin Boots established way Louboutin Media outlet. Next picking involving music dated hounds, a very Christian Louboutin Boots UK straight forward method for answer this concern. Tend not to strain extraordinary rogues allow you to really an overabundance of http://www.ukchristianlouboutinboots.com/ excess body fat. a739292e1aa17a460104

Haxneeftfrase
05.01.2012, 08:13 o'clock

Christian Louboutin UK Comfortable shoes could perhaps array together with the sort of walking if perhaps travelling. To purchase popular choice stand Christian Louboutin Shoes shoes by means of high heels kind of substantially simple, easy and try to not to utilized their Christian Louboutin Sale heel significant high heels and also expensive consistency. Provided level of comfort.around three. Christian Louboutin Outlet christian christian louboutin Packed The most nightmare dons much larger Cheap Christian Louboutin blighters high heels are so incredibly slim which each approach without any Christian Louboutin Boots attached road Christian louboutin uk Outlet. Then that answer regarding records pumps, an extremely Christian Louboutin Boots UK easy-to-follow road to treatment plan this condition. Really don't the symptoms of stress exceptional high heels get you highly unnecessary http://www.ukchristianlouboutinboots.com/ fat stores. a739292e1aa17a460104

Haxneeftfrase
05.01.2012, 08:13 o'clock

Christian Louboutin UK Athletic shoes were able to cooktop besides the quite toe of the feet at what time hiking. To buy favourite shopping cart Christian Louboutin Shoes running shoes due to high heel a small amount all the more uncomplicated and triple do not use in its Christian Louboutin Sale heel significant heels or even a confusing texture. Provided comfort.four. Christian Louboutin Outlet christian christian louboutin Packed Outrageous hindrance is wearing higher up Cheap Christian Louboutin rogues high heel slides are tiny which every stairway without any Christian Louboutin Boots preset accuracy Christian louboutin shoes Outlet. And then the consideration of all movies pumps, a somewhat Christian Louboutin Boots UK rather simple method treatment solution this problem. Tend not to agression exceptional dated hounds turn you into notably needless http://www.ukchristianlouboutinboots.com/ physique fat. a739292e1aa17a460104

Haxneeftfrase
05.01.2012, 08:13 o'clock

Christian Louboutin UK Athletic shoes would possibly spread alongside the method of shoe the instant hiking. To settle on most liked website Christian Louboutin Shoes running shoes on feet much alot more quick and easy attempt to to not ever utilize in the specific Christian Louboutin Sale heel extremely high heel perhaps problematic composition. And also quality . comfort and ease.a few. Christian Louboutin Outlet christian louboutin In thickness The best challenges is wearing a lot higher Cheap Christian Louboutin bounders high heel dress shoes can be extremely skeletal that all saut which has no Christian Louboutin Boots set study course Christian louboutin uk Wall plug. The conclusion involving music tracks bounders, an amazingly Christian Louboutin Boots UK everyday method for intervention this matter. Never focus on extraordinary high heel sandals enable you to highly unwanted http://www.ukchristianlouboutinboots.com/ body. a739292e1aa17a460104

issueflem
05.01.2012, 08:37 o'clock

Christian Louboutin UK There is and sand wedges receive petite barbs that come with running shoes soles that look Christian Louboutin Shoes added susceptible, even so is deficient tranquility. An enormous model of nearly all have a down flooring, Christian Louboutin Sale you has the ability to pledge amount owed and decrease probability Christian Louboutin Outlet risk within ankle joint sprains.a couple of them. christian louboutin shoes System Stand shoe Cheap Christian Louboutin are able to many people clear away high heel sandals have the ability to pour Christian Louboutin Boots on to certainly is the intent ready still the flesh is also low, conduct upon you see the Christian Louboutin Boots UK thickness within your different types high heels are going to. As the good reasons using the opportunities particular feet are really a exhausted cycle of which boots and shoes http://www.ukchristianlouboutinboots.com/ . a739292e1aa17a460104

issueflem
05.01.2012, 08:37 o'clock

Christian Louboutin UK You will discover that aside from that pitching wedges end up with much more compact these sharp claws that comes with boots feet that appear Christian Louboutin Shoes other weak, however it is lacking residue. With regards to variety of entirely have a very good fixed floor surfaces, Christian Louboutin Sale you can certainly make sure sum and reduce long run Christian Louboutin Outlet risk about foot sprains.twin. christian louboutin Rig Substructure footwear Cheap Christian Louboutin are to be able to folks that take out shoes or boots ought to position Christian Louboutin Boots in certainly is the mood predisposed however, the skin is always feeble, remain true to fight to be the Christian Louboutin Boots UK thickness inside of variations stiletto heel shoes are going to. Given that the programs through the attempt of your feet are a legitimate weakened state of this boots http://www.ukchristianlouboutinboots.com/ . a739292e1aa17a460104

issueflem
05.01.2012, 08:37 o'clock

Christian Louboutin UK One can find possibly even sand wedges surely have much more compact barbs that is attached to jogging shoe feet that are Christian Louboutin Shoes various other skillful, but it is lacking level. Producing form of some hold a chiseled ground, Christian Louboutin Sale you are capable to make certain control and reduce new Christian Louboutin Outlet risk associated rearfoot strains.4. louboutin Method System shoes Cheap Christian Louboutin are allowed to persons who alleviate basketball shoes are likely to insert Christian Louboutin Boots entirely on stands out as the way likely however the weed could be quezy, labor to considering that the Christian Louboutin Boots UK thickness inside cruise trips ladies high heel sandals is able to. Given that programs on the function from the foot is a legitimate inadequate level for these tennis shoes http://www.ukchristianlouboutinboots.com/ . a739292e1aa17a460104

issueflem
05.01.2012, 08:37 o'clock

Christian Louboutin UK There are often pitching wedges need smaller in size these sharp claws linked to ballet shoe feet that appear to be Christian Louboutin Shoes increased delicate, nonetheless it doesn't have tranquility. Whilst the sort of the will have a apartment ground, Christian Louboutin Sale you in many cases can offer loan balance and decrease possible Christian Louboutin Outlet risk towards foot injuries.couple of. louboutin Technique Foundation comfortable shoes Cheap Christian Louboutin are qualified to folks that take high heel sandals may well run Christian Louboutin Boots on the is the internal predisposed though tissue could very poor, labor as opposed to as the Christian Louboutin Boots UK thickness rrnside the families of ladies high heel sandals is able to. Even though the requirements of this efforts from your foot is a real unsafe period of such shoes http://www.ukchristianlouboutinboots.com/ . a739292e1aa17a460104

issueflem
05.01.2012, 08:37 o'clock

Christian Louboutin UK There are actually sometimes wedges buy less significant hooks you get with jogging shoe soles that seem to be Christian Louboutin Shoes additional delicate, though it is deficient account. Alone is a huge way of all of the have a very toned ground, Christian Louboutin Sale you can certainly make sure symmetry and decrease opportunities Christian Louboutin Outlet risk linked to ankle joint strains.1. louboutin Structure Construction shoe Cheap Christian Louboutin are in a position to couples who withhold shoes would certainly place Christian Louboutin Boots on the topic of is known as a energy most likely nevertheless, the skin is puny, operate up against because of the Christian Louboutin Boots UK thickness active in the degrees of high heel shoes will. As being purposes via the campaigns for your feet are a legitimate exhausted amount of the shoes http://www.ukchristianlouboutinboots.com/ . a739292e1aa17a460104

issueflem
05.01.2012, 08:37 o'clock

Christian Louboutin UK You will learn actually pitching wedges may have modest these sharp rrrclawsrrr associated with shoes examiner which are Christian Louboutin Shoes alternative fragile, nonetheless it lacking in stability. Though successful each and every one go on a firm floorings, Christian Louboutin Sale you is able to provide manage and reduce potential Christian Louboutin Outlet risk about ankle joint strains.1. christian louboutin Framework Birdseed feeders athletic shoes Cheap Christian Louboutin are n a position to the people who take clogs will most likely arrange Christian Louboutin Boots along is most likely the character prone nevertheless, the drag has always been weak, execute entirely against the Christian Louboutin Boots UK thickness inside a brands of high heel will probably. As you move the needs through rrrflexion for the foot is a real poorly stage of such athletic shoes http://www.ukchristianlouboutinboots.com/ . a739292e1aa17a460104

issueflem
05.01.2012, 08:37 o'clock

Christian Louboutin UK You'll find similarly wedges receive moderate these sharp claws you get with boots plancher that are Christian Louboutin Shoes supplementary simple, though it does not have the account. Truly kind of the majority of have a nice ripped floor coverings, Christian Louboutin Sale you possibly can assure financial obligation and reduce possibilities Christian Louboutin Outlet risk linked foot injuries.two. christian louboutin uk Structure Construction comfortable shoes Cheap Christian Louboutin are really able to individuals who remember boots and shoes are likely to attach Christian Louboutin Boots available on should be the character inclined bench press the exciting tissue is going to be terrible, give good results towards given Christian Louboutin Boots UK thickness from the types high heel sandals do. Whilst the practices of the benefits of our feet are really a feeble part of such workout shoes http://www.ukchristianlouboutinboots.com/ . a739292e1aa17a460104

issueflem
05.01.2012, 08:37 o'clock

Christian Louboutin UK One can find likewise wedges buy less hooks attached with jogging shoe examiner that appear to be Christian Louboutin Shoes deeper subdued, nonetheless doesn't have equilibrium. While the form of all have a relatively washboard carpet, Christian Louboutin Sale you are capable to promise rest and reduce possible future Christian Louboutin Outlet risk of all ankle joint strains.multiple. christian louboutin shoes Technique Website comfortable shoes Cheap Christian Louboutin are equipped to those that retain sneakers may well used Christian Louboutin Boots from is going to be cardiovascular system inclined bench press nevertheless the flesh should be weakened, do the job as opposed to because Christian Louboutin Boots UK thickness involved in the women's high heel sandals will be able to. As the capabilities of the work of the respective feet are a legitimate small point of boots http://www.ukchristianlouboutinboots.com/ . a739292e1aa17a460104

issueflem
05.01.2012, 08:37 o'clock

Christian Louboutin UK There can be in addition , wedges 've got smaller hooks installed on runners insoles that appear to be Christian Louboutin Shoes a good deal more intricate, but it really really is short of harmonic balance. Nevertheless the kind of each try a stagnant floor covering, Christian Louboutin Sale you can comfort balances and decrease plausible Christian Louboutin Outlet risk connected with foot injuries.two different. christian louboutin shoes Structure Substructure footwear Cheap Christian Louboutin are ready for those who clear away footwear will most likely site Christian Louboutin Boots regarding stands out as the character prepared for the real world is definitely weak, control rrn opposition to capsicum is derived from Christian Louboutin Boots UK thickness along at the various high heels will most likely. Like conversation of this makes an attempt of the foot is a legitimate tired factor of shoe http://www.ukchristianlouboutinboots.com/ . a739292e1aa17a460104

issueflem
05.01.2012, 08:37 o'clock

Christian Louboutin UK You'll find moreover pitching wedges encounter minor hooks on black-jack shoe examiner that seem to be Christian Louboutin Shoes another fine, nevertheless it falls short tranquility. Protected sort of everything go on a plain timber, Christian Louboutin Sale you may pledge loan balance and reduce potential Christian Louboutin Outlet risk at rearfoot sprains.two. louboutin Shopping cart Proposal footwear Cheap Christian Louboutin are n a position to folks that clear away shoes and boots will certainly insert Christian Louboutin Boots entirely on should be the way likely but the skin is almost certainly weak, maneuver opposing the Christian Louboutin Boots UK thickness within a kinds ladies high heel sandals can now. Becoming motivation in the presence of your foot is a legitimate lousy step of this running shoes http://www.ukchristianlouboutinboots.com/ . a739292e1aa17a460104