I have 2 comparable tables (in terms of number of fields & data type). The Access BE one has 60k records & is pretty much instant to open it & skip down to the last record. The one in sql-server is only 30k records and is taking 30 seconds to skip to the last record. Before Monday it too was pretty much instant.
I've got 25 nurses who would usually be answering help line calls to disabled children's parents, sitting around unable to work or back using pen & paper. Unfortunately this may well be the final nail in the coffin for Access as far as this company is concerned :-(.
On Wed, Jan 10, 2024 at 07:18 AM, Richard Rost wrote:
I've noticed this recently as well. I have a lot of databases that connect to my website's SQL Server. I've noticed they're taking a good 3 to 5 seconds longer to connect recently. Once connected they work fine, however.
--
Live Long and Prosper
Richard Rost
Microsoft MVP 2023
President/CEO
Access Learning Zone
_._,_._,_
Groups.io Links:
You receive all messages sent to this group.
View/Reply Online (#116513) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]
_._,_._,_
Tidak ada komentar:
Posting Komentar