>>I'm fully agree with you, storing the pictures in the table is a pain. The table will grow and grow, and search times will be going down. I always store only the path.
>
>Pablo, I disagree with you. I use 2 separate tables to store binary data. First table (documents) is main and used for search. Second table is binary data only related with documents table by ID. And space such data storing takes is not more than space that stored files takes on disk - no difference.
Well it's good to have different oppinions. But here's mine:
- You are right the data are in separate files DBF and FPT, and ok there is no extra low speed for seeking, that was a miss I did.
- I have observed that storing the pictures in the FPT you have extra bytes. I can't remember is this was for JPEG or bitmap, but I got more or less a 10% percent more.
- I wanna keep away from FPT all the data I don't really need there, and if this gaves me a table with no FPT. hurra! You should know of many FPT going corrupted.
Best,