That's my experience too. I believe we had problems with DOS when we had more than 30.000 files but not Netware. Or was it the other way around :-) Senility. I suspect that Mark won't have that many pictures -- afterall he wants to print a report with the pictures.
I've never tried to work with more than 80.000 pictures. However I would think that storing the pictures directly in the tables is not an option anyhow because the size of the table would exceed 2.1 GB.
With Linux/Samba we had to be very careful accessing large directories of emails.
viele grüße
Jamie
>Hi,
>
>as you just mentioned the 'maybe' problem of too many files in the directory, some years ago I had to decide between a storing the picture in a db-table or just referencing to the specific directory.
>
>So I went and created a small prg that copied 10 KB to 2 MB jpg/gif/pdf/xls/doc up to 30000 times in the same directory and tested the time needed to display a single selected picture and additionally displayed a list of selected pictures using adir()
>
>
>ADIR(paArr,PADL(myPreselection,10,[0]) + [_????????_??????*.???],[],1)
>
>(The question marks replace timestamp (yyyymmdd_hhmmss)
>
>At that time I used W2K, in the meantime it has become XPSP2 and everything is working fine.
>
>So my conclusion: There is no need for storing Bitmaps in a table.
>
>However in case your pic-directory lies on a linux/samba directory, you will have to configure samba very carefully.
James Beerbower
James Beerbower Enterprises
Frankfurt, Deutschland