emmanuelkatto24
New member
- Local time
- Today, 05:55
- Joined
- Oct 17, 2024
- Messages
- 12
Hey everyone,
I’m Emmanuel Katto from Dubai, United Arab Emirates (UAE) experiencing some unusual performance behavior in MS Access and would love to get your thoughts or suggestions. Here’s the issue:
Regards
Emmanuel Katto
I’m Emmanuel Katto from Dubai, United Arab Emirates (UAE) experiencing some unusual performance behavior in MS Access and would love to get your thoughts or suggestions. Here’s the issue:
- I have a table (Y) with around 30K records.
- I’m running two identical queries in Access:
SELECT x FROM Y WHERE x = "a" - When I open the first query, it loads almost instantly. But when I keep the first query open and open the second identical query, it takes 15 seconds to load, which seems unusually slow.
Regards
Emmanuel Katto