Hi JM, Actually, I wasn't too surprised myself - evidenced by how quickly I discovered it - I just had a hunch for some reason.
It doesn't actually bother me too much but I would have liked to have known that images in a temp table were treated differently - assuming this to be true - beforehand. My original plan was to use the temp table to gather the images and then be able to move backwards and forwards through the table to view them without having to read or write from the hard disk each time. Indeed, as long as I don't want to do anything other than view them actual size, that works _very_ well. It is only if I want to use the RBLOB.DLL to change the size in some manner that using a temp table becomes convoluted and resource intensive - and even then it works. My only real point was that the temp table didn't _appear_ to do what I believe to be the point of having a temp table was: keep the data in temporary storage (.$$$ files) which was lost on dropping or disconnecting. Reloading or backing up correctly reduces the file size but if a simple copy of the database is made (copy db.rb? bu.rb?) there could be a nasty surprise in the disk space needed. Regards, Alastair. ----- Original Message ----- From: "J.M. GRATIAS" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Monday, February 17, 2003 10:04 PM Subject: [RBASE-L] - Re: Size of RB4 file Alastair : >> I've just run a test to see if I was imagining this phenomenon and this is the result. I used the Windows search utility - Find Files - to display the database files. The RB4 showed 2mb at this point. I then created a special temp table that contained 400 images. As the table was being created I periodically clicked on the "Find Now" button on the utility. The size only increased by a few hundred kb while the image were being added to the table. When I disconnected the database however the size of the RB4 file changed to over 32mb! << This seems logical to me (as far as I had understood temp tables). Temp tables don't increase the size of RB2 file, because datas (text) is stored into temp $$$ files. Your experiment seems to demonstrate that images are always stored into RB4 files, for both perm/temp tables. What RBTI say about this ? I am not sure that anybody did, up to now, store images in a temp table. Is there any interest in doing that ? J.M. GRATIAS, Logimatique
