• All Purchases made this month instantly go into the draw to win a USD $ 100.00 credit to your HoP account.
 

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

Login/Join to Participate

sudhir


newbie


Total posts: 1
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


Delete Topic

_Aime_
SILVER Member since Jan 2004

_Aime_

Carpal \'Tunnel
Location: Hastings

Total posts: 4172
Posted:Syyyym!!
Come hither!


Delete

alien_oddity


alien_oddity

Carpal \'Tunnel
Location: in the trees

Total posts: 7193
Posted:eh??? confused

Delete

[Nx?]
BRONZE Member since Mar 2017

[Nx?]

Carpal \'Tunnel
Location: Europe,Scotland,Both

Total posts: 3749
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

Delete

Fearpig
BRONZE Member since Sep 2003

Fearpig

member - tee hee "member"
Location: Bethnal Green, London

Total posts: 279
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

Delete

[Nx?]
BRONZE Member since Mar 2017

[Nx?]

Carpal \'Tunnel
Location: Europe,Scotland,Both

Total posts: 3749
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

Delete

Sym
BRONZE Member since Sep 2004

Sym

Geek-enviro-hippy priest
Location: Diss, Norfolk

Total posts: 1858
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

Delete

jo_rhymes
SILVER Member since Apr 2005

jo_rhymes

Momma Bear
Location: Telford, Shrops

Total posts: 4525
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.

Delete