Should not compress SQL database???

[Cicada]

Below Microsoft Web site suggest people not to compress SQL server database.
Does this rule apply to MS Access?

http://blogs.msdn.com/khen1234/archive/2005/04/25/411852.aspx

 

[Pieter Wijnen]

au contraire
SQL Server & Oracle for that matter are "proper" SQL Databases, Jet Database
(Read: MsAccess) is just another file..
Jet tend to perform better with regular Compact (as your computer after a
Defrag of it's harddrives).

PS and I'm not entirely in accord with the blog, I would definitly Truncate
(Compress) a log/dbf file that has bloated out of proportions, admittedly
this should not happen, but I haven't designed all Database systems, nor
loaded data into all of them <g>

Pieter

Oracle Professional DBA (& tinkerer in MSSQL)

 

[Pieter Wijnen]

au contraire
SQL Server & Oracle for that matter are "proper" SQL Databases, Jet Database
(Read: MsAccess) is just another file..
Jet tend to perform better with regular Compact (as your computer after a
Defrag of it's harddrives).

PS and I'm not entirely in accord with the blog, I would definitly Truncate
(Compress) a log/dbf file that has bloated out of proportions, admittedly
this should not happen, but I haven't designed all Database systems, nor
loaded data into all of them <g>

Pieter

Oracle Professional DBA (& tinkerer in MSSQL)

Below Microsoft Web site suggest people not to compress SQL server
database.
Does this rule apply to MS Access?

http://blogs.msdn.com/khen1234/archive/2005/04/25/411852.aspx

--

 

[Cicada]

Thanks very much!
I understand now.

How about ADO, which use OLE DB.
Is it as stable as JET for compressing data??


"Pieter Wijnen"

 

[Pieter Wijnen]

same thing (it will use DAO to do the job)

Pieter

Thanks very much!
I understand now.

How about ADO, which use OLE DB.
Is it as stable as JET for compressing data??


"Pieter Wijnen"

--