Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BIG!!!! Pictures in General fields and VERY slow
Message
From
13/12/2003 20:03:51
 
 
To
13/12/2003 16:05:48
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Pictures and Image processing
Miscellaneous
Thread ID:
00858269
Message ID:
00858943
Views:
16
> I think it would depend on some factors, including expected size (will
> approach the 2 GB limit, or not), which approach is better for a specific
> purpose.

I don't think that the 2 GByte limit is an important factor in deciding whether to use memo fields or external files. If you have a lot of images then you need a partitioning scheme of sorts in any case (multiple tables in the case of .DBF, multiple directories in the case of external files).

I can store about a quarter million images in a single Fox table but how many files can I put into a directory before accesses become prohibitively slow? 1000? 10000? So the partitioning needs a bit more thought in the file system case. In the Fox memo case I just partition at 650 MByte which is convenient for backup/archival onto MO, PD and CD-ROM. This is only one third of the possible maximum but the dispatch code doesn't care whether the master table has 100 records or 300 - it does just a single seek anyway. It does not matter where the tables are actually located on the network as long as they are registered in the master table.

Similar things can be done with directories, it just won't be as easy.

I think the major criteria against memo storage are:
- necessity for shared access with other apps (paint program, webserver)
- frequent updates, especially if update patterns run afoul of the partitioning
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform