Velocity Reviews

Velocity Reviews (http://www.velocityreviews.com/forums/index.php)
-   ASP General (http://www.velocityreviews.com/forums/f65-asp-general.html)
-   -   CompactDatabase (http://www.velocityreviews.com/forums/t788924-compactdatabase.html)

Christopher Brandsdal 07-27-2003 07:53 PM

CompactDatabase
 
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 07-27-2003 09:05 PM

Re: CompactDatabase
 
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

--
Will trade ASP help for SQL Server help


"Christopher Brandsdal" <christopherwb@c2i.net> wrote in message
news:ujLD0iHVDHA.1052@TK2MSFTNGP09.phx.gbl...
> Anyone know? hmm..
> /////////////////////////////////
>




Christopher Brandsdal 07-28-2003 09:02 AM

Re: CompactDatabase
 
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 <%=sLocation%>" <myfirstname at lane34 dot com> skrev i melding
news:OEBJmJIVDHA.2096@TK2MSFTNGP11.phx.gbl...
> 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
>
> --
> Will trade ASP help for SQL Server help
>
>
> "Christopher Brandsdal" <christopherwb@c2i.net> wrote in message
> news:ujLD0iHVDHA.1052@TK2MSFTNGP09.phx.gbl...
> > Anyone know? hmm..
> > /////////////////////////////////
> >

>
>




Ray at 07-28-2003 04:35 PM

Re: CompactDatabase
 
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

--
Will trade ASP help for SQL Server help


"Christopher Brandsdal" <christopherwb@c2i.net> wrote in message
news:urXEBcOVDHA.2032@TK2MSFTNGP11.phx.gbl...
> 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 <%=sLocation%>" <myfirstname at lane34 dot com> skrev i melding
> news:OEBJmJIVDHA.2096@TK2MSFTNGP11.phx.gbl...
> > 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
> >
> > --
> > Will trade ASP help for SQL Server help
> >
> >
> > "Christopher Brandsdal" <christopherwb@c2i.net> wrote in message
> > news:ujLD0iHVDHA.1052@TK2MSFTNGP09.phx.gbl...
> > > Anyone know? hmm..
> > > /////////////////////////////////
> > >

> >
> >

>
>





All times are GMT. The time now is 09:47 PM.

Powered by vBulletin®. Copyright ©2000 - 2014, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.