RE: sorting preformance
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
PURCHASE STYLUS STUDIO ONLINE TODAY!
Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!
Download The World's Best XML IDE!
Accelerate XML development with our award-winning XML IDE - Download a free trial today!
Subscribe in XML format