[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] 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
|