This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallAnywhere
- :
- InstallAnywhere Forum
- :
- Large SQL install
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Sep 20, 2012
03:17 PM
Large SQL install
I have an issue with a large data script I am trying to insert with my install. I have the file is about 10MB. After some testing I found that if I broke it into smaller segments the installer would load the smaller 1mb files. However I am still running into the issue where that install hangs after about the 5 script.
Anyone have any ideas the best way to run such a large script?
Cheers!
Anyone have any ideas the best way to run such a large script?
Cheers!
(1) Reply
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Sep 26, 2012
09:54 AM
I found the answer to my issue i had to turn on verbose logging. Once I did that I found that I was running out of memory.
I increased the maximum heap size and added -Xss5124k in the additional Arguments.
This seemed to fix the issue.
I increased the maximum heap size and added -Xss5124k in the additional Arguments.
This seemed to fix the issue.