Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 31 to 40 of 40 total |
Out of memory. |
Mon, Oct 30 2006 5:34 PM | Permanent Link |
Abdulaziz Jasser | Tim,
<<Which field did you drop and re-add in the ALTER TABLE ? The memo field ? If so, then that is what one would expect when you perform those operations. >> "Notes" field. <<As to how the NULL data go there in the first place, I have no idea. >> Our application gives "Space(1)" as a default. <<However, I do know that DBISAM didn't just put it there by itself. Do you have any code that updates that memo field ?>> Yes, I run "UPDATE TB_SALES SET NOTES = NULL" a couple of minutes before I sent you the table. The default value in our application is ' '. |
Tue, Oct 31 2006 8:43 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Abdulaziz,
<< Our application gives "Space(1)" as a default. >> Any particular reason for this ? << Yes, I run "UPDATE TB_SALES SET NOTES = NULL" a couple of minutes before I sent you the table. The default value in our application is ' '. >> So, you're saying that the table is fine prior to running the above SQL ? -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Oct 31 2006 11:43 AM | Permanent Link |
Abdulaziz Jasser | Tim,
<<Any particular reason for this ?>> Just to avoid having NULL. We don't like dealing with NULL values. <<So, you're saying that the table is fine prior to running the above SQL ?>> No, the size was 92 MGB before I run the SQL statement and the value in all records was one byte of space. I run the SQL statement to see if it can change the size of the BLB file. But the size did not change even after running this SQL statement. How did this file became so big? Also, what data is in it? Regards, Abdulaziz Jasser |
Wed, Nov 1 2006 4:18 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Abdulaziz
Put anything, even a single space, into a blob field and it'll take up the minimum BlobBlockSize (default 512 bytes) so 200,000 records times 512 bytes and there's your minimum space usage. Roy Lambert |
Wed, Nov 1 2006 7:35 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Abdulaziz,
<< No, the size was 92 MGB before I run the SQL statement and the value in all records was one byte of space. I run the SQL statement to see if it can change the size of the BLB file. >> You need to Optimize a table in order to remove any deleted space, including BLOBs. << But the size did not change even after running this SQL statement. How did this file became so big? Also, what data is in it? >> I don't know how it got that big, all I know is that DBISAM didn't do it by itself. Something had to have been stored there at some point. Are the users allowed to do any bulk updates to the table ? -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Nov 1 2006 7:36 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Put anything, even a single space, into a blob field and it'll take up the minimum BlobBlockSize (default 512 bytes) so 200,000 records times 512 bytes and there's your minimum space usage. >> Duh, I forgot about the block size, and you are 100% correct: 512*200000 = around 102 megs. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Nov 2 2006 5:34 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
>512*200000 = around 102 megs. I love the calculation accuracy Roy Lambert |
Thu, Nov 2 2006 11:10 AM | Permanent Link |
Abdulaziz Jasser | Tim,
<<I don't know how it got that big, all I know is that DBISAM didn't do it by itself. Something had to have been stored there at some point. Are the users allowed to do any bulk updates to the table ?>> No. This is the first time to happen. Anyway at least I know how to solve the problem (dropping the field and add it again). |
Thu, Nov 2 2006 11:49 AM | Permanent Link |
Abdulaziz Jasser | I forget to say thanks to all the people who replied and tried to help.
Best Regards, Abdulaziz Jasser |
Thu, Nov 2 2006 11:02 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< I love the calculation accuracy >> So I rounded a bit, shoot me. -- Tim Young Elevate Software www.elevatesoft.com |
« Previous Page | Page 4 of 4 | |
Jump to Page: 1 2 3 4 |
This web page was last updated on Tuesday, May 7, 2024 at 06:25 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |