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. Advertising

  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

    "Christopher Brandsdal" <> wrote in message
    news:...
    > 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
    >
    >
     
    Ray at, Jul 25, 2003
    #2
    1. Advertising

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Christopher Brandsdal

    CompactDatabase

    Christopher Brandsdal, Jul 27, 2003, in forum: ASP General
    Replies:
    3
    Views:
    117
    Ray at
    Jul 28, 2003
Loading...

Share This Page