Re: Compact data file

2018-12-03 Thread Koen Van Hooreweghe via 4D_Tech
Hi Keith, Considering this issue. Last week I had to repair a v16 datafile. In the MSC, right after the repair I ran a verification. The verification was done on the old datafile. The repaired datafile was still in the subfolder '...repairing...' instead of on the original location as I would e

Re: Compact data file

2018-12-01 Thread stardata.info via 4D_Tech
Keith, I have checked but the data file are in correct folder. When i compact data file with MSC, the operation is very slow.. I strange for one data file woth only 5.000 records.. Thanks Ferdinando Il 01/12/2018 21:41, Keith Goebel ha scritto: Fernando, Check out the data file that has

Re: Compact data file

2018-12-01 Thread Keith Goebel via 4D_Tech
Fernando, Check out the data file that has been moved to the “Old” folder. Using v17HF3 I have found that, after compacting on Win7, the data files are in the opposite place they are supposed to be (i.e. the compacted one is in the “old” folder and the old one is now the current one). Not saying

Re: Compact data file

2018-12-01 Thread stardata.info via 4D_Tech
data file. Thanks Ferdinando Message: 4 Date: Sat, 1 Dec 2018 09:21:14 + From: UKVetDerm To: 4D iNug Technical<4d_tech@lists.4d.com> Subject: Re: Compact data file Message-ID:<62926b3f-37f5-465a-a8ba-0f1e569e4...@ukvetderm.co.uk> Content-Type: text/plain; charset="utf-8"

Re: Compact data file

2018-12-01 Thread UKVetDerm via 4D_Tech
What size was the file originally? Are there any BLOBS or Images in the data? It does seem odd. A couple of ideas I presume the records have been deleted and not marked as deleted Have you tried experimenting with the settings in the advanced TAB (I can't remember if this is available in v13)

Compact data file

2018-12-01 Thread stardata.info via 4D_Tech
I all, In one application with 4D V13.4 i have deleted 6/7 millions of records, and I need to compact the data file. Using MSC I can to compact the data file, but the dimension remains over 100.000 Kb, and is not real because in the data file remain only 6.000 records. Data index is 700 Kb.