2008/12/5 Chris Moffitt <[EMAIL PROTECTED]>:
> Great! Thanks.
I'm working on it, because it doesn't randomize results. Tomorrow I
will update it.
I've seen in the index featured product view that shuffle is done with
order_by('?'), that is really slow and cpu intensive in MySQL.
It's the same also on PostgreSQL?
Does anyone use a profiler to analyze and optimize the number and the
weight of queries made by our code?
--
Alessandro Ronchi
Skype: aronchi
http://www.alessandroronchi.net
SOASI Soc.Coop. - www.soasi.com
Sviluppo Software e Sistemi Open Source
Sede: Via Poggiali 2/bis, 47100 Forlì (FC)
Tel.: +39 0543 798985 - Fax: +39 0543 579928
Rispetta l'ambiente: se non ti è necessario, non stampare questa mail
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Satchmo users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/satchmo-users?hl=en
-~----------~----~----~----~------~----~------~--~---