CompactDatabase

[Christopher Brandsdal]

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

 

[Ray at]

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

 

[Christopher Brandsdal]

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!

 

[Ray at]

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