|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
October 11th, 2005, 03:36 AM
|
|||
|
|||
|
can I rely that field with null value don't waste space on disk?
Can I safely add column which contains null value for the most of rows, relying that this don't lead to increase of DB size (which for me is critical issue)?
I made expriments with 2GB DB with one table (above 2'000'000 records): I added 1 empty integer field - nothing has happen with DB size - but after I updated this new field with some values (for all the records) - DB size increased about 170-180 MB, I assume, that after B/R this increase will not be so big. Is it true for all the cases?
|
|
#2
October 13th, 2005, 12:32 PM
|
||||
|
||||
|
If the null value(s) comes from adding a null column(s) to a table(s) there will be no increase in the database size ... but if the null value(s) come from an update/erase of records firebird will not relocate the space automatically until you will perform a back-up / restore.
Good luck.
__________________
If i've been helpful, please add to my reputation. My unfinished site: http://www.dever.ro
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > can I rely that field with null value don't waste space on disk? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
