All Questions
8 questions
3
votes
1
answer
136
views
Faster Query to Track State changes in a Large Table
I have a table that tracks state changes of an entity with timestamps. The schema of the table is as follows:
entityid
userid
originalvalue
newvalue
changetime
255
101
Draft
Submitted
2023-11-28 12:10:...
- 53
1
vote
1
answer
87
views
Decrease execution time in updating rows in PHP
Any tips on how the below code can be optimised for faster execution?
I have a table in postgres called staging with the below columns;
...
- 13
1
vote
1
answer
36
views
Classifying counts of repeat visits per user for a website
I am trying to get number of times (or sessions) a user re-visited the website.
What I'm trying to find out-
Get the total number of users, number of sessions in the last 30days. I need to a pie ...
- 111
5
votes
2
answers
135
views
Determine number of times an id was used with a domain IP
This is a slow query and the table has 50 million rows.
Table named 'log':
...
- 153
3
votes
0
answers
422
views
MySQL Schema for Tag System Works, But Can It Be Better?
I'm working on system that tags images. I'm going to use the xxHash (lz4) for hashing images. With hashes of size 64 bits, it looks like I won't have a 50% chance of a collision until ~4 billion ...
- 131
2
votes
1
answer
52
views
Map groups to parent products using nested subqueries
I have the following tables
...
1
vote
3
answers
191
views
Checking user access to servers
I have pasted a method I wrote, which is too slow to my liking (easily takes 60+ seconds to execute). The method loops through 12 different servers, checks if userX has access to any of the databases ...
- 155
2
votes
1
answer
552
views
Performance shifting for SQL Database and Linq memory grouping
I am messing around with shifting between stored procedures and business layer EF getting data rapidly then processing in memory.
This works and on a static data range of 3 months I get execution ...
- 269