Generally, I'd suggest that if the images or documents are going to remain fairly static and their numbers large, store them on disk. My reasoning is this: as your #4 file grows, each incremental backup will include the entire #4 file since it will have changed, whereas incremental backups on a large number of static files will skip them (since they were backed up, presumably, during your full backup on which the incremental is based.)
So it isn't so much a question of whether the database can handle the files stored internally, but the logistics of backups. If your files change frequently, then the database may be a more appropriate place to keep them. Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Wednesday, April 29, 2009 11:23 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Instruction files in table Emmitt, I now presently have a table that contains my assembly drawings (BMP files). In regards to your suggestion about the DOC files, should I also store the path to those BMP files rather than having them stored in my table? Or are BMP files handled differently? Jim _____ From: [email protected] [mailto:[email protected]] On Behalf Of Emmitt Dove Sent: Wednesday, April 29, 2009 10:16 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Instruction files in table Jim, You can use a VARBIT column to store the Word docs, but your file 4 will grow immensely. If you're talking about a lot of documents, store them in a subfolder and, within R:BASE, just store the path to the doc. Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Wednesday, April 29, 2009 10:27 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Instruction files in table I have many WORD documents that are instructions that go with the products we ship. At present we can print them from a form I created that uses the LAUNCH command. Can I import these documents into a table within RBASE and if I can what data type would I use? Jim I am using the latest version of 7.6.
