Shaikh Sonny Aman’s Blog

previously www.mailtoaman.com

Lightwieght VOIP billing software using mysql,servlet and ajax

Though I don’t like to do extra work beside my day job, but there are some people (and some offer :P)  whom I don’t like to refuse. Surely the work must be interesting.
Before some days,  one of my ex bosses gave a project to build a VOIP billing software. I was studying SIP protocol for [...]

Select a random row from large mysql table in an optimized way.

Random — This simple pronounced and apparently gentle looking word can make your brain randomly scattered.
We often need to select a random row from a table. … cutting short.. less time.
Prob: Need a random row from a table name ‘Dim’ which has 1,000,000 rows.
{selected only pad, i am in hurry :(}
1.
Create a stored procedure:
create [...]