Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 10 of 22 total |
Windows 10 problem |
Mon, Jul 30 2018 10:18 AM | Permanent 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 AM | Permanent Link |
Fernando Dias 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 AM | Permanent 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 AM | Permanent 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 AM | Permanent Link |
Roy Lambert NLH Associates 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 AM | Permanent 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 AM | Permanent Link |
Roy Lambert NLH Associates 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 AM | Permanent 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 AM | Permanent Link |
Raul 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 3 | Next Page » | |
Jump to Page: 1 2 3 |
This web page was last updated on Tuesday, May 7, 2024 at 06:25 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |