Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 3 of 3 total |
"out of memory" error on dbsys Version 3.03 |
Tue, May 29 2007 7:37 AM | Permanent Link |
alijunior | I've tried execute a copy sql statement ang dbsys give me that error.
I need copy data from many to one table. My sql statement is: insert into ALL_DATA ( "CODE", "IMAGE", "VOLUME" ) select "CODE", "IMAGE", "VOLUME" from DATA_01 The table DATA_01 has a blob field with an image data. In the second step od progress bar dbsys give me the "Out of memory" error. How can I solve this problem? Thanks a lot!! |
Tue, May 29 2007 3:55 PM | Permanent Link |
"Donat Hebert \(Worldsoft\)" | Have you tried small Commit Interval ? (I believe Version 3 had this
feature) You may be choking the engine if these are large files... hth. "alijunior" <alijunior@alijunior.com> wrote in message news:913B7EDC-E5EA-4400-83FB-CA6A9C727996@news.elevatesoft.com... > I've tried execute a copy sql statement ang dbsys give me that error. > I need copy data from many to one table. > My sql statement is: > > insert into ALL_DATA > ( > "CODE", > "IMAGE", > "VOLUME" ) > select > "CODE", > "IMAGE", > "VOLUME" from DATA_01 > > The table DATA_01 has a blob field with an image data. > > In the second step od progress bar dbsys give me the "Out of memory" > error. > > How can I solve this problem? > > Thanks a lot!! > |
Tue, May 29 2007 6:22 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | << I've tried execute a copy sql statement ang dbsys give me that error. I need copy data from many to one table. My sql statement is: >> Is the target table an in-memory table ? If so, then you're probably just inserting too much data for an in-memory table. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Wednesday, June 12, 2024 at 01:54 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |