none
Why so big the db size

    Question

  • I convert one Access file (mdb) which size is 30.0 MB to Sqlce 3.5 db file which is 280.00Mb

    Why the same data content has different size in two databases ?

    I think the sqlce db file size is too big ....

     


    Beat Microsoft.
    Wednesday, December 01, 2010 2:42 AM

Answers

  • And you are running Compact after the upgrade? In addition, indexes can consume space is SQL Compact, and may be implemented differently than in MS Access. For more info on sizes, see: http://support.microsoft.com/kb/827968


    Visit my SQL Compact blog - http://erikej.blogspot.com - Please mark as answer, if this was it.
    • Marked as answer by ms44cn Monday, December 06, 2010 6:54 AM
    Wednesday, December 01, 2010 2:07 PM
    Moderator
  • 255*2 + 50*2 + 8 + 8 + 50*2 + 50*2 = 826

    826 * 350000 = 289100000

    ~270MB

    Izhar

    Saturday, December 04, 2010 5:35 PM

All replies

  • And you are running Compact after the upgrade? In addition, indexes can consume space is SQL Compact, and may be implemented differently than in MS Access. For more info on sizes, see: http://support.microsoft.com/kb/827968


    Visit my SQL Compact blog - http://erikej.blogspot.com - Please mark as answer, if this was it.
    • Marked as answer by ms44cn Monday, December 06, 2010 6:54 AM
    Wednesday, December 01, 2010 2:07 PM
    Moderator
  • I have call  the SqlceEngine.Compact ,but the size also big , about 270Mb .

    And there is no any indexes in the access file , and only five columns ,only nchar type and float type .

    So I feel strange , why sqlce file will be so big .


    Beat Microsoft.
    Thursday, December 02, 2010 2:19 AM
  • Hi,

    Can you post out the schema of each table and how many data rows in each of them?

    Thanks,
    Chunsong


    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Thursday, December 02, 2010 9:13 AM
    Moderator
  • There is only one table in sqlce file .

    Data row count is about 350,000

    Table schema is very simple like below :

     

    A (nchar(255))

    B (nvchar(50))

    C (float)

    D (float)

    E (nchar(50))

    F (nchar(50))

     

     


    Beat Microsoft.
    Friday, December 03, 2010 6:08 AM
  • 255*2 + 50*2 + 8 + 8 + 50*2 + 50*2 = 826

    826 * 350000 = 289100000

    ~270MB

    Izhar

    Saturday, December 04, 2010 5:35 PM
  • Yes , You are right .

    I found the different  is if SSCE use nvarchar ,the size will be small than 38Mb . 

    Thanks for your answer.

     


    Beat Microsoft.
    Monday, December 06, 2010 6:50 AM