Generally speaking, when you use XSLT or any other language to process
the result of a database query, you should delegate as much of the
processing to the database engine as you can.

Michael Kay

> -----Original Message-----
> From: owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx 
> [mailto:owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of Mattison
> Sent: 04 August 2003 18:20
> To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> Subject:  sorting preformance
> 
> 
> I've been doing some reports and wondering what experience 
> folks have had with the speed of using xsl:sort.  So far I 
> haven't observed any noticable difference between sorting in 
> the database query (putting the records in the order in them 
> xml) and letting xsl sort unorder records.  But so far I've 
> only dealt with relatively small number or records so I'm not 
> surprised I don't notice a difference.
> 
> What suggestions or rules of thumb do folks use when deciding 
> where to do their sorting?  As such things might matter the 
> xsl parser and databases are MSXML 4.0 and MS SQL respectively.
> 
> Mattison
> 
> 
>  XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
> 


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list