 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server CE / October 2007Big Database 55884 KB
With SQLServer CE 2.0 I have a big DB with a size of 55885 KB. The size after a compact was 6388 KB. There is a way to know why the DB grow like this ? Which table in the DB grow the DB ? Or what operation my program do to grow the DB ? There is a tools to help me to analyse the DB ? Thank's Marc When records are deleted and updated, used pages are not reused when inserts are done. Therefore yoy should always perform a Compact of your SQL CE database on a regular basis. There is not tool available to give you an indication of the "fragmentation level" of a SQL CE database.  SignatureErik Ejlskov Jensen - see my SQL Compact blog at http://erikej.blogspot.com > With SQLServer CE 2.0 > [quoted text clipped - 12 lines] > Thank's > Marc Ah, there is something else wrong. Unlike JET, SQLCe databases automatically compact when the last connection is closed. There is no need to run Compact unless something is preventing the database from shutdown maintenance. See my Ebook on SQL Server Compact Edition... Signature____________________________________ William (Bill) Vaughn Author, Mentor, Consultant, Dad, Grandpa Microsoft MVP INETA Speaker www.betav.com www.betav.com/blog/billva Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ Visit www.hitchhikerguides.net to get more information on my latest book: Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ----------------------------------------------------------------------------------------------------------------------- > When records are deleted and updated, used pages are not reused when > inserts are done. [quoted text clipped - 19 lines] >> Thank's >> Marc There is no automatic compact with SQL SERVER CE 2.0 thank's Marc > Ah, there is something else wrong. Unlike JET, SQLCe databases > automatically compact when the last connection is closed. There is no need [quoted text clipped - 25 lines] >>> Thank's >>> Marc |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.