Author: Prabhu Balakrishnan
-
Optimizing MySQL Rand() against Slowdowns
I was having having nightmares with mysql rand() function. Rand() function works well in pulling out rows randomly from the datbase and works well if you have a quite few hundred records. Ironically, it desperately slows down when you have a large table dataset above 10,000 rows. This is the traditional way of using mysql…
-
Enabling ModRewrite in XAMPP Apache
XAMPP is a very good Linux server package w/ Apache, MySQL,PHP running in Windows just like server runs in linux. You can download http://www.apachefriends.org I noticed that by default mod-rewrite is not enabled with apache server coming with it. It is very important to enable this module if you want to rewrite URLs and generate…