[PHP] Any clever ideas on how to find some random records?

2005-04-26 Thread Brian Dunning
I have a MySQL database with about a million records. I'd like to use the SQL command order by RAND() but my ISP won't let me: whenever the server gets spidered, Google overloads their MySQL server because of all the overhead of that command. I can't just cloak the spiders because I need

RE: [PHP] Any clever ideas on how to find some random records?

2005-04-26 Thread David Tucker
[OP] I have a MySQL database with about a million records. I'd like to use the SQL command order by RAND() but my ISP won't let me: whenever the server gets spidered, Google overloads their MySQL server because of all the overhead of that command. I can't just cloak the spiders because I need them

Re: [PHP] Any clever ideas on how to find some random records?

2005-04-26 Thread Jochem Maas
David Tucker wrote: [OP] I have a MySQL database with about a million records. I'd like to use the SQL command order by RAND() but my ISP won't let me: whenever the server gets spidered, Google overloads their MySQL server because of all the overhead of that command. I can't just cloak the spiders

Re: [PHP] Any clever ideas on how to find some random records?

2005-04-26 Thread Richard Lynch
On Tue, April 26, 2005 7:55 am, Brian Dunning said: I have a MySQL database with about a million records. I'd like to use the SQL command order by RAND() but my ISP won't let me: whenever the server gets spidered, Google overloads their MySQL server because of all the overhead of that