Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsWhite Papers
Discussion GroupsFirst AidDatabasesJavaBeansGUIJava 3DVirtual MachineCORBASecurityToolsGeneral
Java DirectoryOpen Source ProjectsSample Book ChaptersUser GroupsWeb Resources
Related Topics
Databases.NETMore Topics ...

Java Forum / General / May 2006

Tip: Looking for answers? Try searching our database.

Populating 40,000 rows from Database.

Thread view: 
csubramani@gmail.com - 22 May 2006 04:25 GMT
Hi Folks,

 I have a stateless session bean that has to take 40,000 rows with  90
columns from the database and has to get populted to a excel spread
sheet. I'm getting into weblogic server idle time out due to processing
of heavy volume of records though the query returns the resultset data
fast. It take approximately 2 minutes to build a collection object and
looks like serialization took hell lot of time on this. Please suggest
me a better solution on how to bring the data 40,000 * 90  in a more
efficient way to the client thru Weblogic.

Thanks in advance for your help.
steve - 22 May 2006 22:29 GMT
> Hi Folks,
>
[quoted text clipped - 8 lines]
>
> Thanks in advance for your help.

don't
Jason King - 24 May 2006 11:38 GMT
>> Hi Folks,
>>
[quoted text clipped - 10 lines]
>
> don't

Can your database run a stored procedure to return a blob with the data
in tab delimited format?  That should load into Excel just fine and do
all the data heavy lifting on the database.


Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.