Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 10 of 22 total
Thread Windows 10 problem
Mon, Jul 30 2018 10:18 AMPermanent Link

Mirco Malagoli

Lately I'm having problems accessing the database in systems with windows 10.
The database is in the ProgramData\my_name\app_name folder.
It happens that sometimes a simple select query is blocked or similar problems that seem related to an abnormal slowness of the database.
The same program has worked for years without problems and it seems that with the latest versions of windows 10 the problems have started.
In some cases seems removing the standard antivirus and loading a third-party antivirus the problem show less.
Has anyone else encountered similar problems?
Any suggestions?
Thanks!

Mirco
Mon, Jul 30 2018 11:00 AMPermanent Link

Fernando Dias

Team Elevate Team Elevate

Mirco,

You should exclude the database directory from anti-virus scans and see what happens.
Also, check out where are the temporary tables being created and if that location is also excluded from scans.
Are you using Client/Server or File Sharing?

--
Fernando Dias
[Team Elevate]
Mon, Jul 30 2018 11:54 AMPermanent Link

Mirco Malagoli

The program itself use local file but for other external application it create a server on the same database.

Fernando Dias wrote:

Mirco,

You should exclude the database directory from anti-virus scans and see what happens.
Also, check out where are the temporary tables being created and if that location is also excluded from scans.
Are you using Client/Server or File Sharing?

--
Fernando Dias
[Team Elevate]
Tue, Jul 31 2018 6:19 AMPermanent Link

Mirco Malagoli

Obviously the first thing I tried was to disable the windows 10 antivirus
Only after not having been successful I tried to use another antivirus but still without success


Fernando Dias wrote:

Mirco,

You should exclude the database directory from anti-virus scans and see what happens.
Also, check out where are the temporary tables being created and if that location is also excluded from scans.
Are you using Client/Server or File Sharing?

--
Fernando Dias
[Team Elevate]
Tue, Jul 31 2018 6:55 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Mirco


I'm with Fernando on this. Don't disable the AV but exclude any folders your application uses both local or remote from scanning.

Slowness could be caused by something as simple as the move from single user/local to single user/local plus remote user client/server. Windows will suddenly add in a different approach to sharing.

<<simple select query is blocked>>

Can you post an example of the SQL. I can think of a few things that might cause this but I'd like to see the query before I comment.

Roy Lambert
Tue, Jul 31 2018 2:48 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Mirco,

<< Lately I'm having problems accessing the database in systems with windows 10.
The database is in the ProgramData\my_name\app_name folder.
It happens that sometimes a simple select query is blocked or similar problems that seem related to an abnormal slowness of the database.
The same program has worked for years without problems and it seems that with the latest versions of windows 10 the problems have started. >>

So, the database tables are stored on the same Windows 10 machine ? If so, then you definitely have an issue with something external messing with the performance, and yes, it's probably AV software.

Tim Young
Elevate Software
www.elevatesoft.com
Wed, Aug 1 2018 2:40 AMPermanent Link

Mirco Malagoli

This is the query I use

"SELECT *, 1 AS nextrun INTO Memory\t1 FROM batt
LEFT OUTER JOIN orari ON orari.batteria = batt.num AND orari.finale = batt.finale
WHERE orario IS NOT NULL
ORDER BY finale, batteria, orario"

"SELECT batteria, nextrun, finale INTO Memory\t2 FROM Memory\t1
EXCEPT
SELECT batteria, prova, finale FROM gara
;
SELECT MIN(nextrun) AS totale, * INTO Memory\t3 FROM Memory\t2
JOIN Memory\t1 B ON B.batteria = batteria AND B.finale = finale AND nextrun = B.nextrun
GROUP BY batteria, finale
ORDER BY orario
;
SELECT *, cat.descriz AS categoria FROM Memory\t1 B
JOIN Memory\t3 A ON A.batteria = B.batteria AND A.finale = B.finale AND A.totale = B.nextrun
LEFT OUTER JOIN batt ON batt.num = B.batteria AND batt.finale = B.finale
LEFT OUTER JOIN cat ON cat.num = batt.cat
ORDER BY orario
;"
Wed, Aug 1 2018 3:11 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Mirco


Looking at those I would say an intermediate file has to be produced so either permissions or AV.

Roy Lambert
Wed, Aug 1 2018 10:48 AMPermanent Link

Mirco Malagoli

So in this case is better to put the PrivateDir in a known path instead of the default?
And do you think there is any reason why these problems only appeared with windows 10 after years of regular operation?

Thanks!
Mirco
Wed, Aug 1 2018 11:42 AMPermanent Link

Raul

Globestar Systems

Team Elevate Team Elevate

On 8/1/2018 10:48 AM, Mirco Malagoli wrote:
> So in this case is better to put the PrivateDir in a known path instead of the default?

Ideally yes since you can easily then exclude it from AV

> And do you think there is any reason why these problems only appeared with windows 10 after years of regular operation?

Microsoft is changing (breaking) a lot with Windows 10 - there have been
about 6 or 7 releases of Windows 10 already and they are adding thinds
and deprecating features also. Due to this frequent cycle i think there
is also less testing (i.e. we're the testers).

Long term servicing branches are are designed for stability and long
terms support but one can only get those under enterprise licensing.

Raul
Page 1 of 3Next Page
Jump to Page:  1 2 3
Image