Timeout on specific computer

I have a simple table with 270k records that is working fine for all users. I have a second table with 5k of those 270k records but almost no users can see this page. They all get a timeout and in Sentry i also see the 30 seconds timeout exceeded. If i sign in with their user accounts on my own computer it is working fine. Any reason why this page with table couldnt load on this specific computers?
10 Replies
toeknee
toeknee2mo ago
Nope.... debug the queries? Increase timeout and find the problem, then lower timeout. Likely an index to the current user
Thijmen
Thijmen2mo ago
The 5k records are in the same table as the 270k records. And loading the 270k records doesnt give a timeout. So nothing wrong with the queries right?
toeknee
toeknee2mo ago
something is clearly different though.... unless it's a random timeout and the server is struggling or a backup is happening with locks in place
Thijmen
Thijmen2mo ago
I am using getEloquentQuery() on the second table. I removed that and it didnt fix it. Everything else is the same about the two pages. And like i said, for me everything is working fine but on their computers it isnt working So server seems to be working fine
toeknee
toeknee2mo ago
And you tried on non-https and you tried using their logins?
Thijmen
Thijmen2mo ago
Yes i did For those user logging out and logging in again on their pcs seem to work But i remember we tried this before and after a while it will break again
toeknee
toeknee2mo ago
Weird, need to inspect the requests with telescope I'd say, then you can see it coming in and what happens?
Thijmen
Thijmen2mo ago
I could try that. I solved it right now by logging in again. So not sure why that would fix the problem.
micraux
micraux2mo ago
Could it be a cache/session issue?
Thijmen
Thijmen4w ago
Not sure how but also my guess for now.
Want results from more Discord servers?
Add your server