[Zope] sorting sql result

[Alan Capesius]

SQL will typically be much faster for a large record set.
For a small set, you won't notice the difference.

Of course your mileage may vary based on relative server and network speeds
(assuming remote SQL), the type of SQL server, etc.

Why not try it both ways and see. The coding to try it out is minimal and
will give you a good relative performance indication for future development
in your environment.

- Alan
---------------------------------------
Zope tips and tricks site
http://twsite.bizland.com/zopetips.htm



> -----Original Message-----
> From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of
> Gustavo Vieira Goncalves Coelho Rios
> Sent: Tuesday, July 24, 2001 8:24 AM
> To: zope@zope.org
> Subject: [Zope] sorting sql result
>
>
> Hi folks!
>
> i have a sql statement that returns three fields, to be known:
>
> msg, author, forum_id. I would like to let me users to sort on
> them. My i have zope do that for me or i have to do it by myself
> into the sql statement? Which is the best approach (considering
> performance).
>
> Thanks for your help.
>
> --
> Majority, n.:
> 	That quality that distinguishes a crime from a law.
>
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )
>