I may add that if you store a lot of pictures within the database, it grows very quickly. For example, the most common picture size I use (1280x960 pixels) takes app. 400 Kb of disk space plus overhead, if you store 1000 pictures in your database, it will grow to app. 500 Mb due to the pictures alone, and when you do backups, you will be backing up data that does not (really) change. If you store the pictures outside the database and store just the names, then all you need is one good backup of your pictures, as the pictures do not change, and the database stays very small. Javier
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln., Suite #14 Olathe, KS 66062-4571 (913)829-0888 (913)649-2904 FAX -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of David M. Blocker Sent: Tuesday, February 11, 2003 8:51 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: BLOB assistance Andrew BInary large objects are images. You can handle them in one of two ways: 1. Store them in a column in a table - ie, your plants table could have an PlantPicture column which would be LONG VARBIT datatype (VARBIT in the RBDEFINE screen). 2. Store them on separate files on your disk and store just the name of the file in the database. Method 2 has the advantage of keeping your database size more reasonable and making maintenance tasks like PACK and RELOAD faster. Method 1 gets you somewhat faster access to the image. Let me know if you want more details David Blocker ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Monday, February 10, 2003 3:31 PM Subject: [RBASE-L] - BLOB assistance > The lowly student asking the masters..... > > I am using version 6.1 for windows and build 1.578x037Y on Win98SE am unable > to understand the mystery of Binary Large Objects. The help screen seems > awfully short as to what table they are stored in, how I can refer back to > them once I have forgotten the name of the variable they were loaded with, > etc. > > Any points would be appreciated. We are a small landscape company also > considering loading quite a few pictures of plants, etc. and was wondering if > there were any limitations to individual files sizes as well as total > quantity. > > I was kind of lost by Microrim when they dropped the OS/2 version and sent me > the new v6.1 for windows on floppy as a token, but no updated books, so all > of my printed reference is with v5.5. > > Thank you.... > > Andrew Skoog > >
