Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > CompactDatabase

Reply
Thread Tools

CompactDatabase

 
 
Christopher Brandsdal
Guest
Posts: n/a
 
      07-25-2003
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


 
Reply With Quote
 
 
 
 
Ray at
Guest
Posts: n/a
 
      07-25-2003
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
CompactDatabase Christopher Brandsdal ASP General 3 07-28-2003 04:35 PM



Advertisments