Large Database Strategies

[ashwken]

Don't let your database become unnessarily large.

Instead of Storing external files inside the UR database, create a sub-folder structure below the UR database location, then Link (not Store, Copy or Move) to the external file.

The file path (UR URL Attribute) will be relative when importing from child folders of the UR database location, Links outside the UR data path will be absolute (full drive path).

If you need to transport, distribute, or backup your database this folder stratgey makes things a whole lot easier.

Granted, it does nothing to shrink the amount (filesize) data you must deal with (UR database + Linked files); I'm just a firm believer of not putting something (phyiscally) into a database unless you really have to.