Faster response on Sql with Pervasive
In vb6 I use SQL like e.g. select * from DEBNAW where ucase(DEBNAME1) LIKE '%JAN%'
on stand alone Pc its fast 600 returns and displayed and sorted in 1 second
on network Vmware , same call 3 seconds , users complain about this
would this be possible to speed up??[
pc.png
netwerk.png
on stand alone Pc its fast 600 returns and displayed and sorted in 1 second
on network Vmware , same call 3 seconds , users complain about this
would this be possible to speed up??[
pc.png
netwerk.png
lcohan
Kindly what is on "network vmware"? Is it your SQL Server or the Client running it?
ASKER
Pervasive Windows Server standard 2016 runs on Hyperware hardware this is the Sql server
All Host Windows 10-pro run on Vmware hardware esx 6.7 as clients
All Host Windows 10-pro run on Vmware hardware esx 6.7 as clients
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.