[MSAccessProfessionals] Slow search next / previous on remote server in VPN

I had to move the backend of a project to a remote server and connect it via VPN.

 

if I search for a specific serial number example:

SELECT serialnumber

FROM tbl Transformer

WHERE serialnumber = '2020001513-001'

the answer is immediate

 

but if I do it via the next / previus button example:

 

next:

SELECT TOP 1 serialnumber

FROM tbl Transformer

WHEREserialnumber)> '2020001513-001'

ORDER BY tblTransformer.serialnumber

 

Previous:

SELECT TOP 1 serialnumber

FROM tbl Transformer

WHERE serialnumber <'2020001513-001'

ORDER BY serialnumber DESC

 

the first time it takes 30 seconds to find the record, then it finds it almost immediately. However, if I change my sense of research, it always takes 30 seconds the first time.

 

Is there a faster way?

 

Thank you very much

Domenico

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116175) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_