CompactDatabase

Discussion in 'ASP General' started by Christopher Brandsdal, Jul 25, 2003.

  1. Hi!
    I found a database tool-script that has a functin for compacting the
    database....
    What is the point of compacting the database? Is it necessary?
    Anyone know the advantages of doing this???


    a short copy of the code
    ////////////////////////////////////////////////////////////////////////////
    /
    var oJet = Server.CreateObject("JRO.JetEngine");

    oJet.CompactDatabase("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
    sDbFName,
    "Provider=Microsoft.Jet.OLEDB.4.0;Data
    Source=" + sTempDbFName);
    ////////////////////////////////////////////////////////////////////////////
    /




    Thanks a lot in advance.

    best regards Christopher
     
    Christopher Brandsdal, Jul 25, 2003
    #1
    1. Advertisements

  2. Christopher Brandsdal

    Ray at Guest

    Frees up junk space from deleted records, reseeds autonumbers, where
    applicable. I personally think it's generally a good idea to compact from
    time to time.

    Ray at work
     
    Ray at, Jul 25, 2003
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
Loading...