Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo fields... Is there some alternative for it?
Message
From
26/03/2003 19:23:50
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00770258
Message ID:
00770554
Views:
14
Rodolfo,

Gerry's idea may be a good idea for your situation, but here's something to keep in mind. If the individual files would be small, you will end up wasting a lot of disk space relative to the amount of data you are storing. For example, if you have a cluster size of 8K on the disk, every file will use 8K of disk space, even if there is only 50 bytes in the file.

You can regularly pack the memo file, but memo files shouldn't waste space in situations where records are not deleted, and where the the contents of the memo field does not change after the memo field has been saved the first time.

>Hi!
>
>I use a couple of memo fields to save a audit data and I had been have some problems:
>
>1) The file grows up so fast...
>2) Sometimes, FPT file is corrupted.
>
>So, I'd like to know If I have other alternative to replace the memo fields...
>
>Any idea is appreciate! ;-)
>
>[]s!
Steve Gibson
Previous
Reply
Map
View

Click here to load this message in the networking platform