Hey guys,,,,, sneha

sneha123 — Tue, 18 Jan 2011 09:08:31 +0000

Hey guys,,,,, sneha here,,,,,I think good information,,,,,,,," According to my exp. it, depend on the page content , means Actually what you want to do and it's vary from page to page"............Thanks lot nice article .

as for the best practice

stokes1900 — Thu, 28 Oct 2010 10:06:48 +0000

as for the best practice number of query should be reduced. if number of query is large it will slow down your application.. we should keep in mind these things while developing application.

I had about 60 queries.. But

liba — Tue, 19 Oct 2010 17:58:00 +0000

I had about 60 queries.. But sometimes (very often) it goes up to 100 even..]

{links removed}

Hi, According to my exp. it,

sandeep Kumar — Thu, 08 Jul 2010 07:34:31 +0000

Hi, According to my exp. it, depend on the page content , means Actually what you want to do and it's vary from page to page.

My site has approx 40

delkan15 — Fri, 29 May 2009 09:12:31 +0000

My site has approx 40 queries.

Hmm, even the most complex

greg — Thu, 21 May 2009 18:48:36 +0000

Hmm, even the most complex sites with lots of information requirements I have built have not had more than 3 queries on a page.

Initially designing the database with your known site output is key. Then you don't need many queries to access the data.

The number of queries

Megatron — Thu, 21 May 2009 18:05:38 +0000

The number of queries doesn't really matter... of course it should be as low as possible, but if they are optimized 1000 queries will be faster then 1 bad query.

I've worked with systems that did 6000 queries for a youtube like home page because of bad "concept" in the background code. Totally WTF when I first realized the number, but the queries were optimized and the site worked normaly even during high loads.

At some stage in the code

masudkarim — Sat, 09 May 2009 03:20:42 +0000

At some stage in the code you will fill the report eg. with

JasperFillManager.fillReport(jr, reportParameters,
dataSource);

All you have to make sure is that the reportParameters contains all the
values
from your queries in a Map.

Eg. with totalCount 100

and that your jrxml references the parameter with $P{totalCount}. Use a text

field in iReport but change from $F to $P ...

Test it out with a hardcoded Map first and then fill the map from your data.

My page have 30+ quires,

LisaRole — Fri, 08 May 2009 22:15:06 +0000

My page have 30+ quires, sometimes i do more on other sites.

I try not to be clog with

jane0109 — Sun, 01 Feb 2009 11:04:35 +0000

I try not to be clog with querries.