CompactDatabase

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

  1. Anyone know? hmm..
    /////////////////////////////////

    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 27, 2003
    #1
    1. Advertisements

  2. Christopher Brandsdal

    Ray at Guest

    I replied nine minutes after your original post. You may have to download
    more than the default 300 messages if you're using OE to go back that far.

    Ray at home
     
    Ray at, Jul 27, 2003
    #2
    1. Advertisements

  3. hmm.. strange.
    I have chosen to download all massages.. aprox. 19000...
    But I can't find the massage..
    When you posted the massage nine minutes after me, I got you're massage, but
    could not read it.. It was marked with an X... And than it was gone.... can
    you copy the text you wrote and paste in a new post?

    thanks for helping me Ray! :)
     
    Christopher Brandsdal, Jul 28, 2003
    #3
  4. Christopher Brandsdal

    Ray at Guest

    That's odd. Here's the other post:

    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 home
     
    Ray at, Jul 28, 2003
    #4
    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...