>
> >Michel,
> >
> >I remember your threads of a few weeks ago. I do not know if this is
> relevant, but I came up with something interesting just now.
> >
> >I have a log file that contained 78K records. I deleted like 55 K records
> from it. Mind you it is not indexed, etc, it is not even part of a DBC.
> Now it takes for ever (3 à 4 seconds to open, or to do anything with it).
> It is opened shared.
> >
> >Marc
>
> Does SET DELETED affect the load time in your case ? If so, I think i may
> know the solution.
Glen,
I do not know. SET DELETE was ON. I guess setting it off would have
open the file faster. I packed the table since then.
Thanks.
Marc
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.