Programming with dBASE - Slowdown on Startup

Author

Slowdown on Startup

Martin

2006-12-11, 12:12 am

Hi All,

I have a GL application written using DBase Plus 2.6. ( using dbf on file
server )
This GL have been running quite well for sometime until recently
I received complain from my client concerning slow down on startup and
opening form.
After checking I found that the Norton Anti Virus causing the slowdown.

The difference with previously running well is the increasing users to 5 (
before was only 2)

The current condition with 5 users dan NAV enabled,
it took more than 8 seconds to open Journal form.
When NAV disabled, it took only 2-3 seconds to load Journal form (
acceptable speed).

Why NAV causing slowdown even when I checked NAV processes in Task Manager
which showing no cpu cycles ?

Any idea how to fix this slowndown problem?

Regards,
Martin

Glenn Johansen

2006-12-11, 7:14 pm

do not use deo, place all programs in a single exe.
That solved my problems.
I was looking at 20-30 second loadtimes with deo, now my app loads in about
2 seconds.

--
Glenn Johansen
Software Architects, Inc.
(864) 963-8402
"Martin" <hungmart@centrin.net.id> wrote in message
news:98tAFfNHHHA.1144@news-server...
> Hi All,
>
> I have a GL application written using DBase Plus 2.6. ( using dbf on file
> server )
> This GL have been running quite well for sometime until recently
> I received complain from my client concerning slow down on startup and
> opening form.
> After checking I found that the Norton Anti Virus causing the slowdown.
>
> The difference with previously running well is the increasing users to 5 (
> before was only 2)
>
> The current condition with 5 users dan NAV enabled,
> it took more than 8 seconds to open Journal form.
> When NAV disabled, it took only 2-3 seconds to load Journal form (
> acceptable speed).
>
> Why NAV causing slowdown even when I checked NAV processes in Task Manager
> which showing no cpu cycles ?
>
> Any idea how to fix this slowndown problem?
>
>
> Regards,
> Martin
>
>

Les Shewchuk

2006-12-11, 7:14 pm

Glenn's right about one thing. NAV doesn't like DEO objects.

Also, what can happen is different instances of NAV will end up scanning
your files multiple times.

You could also try adding dbf, mdx, dbt and all DEO object extensions (pro,
rpo, co...) to your NAV ignore lists on both your server and workstations.
Adding the folder(s) to the ignore list could help too, but not always, as
the folders have different names from different start points (on the server
it may be c:\dBase\MyApp and from the workstation \\server\Accounting )

I have also found that the corporate version, Symantec Anti-Virus (SAV) is
faster and less of a resource hog than NAV....but it is almost twice as
much.

Les Shewchuk

"Glenn Johansen" <gjohansen@softarch.net> wrote in message
news:CVv4CtTHHHA.1976@news-server...
> do not use deo, place all programs in a single exe.
> That solved my problems.
> I was looking at 20-30 second loadtimes with deo, now my app loads in
> about
> 2 seconds.
>
> --
> Glenn Johansen
> Software Architects, Inc.
> (864) 963-8402
> "Martin" <hungmart@centrin.net.id> wrote in message
> news:98tAFfNHHHA.1144@news-server...
>
>

Dennis Levy

2006-12-11, 7:14 pm

I literally worked with Norton engineers for over 50 hours and could not
resolve the problem.
Dennis

Martin wrote:
> Hi All,
>
> I have a GL application written using DBase Plus 2.6. ( using dbf on file
> server )
> This GL have been running quite well for sometime until recently
> I received complain from my client concerning slow down on startup and
> opening form.
> After checking I found that the Norton Anti Virus causing the slowdown.
>
> The difference with previously running well is the increasing users to 5 (
> before was only 2)
>
> The current condition with 5 users dan NAV enabled,
> it took more than 8 seconds to open Journal form.
> When NAV disabled, it took only 2-3 seconds to load Journal form (
> acceptable speed).
>
> Why NAV causing slowdown even when I checked NAV processes in Task Manager
> which showing no cpu cycles ?
>
> Any idea how to fix this slowndown problem?
>
>
> Regards,
> Martin
>
>

Martin

2006-12-12, 12:13 am

Thanks for info, I will try it

"Glenn Johansen" <gjohansen@softarch.net> wrote in message
news:CVv4CtTHHHA.1976@news-server...
> do not use deo, place all programs in a single exe.
> That solved my problems.
> I was looking at 20-30 second loadtimes with deo, now my app loads in
> about
> 2 seconds.
>
> --
> Glenn Johansen
> Software Architects, Inc.
> (864) 963-8402
> "Martin" <hungmart@centrin.net.id> wrote in message
> news:98tAFfNHHHA.1144@news-server...
>
>

Sponsored Links