I have a small database that uses pictures in both the form and report. I keep the pictures outside the database. I have had no issues and like the freedom of changing the pics if need be without going through the database.
I prefer the pics outside rather than inside the database. It just seems long term a cleaner and more flexible approach. I am sure everyone will have the own opinion. Key is what do you expect the database to look like in 5-10 years? Gary -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dan Goldberg Sent: Friday, July 01, 2011 12:15 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Storing pictures outside the database I have currently about 5600 jpgs stored in my database. No slow downs yet. What I do for us is I make sure they are not too large in size. I try to keep them at 800 x 600. Dan Goldberg -------------------------------------------------- From: "Dick Fey" <[email protected]> Sent: Friday, July 01, 2011 8:38 AM To: "RBASE-L Mailing List" <[email protected]> Subject: [RBASE-L] - Storing pictures outside the database Using 9.1, latest build. Our product photo database is growing and starting to slow things down. We have found that having pics of all our products instantly available would be very helpful. Therefore we are looking at putting all 8000 of our product pics on file. I know I have seen discussion on this board about storing jpeg's outside the database, but cannot remember how to access the archives. I assume you just store the address in the database, and call the jpeg from the outside file as needed. Any tips on doing this in the most efficient way, particularly regarding how to load them into a form viewer would be appreciated. Thanks, Dick Fey Carpet Broker Inc. --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
