Results 1 to 2 of 2

Thread: [RESOLVED] SQLCE database...just gets bigger

Threaded View

  1. Jun 16th, 2005, 04:38 AM #1
    Strider
    Strider is offline

    Thread Starter
    Fanatic Member Strider's Avatar
    Join Date
    Sep 2004
    Location
    Dublin, Ireland
    Posts
    612

    Resolved [RESOLVED] SQLCE database...just gets bigger

    Hey there,

    Im one of my applications i import up tp 7 csv files of data. usual about 2 of these may contain up to 3000 records each. the rest of them contain up to 100.

    When my application creates the database and tables the size of the sqlce database is l44KB.

    After i perform the first import of data its increases to 700KB.
    When i perform each import from the CSV file I, DELETE FROM the table that the data is being imported to, so to clear all data the was previously there.

    If i perform another import the database size increases to 1.18MB, and it continues to increase each time i perform an import by about 500K.

    I have no indexs or identity fields in any of these tables.

    Why is this increase happening, and what do i need to do to stop it?
    Is there data being cached somewhere?
    Last edited by Strider; Jun 16th, 2005 at 06:01 AM.
    Barry


    Visual Studio .NET 2008/Visual Studio .NET 2005/Visual Studio .NET 2003
    .NET Framework 3.0 2.0 1.1/ASP.Net 3.0 2.0 1.1/Compact Framework 1.0

    SQL Server 2005/2000/SQL Server CE 2.0


    If you like, rate this post

    Compact Framework for Beginners
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width