Really what I need to do is "re-order" the database rows (for good) by the random_number column... note.. I am not using RAND() at all...
Hey, this gives me an idea... Given I have price ranges 1-2, 2-5, 5-10 etc... and the prices are all like 1.99, 1.96 etc... What if I precalculate a value for each range, say 1 to 2 is 1, 2 to 5 is 3, 5 to 10 is 6 etc... and prepoulate the rows with that value... That way rather than do a price > x and price < y and can do a price = 3 (which would catch all in the 2 to 5 range) and is explict rather than calculated... Would this work? Then ordering by my already prepopulated random_number column shouldn't be slow should it? yours (clutching at straws) 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 -~----------~----~----~----~------~----~------~--~---
