VFP free tables in compressed folders

VFP free tables in compressed folders

• Akd02

  Dave M. wrote:

  Have you ever tested the performance

  I wanted to re-word my answer to this to give you a better feel. With minimal testing, about five different tables ranging in size from 10MB to 300MB, we could not notice any difference in response time between compressed and un-compressed folders.

  
  
  

• Cmcnear

  Hi Dave

  If Bill is talking about the standard NTFS Compression option (which is what he said - you know, where the drive shows up blue in Windows Explorer) then yes, I am sure. I have a small (5GB) drive compressed on my machine right now - and I can access DBFs stored there without any problem at all.

  However, if he is talking about one of the commercial data compression tools (which is what I think you are referring to) then no, you are correct, it won't work directly.

  
  
  

• Daniel Beravi

  Sorry you guys are correct, I just tried it. It works nicely.

  Have you ever tested the performance

  Dave

  
  
  

• asep supriatna

  Andy,

  Have you tried this  

   

  I am pretty sure the compassed folders are really just zip files. And it won’t work at all.

  Foxpro will probably issue a “file not found” error. If he does manage to get it to work he will defiantly take a performance hit.

   

  Bill,

  I think you copy a one of your larger apps into a compressed folder and try it. Better to be safe.

   

  Dave

  
  
  

• MattWilkinson2006

  :	Will Visual FoxPro free tables work fine on compressed drives or in compressed folders I am talking about the NTFS compression found under advanced attributes

  As far as I know there are no issues. compression is handled at the OS level not the application so the end result is that the table appears 'normal' to VFP/

  
  
  

• kikoBYTES

  AndyKr wrote:

  : Will Visual FoxPro free tables work fine on compressed drives or in compressed folders I am talking about the NTFS compression found under advanced attributes As far as I know there are no issues. compression is handled at the OS level not the application so the end result is that the table appears 'normal' to VFP/

  Thanks everyone! I thought that it was handled at the OS level and so VFP would not be affected (other than performance). On the tests I have done the performance hit seems to be minimal. For our application it is not an issue and the diskspace recovered is nice.

  Thanks again!

  
  
  

• Gerhard Schmeusser

  Dave:

  Don't confuse ZIP files with NTFS compressed folders. Those are handled at the OS level and are transparent to the applications (albeit a tad slower).

  
  

• Damian Coverly

  Hi Dave

  >> Have you ever tested the performance

  Not specifically - there must be an impact but I wouldn't be surprised if the OS level caching hides most of it anyway

  Billy's response seems to confirm that it is not too horrendous.

  
  
  
• VFP free tables in compressed folders