Bugs item #908815, was opened at 2004-03-03 05:20
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=536613&aid=908815&group_id=73068
Category: main tag library
Group: v 1.0-b3
Status: Open
Resolution: None
Priority: 5
Submitted By: Steven Zhao (stevenzhao)
Assigned to: Nobody/Anonymous (nobody)
Summary: the displayTag performance bottleneck when 10 thousand rows.
Initial Comment:
I have so much rows in database, I have use all kinds of
method to optimize display table performance.
when the sql search return 10 thousand rows, it was
display table about 3 second.But , when sql search
return 50 thousand rows, it will never display the table ,
the CPU load is 100% in long time.
Today, I have debug the displayTag source code, it was
start with doStartTag()#TableTag, with every Object in
the List, call doAfterBody(), and use doIteration() to
add the Object into TableModel, at last, call doEndTag()
#TableTag to output html.
when I have 50 thousand rows, the method doAfterBody
() will be called 50 thousand times !!! Even only 20 rows
will be display on this page.
so, I think it's performance bottle-neck!
Can I direct use outside list instead of copy it to
TableModel ? OR just add the rows which will be display
on this page , such as lazy load?
Here is some data maybe show us performance bottle-
neck.
I make a test ,in doIteration()#TableTag, I use
System.out.print() current row and time consumed
every 1000 rows, as underside first column, in tomcat
default configuration, the time consumed every 1000
rows is increase!!!
so I use "-Xms256M -Xmx256M" to set tomcat memory,
then, i get second column data, it was increase slight.
And as third column shown, sometime it was never
increase, in this time , I got the best performance.
Tomcat default Tomcat 256M RAM Tomcat
256M RAM BEST
2000 time:170 2000 time:211 2000
time:120
3000 time:190 3000 time:140 3000
time:101
4000 time:231 4000 time:200 4000
time:80
5000 time:270 5000 time:241 5000
time:80
6000 time:721 6000 time:290 6000
time:40
7000 time:911 7000 time:350 7000
time:60
8000 time:1192 8000 time:391 8000
time:40
9000 time:1302 9000 time:381 9000
time:50
10000 time:1342 10000 time:420 10000
time:40
11000 time:1893 11000 time:481 11000
time:70
12000 time:1862 12000 time:591 12000
time:40
13000 time:2364 13000 time:571 13000
time:50
14000 time:3284 14000 time:650 14000
time:40
15000 time:3485 15000 time:742 15000
time:51
16000 time:3956 16000 time:741 16000
time:70
17000 time:3946 17000 time:771 17000
time:40
18000 time:4356 18000 time:941 18000
time:50
19000 time:4777 19000 time:931 19000
time:40
20000 time:7711 20000 time:1132 20000
time:70
21000 time:8422 21000 time:1092 21000
time:40
22000 time:9544 22000 time:2383 22000
time:50
23000 time:10094 23000 time:4316
23000 time:40
24000 time:10065 24000 time:4266
24000 time:40
25000 time:12197 25000 time:1382
25000 time:70
26000 time:12799 26000 time:1402
26000 time:40
27000 time:13169 27000 time:1533
27000 time:50
28000 time:13169 28000 time:1922
28000 time:40
29000 time:15692 29000 time:1613
29000 time:71
Best Regards,
stevenzhao
email: [EMAIL PROTECTED]
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=536613&aid=908815&group_id=73068
-------------------------------------------------------
SF.Net is sponsored by: Speed Start Your Linux Apps Now.
Build and deploy apps & Web services for Linux with
a free DVD software kit from IBM. Click Now!
http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click
_______________________________________________
displaytag-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/displaytag-devel
