cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrew C. Oliver" <acoli...@apache.org>
Subject Re: SQLTransformer good, ESQL bad
Date Sat, 17 Aug 2002 21:12:06 GMT
>From the information provided it is not immediately apparent to me what
your problem is.  But from crude benchmarking I've done.. ESQL is
SIGNIFICANTLY faster than the SQLTransformer..  To experience this, use
apbench on the http://localhost:8080/cocoon/samples/poi/statetax.xls and
statetax2.xls (filenames are approximate) examples that come with
cocoon.  The statetax2 example is more complicated and has groupings and
stuff, but its STILL several times faster than the SQLTransformer
version.  I found my results to be consistent when used other ways as
well.

SQLTransformer is slow.

-Andy 

On Sat, 2002-08-17 at 17:13, Jan Willem Penterman wrote:
> I'm sorry to the spam the list like this, but now I've got the feeling
> I'm really getting somewhere:
> 
> I've set up cocoon-2.0.3 binary release for j2sdk1.4 and added a pool
> for MySQL Connector/J .
> 
> Now I've actually managed to get some row data from a MySQL database
> using SQLTransformer!
> 
> But with ESQL it still fails in:
> 
> org.apache.cocoon.ProcessingException: Exception in
> ServerPagesGenerator.generate(): java.lang.RuntimeException: Error
> opening connection to dburl: : No suitable driver
> 
> Now besides being curious about solving this error, I'd like to know why
> or why not I should stickt with SQLTransformer. In other words, why
> should I care about ESQL?
> 
> JW
> 
> P.s. I'm not going to post the pool setup, since SQLTransformer clearly
> got a connection from it so it works.
> 
> query.xsp:
> ----------
> 
> <?xml version="1.0"?>
> <xsp:page
> 	language="java"
> 	xmlns:xsp="http://apache.org/xsp"
> 	xmlns:esql="http://apache.org/cocoon/SQL/v2">
> 	<root>
> 		<esql:connection>
> 			<esql:execute-query>
> 				<!-- connection information -->
> 				<esql:pool>mysql</esql:pool>
> 				
> 				<!-- SQL query -->
> 				<esql:query>
> 					select something from that 
> 				</esql:query>
> 				<!-- result processing elements -->
> 				<esql:results>
> 					<esql:row-results>
> 						<that>
> 	
> <esql:get-columns/>
> 						</that>
> 					</esql:row-results>
> 				</esql:results>
> 				<esql:update-results/>
> 				<esql:no-results/>
> 				<esql:error-results/>
> 			</esql:execute-query>
> 		
> 		</esql:connection>
> 	</root>
> </xsp:page>
> 
> sitemap.xmap: (this is a subsitemap of cocoon/sitemap.xmap)
> -------------
> 
> <?xml version="1.0"?>
> 
> <!-- sitemap for mysqltest -->
> 
> <map:sitemap xmlns:map="http://apache.org/cocoon/sitemap/1.0">
> 
>   <!-- ======= Components ======= -->
>   <map:components>
>     <map:generators default="file">
>         <map:generator label="content,data"
> logger="sitemap.generator.serverpages" name="serverpages" pool-grow="2"
> pool-max="32" pool-min="4"
> src="org.apache.cocoon.generation.ServerPagesGenerator"/>
> 	</map:generators>
>     <map:transformers default="xslt"/>
>     <map:readers default="resource"/>
>     <map:serializers default="html"/>
>     <map:selectors default="browser"/>
>     <map:matchers default="wildcard">
>       <map:matcher name="wildcard"
>         src="org.apache.cocoon.matching.WildcardURIMatcherFactory"/>
>     </map:matchers>
>   </map:components>
> 
>   <!-- ======= Pipelines ======= -->
>   <map:pipelines>
>     <map:pipeline>
> 		 <map:match pattern="index.html">
> 			<map:read src="documents/static/index.html"
> mime-type="text/html"/>
> 		 </map:match>
> 		 <map:match pattern="esqltest.xml">
> 			<map:generate src="logic/query.xsp"
> type="serverpages"/>
> 			<map:serialize type="xml"/>
> 		 </map:match>
> 		 	
> 		<map:match pattern="sqlttest.xml">
> 			<map:generate src="documents/mysqltest.xml"/>
> 			<map:transform type="sql">
> 		        <map:parameter name="use-connection"
> value="mysql"/>
> 		    </map:transform>
> 			<map:serialize type="xml"/>
> 		</map:match>
> 	</map:pipeline>
>   </map:pipelines>
>   		
> </map:sitemap>
> 
> 
> 
> ---------------------------------------------------------------------
> Please check that your question  has not already been answered in the
> FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>
> 
> To unsubscribe, e-mail:     <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>
> 
-- 
http://www.superlinksoftware.com - software solutions for business
http://jakarta.apache.org/poi - Excel/Word/OLE 2 Compound Document in
Java                            
http://krysalis.sourceforge.net/centipede - the best build/project
structure
		    a guy/gal could have! - Make Ant simple on complex Projects!
The avalanche has already started. It is too late for the pebbles to
vote.
-Ambassador Kosh


---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.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