Forums > Social Chat > Generating a large xls file near around 65MB from sql server

Login/Join to Participate

sudhirnewbie
1 post

Posted:
Hi all
I am trying to generate large xls file which is near around 65MB of size form sql server.
I have run java programme with option -Xms512m -Xmx1024m. It refuse responding after rendering 30000 records.
I belive that it create Inmemory tree of object so jvm stop responding. is there any possibility or using OPI event library for creating the excel work Book that use less memory.

thanx for all your help
sudhir

_Aime_SILVER Member
Carpal \'Tunnel
4,172 posts
Location: Hastings, United Kingdom


Posted:
Syyyym!!
Come hither!

alien_oddityCarpal \'Tunnel
7,193 posts
Location: in the trees


Posted:
eh??? confused

[Nx?]BRONZE Member
Carpal \'Tunnel
3,749 posts
Location: Europe,Scotland,Both


Posted:
errm,

I know this place can get pretty techie....

but not that sort of techie!

maybe pm Dom... he might know.

thats totaly got to win the prize for most unusual noob post! ubblol

welcome

T wave

This is a post by tom, all spelling is deleberate
-><- Kallisti


FearpigSILVER Member
member - tee hee "member"
279 posts
Location: Bethnal Green, London, England (UK)


Posted:
I think you should find that if you change the export type to DBVII or an MS Access Table then you should have no problem with this. Excel often has trouble dealing with large amounts of data. I usually try to keep Excel files below 10MB before trying a different format.

Preferably if your handling that much data is it possible for you to output the results to another SQL table and read the data via an ASP web page on your intranet?

Drop me a PM if you have any questions.

"Whats wrong with the cat?" - Mrs Schrdinger


[Nx?]BRONZE Member
Carpal \'Tunnel
3,749 posts
Location: Europe,Scotland,Both


Posted:
well, there you go!

next time i break my mac I know where Im posting!

T wave

This is a post by tom, all spelling is deleberate
-><- Kallisti


SymBRONZE Member
Geek-enviro-hippy priest
1,858 posts
Location: Diss, Norfolk, United Kingdom


Posted:
yeah, good advice (although you should use PHP not ASP :P )

what are you doing it for? having that sort of data in excel isn't a good idea anyway.

as for the problem, can i have more info about the computer you're using? hardware and software. Also, is there anything stopping you from using excel to import it direct? it can mport from most things i think. Or just dump the mssql tables in to a CVS file?

What JRE are you running?

There's too many home fires burning and not enough trees


jo_rhymesSILVER Member
Momma Bear
4,525 posts
Location: Telford, Shrops, United Kingdom


Posted:
confused eek what the bloody 'ell are you lot on about? ubblol
by the way, Aimee, you're my angel! i love you girl!! lol wave hug ubbangel kiss

Hoppers are angels who lift us to our feet when our wings have trouble remembering how to fly.


HOP Newsletter
Sign up to get the latest on sales, new releases and more...