Windows 10 and Studio 4

Wendy wizardcompserv at gmail.com
Tue Nov 5 07:30:09 EST 2019


Yes I did try reindexing it had no effect.

If this works I will just have to tell the customer they are not going to be update  any at a for a day!!

Kind regards
Wendy Osbaldestin
Wizard Computer Services
Tel:  01260271647
Mobile: 07740541021


-----Original Message-----
From: omnisdev-en [mailto:omnisdev-en-bounces at lists.omnis-dev.com] On Behalf Of Michael Mantkowski
Sent: 05 November 2019 12:25
To: 'OmnisDev List - English'
Subject: RE: Windows 10 and Studio 4

I think your doing the right thing in creating a new data file.

Another thing...  Have you tried reindexing the file that is giving you a problem?

*********************************************************************
Michael Mantkowski
ClienTrax Software
1-614-875-2245
*********************************************************************


-----Original Message-----
From: omnisdev-en On Behalf Of Wendy
Sent: Tuesday, November 5, 2019 7:18 AM
To: 'OmnisDev List - English' <omnisdev-en at lists.omnis-dev.com>
Subject: RE: Windows 10 and Studio 4

Hi Michael
Yes it is taking that time running on my system - longer in theirs.

I am currently exporting all the data to import into a new database -   the database is 2 segments and they only recently - in the last 6 months- started to use the 2nd segment - so I am hoping that the problem is that the database is fragmented .

 A full check data does not report any problems.

Kind regards
Wendy Osbaldestin
Wizard Computer Services
Tel:  01260271647
Mobile: 07740541021

-----Original Message-----
From: omnisdev-en [mailto:omnisdev-en-bounces at lists.omnis-dev.com] On Behalf Of Michael Mantkowski
Sent: 05 November 2019 12:08
To: 'OmnisDev List - English'
Subject: RE: Windows 10 and Studio 4

I agree that my suggestion had nothing to do with performance.  Only with proper file sharing.

You are saying that even on your system you are having a Find take 2 minutes?  That is in itself way out of line.  An index find should take 1/10 of a second at most. (I am of course assuming you are not loading up some huge mega bytes of data.)

Have you thought about exporting the data and then importing it into a new file?  Is every file class in the application suffering the same issue or is it only one?

Something is certainly fishy here.  

*********************************************************************
Michael Mantkowski
ClienTrax Software
1-614-875-2245
*********************************************************************


-----Original Message-----
From: omnisdev-en On Behalf Of Wendy
Sent: Tuesday, November 5, 2019 4:25 AM
To: 'OmnisDev List - English' <omnisdev-en at lists.omnis-dev.com>
Subject: RE: Windows 10 and Studio 4

Hi
The customer tried this and in fact the response time got even slower :-(

They are running on Studio 4.3.1.4 - all PC's - DML Database

The version of Omnis has not changed - there have been no changes to the database structure for well over a year.  A check data reports no damage.  I have tried reorganise and optimise on one file but..

On my computer with the database on my server the response time for a simple 'Find' command is over 2 minutes on the customers computers it is more than 10 minutes.

It appear to me that the search in not using the indexes but walking the file

Has anyone got any ideas as to what  I can do to speed things up?

Kind regards
Wendy Osbaldestin
Wizard Computer Services
Tel:  01260271647
Mobile: 07740541021

-----Original Message-----
From: omnisdev-en [mailto:omnisdev-en-bounces at lists.omnis-dev.com] On Behalf Of Michael Mantkowski
Sent: 29 October 2019 11:23
To: 'OmnisDev List - English'
Subject: RE: Windows 10 and Studio 4

Hi Wendy,

How have you shared the folder where your database resides?

Windows 10 by default has SMB1 turned off an dis using SMB3.  This can cause issues for Omnis.  However, there is a way to share a folder with SMB3 that works.

Here are the notes I have in my OpsLocks window.  I have not messed with this for a bit so its not fresh in my brain.

;  Windows 10 / 2012 /2016 / SMB3 - As the Server ;  Run the below in a Shell Script - Set the ClienTrax folder only to operate like SMB1

;  Set-SmbShare -Name "ClienTrax" -LeasingMode None     ;; None - Shared - Full  -  Full = Default

;  Allows you to run Shell Commands     ;; Restricted - RemoteSigned - Unrestricted  -  Restricted is Default
;  x86 (32 bit)
;  Open C:\Windows\SysWOW64\cmd.exe
;  Run the command powershell Set-ExecutionPolicy RemoteSigned

;  x64 (64 bit)
;  Open C:\Windows\system32\cmd.exe
;  Run the command powershell Set-ExecutionPolicy RemoteSigned

;  PowerShell Get-SmbConnection

;  https://blogs.technet.microsoft.com/josebda/2013/10/02/windows-server-2012-r2-which-version-of-the-smb-protocol-smb-1-0-smb-2-0-smb-2-1-smb-3-0-or-smb-3-02-are-you-using/



*********************************************************************
Michael Mantkowski
ClienTrax Software
1-614-875-2245
*********************************************************************


-----Original Message-----
From: omnisdev-en On Behalf Of Wendy
Sent: Tuesday, October 29, 2019 7:15 AM
To: 'OmnisDev List - English' <omnisdev-en at lists.omnis-dev.com>
Subject: RE: Windows 10 and Studio 4

Hi Bo
I am not using ODB but Omnis database commands.

This customer has reported Windows 10 hanging since they got their first 10 a while ago - now they are all on windows 10 it is a big problem. We never had a problem on windows 7 even with a 40 user installation.

Using Omnis 'Prepare for edit' the flag is set if another user is editing the same record,  The system checks for this and tells the user they cannot do it. 

Kind regards
Wendy Osbaldestin
Wizard Computer Services
Tel:  01260271647
Mobile: 07740541021


-----Original Message-----
From: omnisdev-en [mailto:omnisdev-en-bounces at lists.omnis-dev.com] On Behalf Of Bo Carleö
Sent: 29 October 2019 11:02
To: OmnisDev List - English
Subject: RE: Windows 10 and Studio 4

Hi Wendy

Yes - DML.
One client is running a 12 user setup via ODB.
I prevent two users to enter a simultaneous record in the same file slot.
May be a few seconds delay till the slot is free.

No changes in the Win setup - as far as I know.

Bo


På 29 oktober 2019 kl. 11:49:34, Wendy (wizardcompserv at gmail.com) skrev:

Hi Bo

Are you running on a DML? And could 2 people be entering the same record type at the same time ?

Also have you made any changes to the setup of Windows 10 - like when the hard drive sleeps or hibernates?

Kind regards
Wendy Osbaldestin
Wizard Computer Services
Tel: 01260271647
Mobile: 07740541021

-----Original Message-----
From: omnisdev-en [mailto:omnisdev-en-bounces at lists.omnis-dev.com] On Behalf Of Bo Carleö
Sent: 29 October 2019 10:03
To: OmnisDev List - English
Subject: Re: Windows 10 and Studio 4

Running 4.3.2 on Win 10 without any problems.

Bo


På 29 oktober 2019 kl. 10:49:34, Wendy (wizardcompserv at gmail.com) skrev:

Hi  



I am hoping someone else has had this problem.  



A customer of mine has been running the software on Studio 4.1 Omnis DML database on Windows 7 for the last 5 years.  



Now that they have had to upgrade their computers to Windows 10 they are finding that not only are the computers hanging but it is running as if 'Write behind cashing' is on but I have been assured that on all computers it is turned off.  



Has anyone else experienced this and is there a windows 10 setting I have missed  



Many thanks  

Wendy Osbaldestin  

Wizard Computer Services  

Tel: 01260271647  

Mobile: 07740541021  



_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com  

_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 

_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 

_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 

_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 

_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 

_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 

_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 




More information about the omnisdev-en mailing list