| parameterized query vs build query performance [message #202388] |
Wed, 22 November 2006 05:53 |
Eclipse User |
|
|
|
Originally posted by: jurgen.delandsheer.ugent.be
I build my queries in DBVisualizer where even difficult queries give a
result in 2 seconds or less (I put returned results at 1000 records,
and as the resultset is never larger than this I can see bottlenecks
in the execution of queries)
the I make a dataset in Birt and copy past the sql replacing fixed
parameters by ?, creating the correct rapport parameters and linking
each ? parameter to the correct rapport parameter
I run the report and complex queries take like 15 minutes to display,
even the most simple queries take 10 seconds or more
when I copy past the query from DBVisualizer to Birt and instead go to
the script that is done before openeing the dataset and replace fixed
parameters by report parameter params["something"] instead of setting
them in the dataset by ?, the run like at least twice as fast; the query
that used to run 15 minutes now takes under 30 seconds and the most
simple
2 or 3 seconds
we are using
Eclipse 3.2.1 with Birt inluded and updated to the latest versions
Birt 2.2M1/2.1.1 runtime war in Tomcat 5.5.20 for local testing
Oracle 9 database server
how can I fix this problem
OR
can't I use the best of both and instead of using ? in the Birt query
builder, something like params["something"], so I don't have to change
queries at two places
Jurgen
UGent
|
|
|
Powered by
FUDForum. Page generated in 0.02650 seconds
Home