I'm subscribed to the mailing lists and I've seen your messages - there's no need to e-mail me directly. ;-)
I believe you have found a bottleneck and I thank you for the research you've done. However, since I'm not the primary developer on this project - I wouldn't know where to begin to fix it. If you wait a few days, and you've entered a bug for this - I'm sure it'll get addressed in due time. Matt > -----Original Message----- > From: Steven Zhao [mailto:[EMAIL PROTECTED] > Sent: Monday, March 01, 2004 8:15 AM > To: [EMAIL PROTECTED] > Subject: about displayTag performance bottle-neck > > > Project: Display Tag Library > > > > 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 ? > > > > 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] > > ------------------------------------------------------- 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-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/displaytag-user
