Archive for July, 2010
Generate Date from a range in Mysql and pad the results where no date is present
If you want to generate dates, MYSQL doesn’t have a range function, so I wrote a work around for the same. So how it works is I have reused a code to generate numbers from my previous post. So I added date function to that query and reduce the generated numbers from the date. Hence effectively its Currrent Date – x number of days. Thus we generate the dates from the date we provide to the x number we generate. So here is the code:
Backend For Panel Reminder
I had already posted about creating a Display Reminders In Gnome Panel. This post is an addition to that script. This is a backend script that writes what to print into the panel_remind file. I use this script to print Birthday Reminder and Things to remember of which I will be posting shortly.
So the Code is simple Perl script.
Continue reading “Backend For Panel Reminder” »
Generate 1 to 1000 in mysql
Sometimes its necessary to have thousand rows to join or generate new values, we need to get the thousand rows first. For this I used union of numbers 0-9. I have joined four of these to get to four digit values. So here is the code:
Continue reading “Generate 1 to 1000 in mysql” »
Web page Performance for a Blog – Part 1
Posted by Srijith R in Performance on July 17, 2010
I have always under the notion that page performance for big websites or websites that have a sole server and various resources like CDN and load balancers. So I wanted to know if this is true. I set out to try web page performance my blog. I just wanted to see how much I can reduce the roundtrip time of this blog. I will be doing the analysis and optimization in parts. So here goes whatever I have done till now.
Continue reading “Web page Performance for a Blog – Part 1” »
Recent Comments