Forums > Social Chat > Generating a large xls file near around 65MB from sql server
Login/Join to Participatenewbie
1 post
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
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
SILVER Member
Carpal \'Tunnel
4,172 posts
Location: Hastings, United Kingdom
Carpal \'Tunnel
4,172 posts
Location: Hastings, United Kingdom
Posted:
Syyyym!!
Come hither!
Syyyym!!
Come hither!
Carpal \'Tunnel
7,193 posts
Location: in the trees
7,193 posts
Location: in the trees
Posted:
eh???
eh???
BRONZE Member
Carpal \'Tunnel
3,750 posts
Location: Europe,Scotland,Both
Carpal \'Tunnel
3,750 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!
welcome
T
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!
welcome
T
This is a post by tom, all spelling is deleberate
-><- Kallisti
SILVER Member
member - tee hee "member"
279 posts
Location: Bethnal Green, London, England (UK)
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.
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 Schrödinger
BRONZE Member
Carpal \'Tunnel
3,750 posts
Location: Europe,Scotland,Both
Carpal \'Tunnel
3,750 posts
Location: Europe,Scotland,Both
Posted:
well, there you go!
next time i break my mac I know where Im posting!
T
well, there you go!
next time i break my mac I know where Im posting!
T
This is a post by tom, all spelling is deleberate
-><- Kallisti
BRONZE Member
Geek-enviro-hippy priest
1,858 posts
Location: Diss, Norfolk, United Kingdom
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?
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
SILVER Member
Momma Bear
4,525 posts
Location: Telford, Shrops, United Kingdom
Momma Bear
4,525 posts
Location: Telford, Shrops, United Kingdom
Posted:
what the bloody 'ell are you lot on about?
by the way, Aimee, you're my angel! i love you girl!! lol 
what the bloody 'ell are you lot on about? by the way, Aimee, you're my angel! i love you girl!! lol
Hoppers are angels who lift us to our feet when our wings have trouble remembering how to fly.
© 1998 - 2025 Home of Poi
All prices converted to United States dollars using XE.com