Are you opening the database first, or going directly into the MSC without
opening the database first?
I don’t think the cache settings are taken into account unless the database is
opened first :-/
I just did a quick test (I tested Windows first; still need to test Mac) and my
used memory befo
By "no longer needed" I was referring to Chip's suggestion of reindexing with
SQL. Prior to v15R-release indexes were built in creation order, which made
horrible use of the cache. Now it goes in table order which makes it MUCH
faster on a large data file.
I think I understand the problem you
Chuck,
> On Jul 26, 2018, at 11:50 AM, Charles Miller via 4D_Tech
> <4d_tech@lists.4d.com> wrote:
>
> I did not. I meanty sql calls, but you are correct, object fields need to
> be handled in a different way. That is why I never use object fields. I do
> not think 4D should ever create field typ
I did not. I meanty sql calls, but you are correct, object fields need to
be handled in a different way. That is why I never use object fields. I do
not think 4D should ever create field types that work in 4D but not in SQL
or vice versa. I will not use them no matter how cool they may be. There
ar
> On Jul 26, 2018, at 11:21 AM, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
> Sometimes it is better to use sql to recreate data file. Now that v16 handles
> blob arrays it is very fast.
If you mean SQL EXPORT DATABASE, it will not work if the database has object
fields.
John
Hi Jeff,
> On Jul 26, 2018, at 11:05 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
> No longer needed in v16. A compact will reorganize the data file, and then
> do a complete reindex.
This is what I'm trying to do that is not working without forcing 4D to quit
and reindex s
I do not think this will work any longer because
A. Indices that point to related records and on related records can not be
turned off
B. A primary key or in fact any key that is set as unique must have indexing
turned on
Sometimes it is better to use sql to recreate data file. Now that v16 ha
the issue John brought up was the reindexing process.
the cache appeared NOT to be used, and not to be set to large values.
>From John
2. Wait for hours and the progress bar finally reaches the last table
and is pixels away from the end. Wait for many more hours, nothing
seems to be happening ev
No longer needed in v16. A compact will reorganize the data file, and then do
a complete reindex.
We do our compacts on 4D Server 64-bit on Windows. We do it on a machine that
has enough RAM so that the cache never gets used up. Since version 16 and the
latest new-and-improved cache manager on
I have not had to do this, but I remember seeing others mention this
process.
it went something like this:
- TURN OFF the indexes through out the database.
- let compact do its job
- TURN ON indexes through out the database
- let database index
-- not sure if this is needed/helps but you might w
10 matches
Mail list logo
