When Select count(*) is not the best option

A colleague of mine brought this fact to attention that count(*) is not a very good thing. Atleast not for the case when you are checking for the presence of just a single record. What popped to my mind immediately was, not if there is proper index, it shouldn't matter. But that was an assumption on my part which I had to check out. And the result turned out to be that rewriting such a query is always a good idea if all you want is an existence check. So lets do some cost analysis in this article for the same, so you can also understand the same.

Enabling SSL for your Drupal 7 website

Just as I thought my Dupal blog is done and I can now make it known to the public, I stopped and looked at login box and pondered, "Hey ! thats plain http over there. Oh darn NSA now knows my passwords. I just sent them over plain text". Oh well, got to fix that. It turns out it wasn' such a difficult task to get up and running with SSL. To my surprise, things almost just worked at first go, which they rarely do.

I am on a LAMP stack so the instructions are basically for the same.

Keys and Certificate generation

Viewing the XML document during Activation/Passivation

Sometime when working with ampooling, you need to view what you are passivating. One way is to of course turn on jbo logging and you can than see the passivated XML in all the noise. Or just turn on logging for "oracle.jbo.server.Serilaizer" class.

Pages

Subscribe to Ahsan's Corner RSS