cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mark S. Kent" <mark.k...@vistyx.com>
Subject RE: Xalan and xsl:sort speed by type
Date Fri, 16 Nov 2001 23:32:25 GMT
Yes, the data IS from a database.  However, often my output files are
sorting the results of the data based on a user choice (I'm creating
reports).

But, you got the thinking so I made an addition to my dynamic query string
in my esql command to change the SQL sort order based on the order (order
by...).

Still, I'm curious about the <xsl:sort> speed...

Mark

-----Original Message-----
From: David Rosenstrauch [mailto:darose@dti.net]
Sent: Friday, November 16, 2001 4:27 PM
To: cocoon-users@xml.apache.org
Subject: Re: Xalan and xsl:sort speed by type


Not answering your question, but just FYI ...

If this is data that's being retreived from a database, then my thinking
would be to avoid xsl:sort completely if possible.  I'd rather do sorting in
the database using a SQL statement (SELECT ... ORDER BY ...) since it's
probably better optimized for this.

Of course, if this isn't database data then please ignore me.  :-)


DR


At 03:13 PM 11/16/01 -0600, you wrote:
>Anyone know which is faster using Xalan (in Cocoon2)?  <xsl:sort> for a
>"number" type or a "text" type?
>
>Seems I remember reading that "string" compares take longer than numeric
>ones as a rule.  I have the option of sorting nodes based on either an
>"employeeid" (integer) or "lastname" (text).
>
>While the project is new, I know the employeeids will not be more than 5
>digits.  However, later they will.
>
>On the other hand, the lastnames could easily exceed 5 characters in length
>or could overlap for two people at a location (i.e. Bob SMITH and Mike
>SMITH).  I will select the nodes by ID to ensure uniqueness, but when I
uses
>my <xsl:sort> command, I'd like it to use the "optimum" sort type.
>
>TIA!   - Mark
>
>
>---------------------------------------------------------------------
>Please check that your question has not already been answered in the
>FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
>
>To unsubscribe, e-mail: <cocoon-users-unsubscribe@xml.apache.org>
>For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message