Hi Ben (I wonder if you'll get this before you reply to it <g> - a private joke - 4 hours this time!!)
Is there a benefit - no, not really, but I had to create a temp table to identify the images I wanted and it seemed logical to put the images in there as well. I assumed that it would be quicker and/or more efficient. If I wanted to always use the image "as is" then it probably would be the better way to leave them on the hard disk. I got caught out by not realising beforehand that to use the RBLOB.DLL to re-size them I needed to write the image back to a file first. Then I found it easier to always write to the same filename and read back in to the variable on the form. I ended up with a variable to write to disk and another to display. It sounds long-winded and heavy on resources but works rather well and means that all I ever have to do is select the files for display and never worry about their filenames. I can move backwards and forwards through the table and get the relevant image displayed. I also assumed that a temporary table would not increase the size of the database but it _seems_ to. Since this morning the size of my RB4 has already grown to over 2mb and I've done nothing that I'd expect to increase its size. Regards, Alastair. ----- Original Message ----- From: "Ben Petersen" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, February 14, 2003 7:12 AM Subject: [RBASE-L] - Re: Size of RB4 file > Alastair, > > Is there a benefit in having the images stored in the database as > opposed to referring to their file name and leaving them naked on > the harddrive? > > Ben Petersen > > > On 14 Feb 2003, at 11:16, Alastair Burr wrote: > > > I have been doing some work over the last week or so learning how to > > use images in forms and trying to find the best way to display them - > > as you may have realised from other questions that I've recently > > posted to this list. > > > > Having got, more or less, what I wanted to do to work I decided to > > reload the database just to remove the small amount of wasted space I > > knew that I had created. > > > > I was surprised to see that the RB4 file was over 61mb before I ran > > the reload and it shrunk to just less than 1.75mb afterwards - which > > is what I would have expected it to be. > > > > So where did another almost 60mb come from? > > > > I've made lots of changes to 2 or 3 forms but they are all very simple > > forms with less than a dozen variables altogether. I've also > > repeatedly created a temporary table that held a few images for me to > > experiment on. I could easily imagine this reaching 60mb over time. I > > can also imagine that I may have created the table as a permanent one > > by mistake once but I don't remember trace warning that the temp table > > was a duplicate at any time and it didn't exist when I did the reload. > > > > This leads me to ask whether R:Base has to store images in a temporary > > table in the RB4 file? > > > > > > Regards, > > Alastair. > > > > ---------------------------------- > > A D B Burr, > > St. Albans, UK. > > ---------------------------------- > > [EMAIL PROTECTED] > > ---------------------------------- > > >
