DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: database file size

  1. #1
    Carlos Paiva Guest

    Re: database file size

    Try to compact the database, and see if it gets smaller!
    probably, you write & delete information several times, and database
    gets fragmented.
    I hope this helps you.

    Carlos Paiva


    "panaitescu" <calimero69@hotmail.com> escreveu na mensagem
    news:3cbec7d3$1@10.1.10.29...
    >
    > hi,
    > I am tring to do a simple database using the visual basic's visual data

    manager.
    > For texts I use fields of type "string" and for pictures(bitmaps) I use a
    > field of type "binary". After testing the program I noticed that the

    database
    > file was disproportionate large(about 12Mb) compared with the actual size
    > of data that I enterd(just some text and about 30 bitmaps - average size
    > 60kb). Is this normal? Are there better solutions that will use more

    efficiently
    > the HD space?




  2. #2
    panaitescu Guest

    database file size


    hi,
    I am tring to do a simple database using the visual basic's visual data manager.
    For texts I use fields of type "string" and for pictures(bitmaps) I use a
    field of type "binary". After testing the program I noticed that the database
    file was disproportionate large(about 12Mb) compared with the actual size
    of data that I enterd(just some text and about 30 bitmaps - average size
    60kb). Is this normal? Are there better solutions that will use more efficiently
    the HD space?

  3. #3
    panaitescu Guest

    Re: database file size


    "Carlos Paiva" <c_paiva@sapo.pt> wrote:
    > Try to compact the database, and see if it gets smaller!
    >probably, you write & delete information several times, and database
    >gets fragmented.
    > I hope this helps you.
    >
    > Carlos Paiva
    >
    >
    >"panaitescu" <calimero69@hotmail.com> escreveu na mensagem
    >news:3cbec7d3$1@10.1.10.29...
    >>
    >> hi,
    >> I am tring to do a simple database using the visual basic's visual data

    >manager.
    >> For texts I use fields of type "string" and for pictures(bitmaps) I use

    a
    >> field of type "binary". After testing the program I noticed that the

    >database
    >> file was disproportionate large(about 12Mb) compared with the actual size
    >> of data that I enterd(just some text and about 30 bitmaps - average size
    >> 60kb). Is this normal? Are there better solutions that will use more

    >efficiently
    >> the HD space?

    >
    >

    yes, I intend to write & delete in my database frequently. What method/function
    to use to compact the database?

  4. #4
    Carlos Paiva Guest

    Re: database file size

    It depends on which syatem you use to access the data base.
    If you use DAO, then execute the command DBEngine.CompactDatabase
    If you use ADO, you should Reference JRO and use it to compact Database
    (Jet Only)

    Regards,
    Carlos Paiva

    "panaitescu" <calimero69@hotmail.com> escreveu na mensagem
    news:3cbefbed$1@10.1.10.29...
    >
    > "Carlos Paiva" <c_paiva@sapo.pt> wrote:
    > > Try to compact the database, and see if it gets smaller!
    > >probably, you write & delete information several times, and database
    > >gets fragmented.
    > > I hope this helps you.
    > >
    > > Carlos Paiva
    > >
    > >
    > >"panaitescu" <calimero69@hotmail.com> escreveu na mensagem
    > >news:3cbec7d3$1@10.1.10.29...
    > >>
    > >> hi,
    > >> I am tring to do a simple database using the visual basic's visual data

    > >manager.
    > >> For texts I use fields of type "string" and for pictures(bitmaps) I use

    > a
    > >> field of type "binary". After testing the program I noticed that the

    > >database
    > >> file was disproportionate large(about 12Mb) compared with the actual

    size
    > >> of data that I enterd(just some text and about 30 bitmaps - average

    size
    > >> 60kb). Is this normal? Are there better solutions that will use more

    > >efficiently
    > >> the HD space?

    > >
    > >

    > yes, I intend to write & delete in my database frequently. What

    method/function
    > to use to compact the database?




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center