in reply to Apache::DBI, DBI, DBD::MySql and MySQL cache?

Maybe you could try what this node suggests in reply to Perl and MySQL - getting a random record.
  • Comment on Re: Apache::DBI, DBI, DBD::MySql and MySQL cache?

Replies are listed 'Best First'.
Re: Re: Apache::DBI, DBI, DBD::MySql and MySQL cache?
by Flame (Deacon) on Mar 17, 2003 at 14:23 UTC
    Unfortunately those ideas were already covered. Looks like my only option is to SELECT COUNT and then let perl select a random ID from the database. (/me frowns over the wasted transit time)



    My code doesn't have bugs, it just develops random features.

    Flame ~ Lead Programmer: GMS (DOWN) | GMS (DOWN)