Essentially I think the problem is this...
I am trying to do an ORDER BY on a pre-populated (and indexed) column called random_number... I created this column because RAND() is so slow... It is the ORDER BY which is causing all the slow downs... If I do a select without the order by it is really quick... I guess what I need to do is dump the whole database and swap the id for the random_number (and all the references to each id)... that way the records would be in a random order of sorts.. and I wouldn't have to do any sorting... Basically the records have to be "put into" the database in a random order... you can't feasibly randomize items later... sigh... I guess this is my only option... tom --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
