Compression of Databases
Hello, I am using my databases on FileMaker Server and some of the databases are heavy like > 8.0 MB. Is there any way to compress them or some thing so they can work faster on a network.
One of my databases now exceeds 4 GB and it is still accessible over the network. I have to be careful what sorts and searches I do, but it's quite functional.
8mb is not very large. Just one high resoulution photo can be over 8mb. Compression doesn't speed up a network, compression is used to save space. It would slow it down because it would have to compress the data then uncompress the data when needed those steps would slow the network down even more. The speed of your computers, harddrives, router/switch, network card would be items to look at to speed up the network..
Compression will not make them faster over the network, The only compression that leaves the database functional, is to use save a copy as... with the compressed option. It doesn't produce a dramatically smaller file, but is a good idea to do before uploading a file to your server.
Ok I also have a database with files imported into it in PDF, XLS and DOC formats and its size is 468 MB, will it run over the network and if its accessed externally through a static IP.
Yes you can access Filemaker Server externally through a static ip address. Filemaker 11 file size limit is 8TB.
Retrieving data ...