it depends on how many attachments you have. And yes, it does make the database bigger. Another problem with attachments is that often the same file is duplicated in the database (well probably not pictures of employees, but I found only 30% unique files for reference documents in one of the databases I analyzed and took attachments out of) whereas if it was referencing an external file, it would just be another text field with the path and filename.
I generally create a directory below the back-end with all the referenced files so it is easy to move them along with the database and everyone can get the same file even if their paths are different.
~ have an awesome day ~
I was just given a new project on a database that I did not build. There is an attachment field on the form. I am not very familiar with that. I was always told that it bloats databases. Yet when I tested the process, it looked like the opening of the attached files where looking at a location in a folder.
So the question is, does the attached field bloat the database and make the 2GB limit a quick reach in a very short time?
Posted by: crystal 8 <firstname.lastname@example.org>
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (2)|