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
