Leandro

PostsComments

CC#

•Created by Leandro on 2/9/2025 in #help

refactor database to stop using UNIQUEIDENTIFIER as PK

unfortunately I cannot, my budget is very low. Quartz still needs a db right? It might be worth a shot to try but I'm inclined to think that a solution with 0 database usage would be better

60 replies

CC#

•Created by Leandro on 2/9/2025 in #help

refactor database to stop using UNIQUEIDENTIFIER as PK

but I'm considering just removing this crazy lib and try to do with lambdas and event bridges

60 replies

CC#

•Created by Leandro on 2/9/2025 in #help

refactor database to stop using UNIQUEIDENTIFIER as PK

maybe there is some obscure pooling settings in hangfire or something..

60 replies

CC#

•Created by Leandro on 2/9/2025 in #help

refactor database to stop using UNIQUEIDENTIFIER as PK

but still it completely disgraced my database xD

60 replies

CC#

•Created by Leandro on 2/9/2025 in #help

refactor database to stop using UNIQUEIDENTIFIER as PK

a couple, 5 or 6 . They don't run everytime

60 replies

CC#

•Created by Leandro on 2/9/2025 in #help

refactor database to stop using UNIQUEIDENTIFIER as PK

60 replies

CC#

•Created by Leandro on 2/9/2025 in #help

refactor database to stop using UNIQUEIDENTIFIER as PK

I was thinking a out lambda and event bridges? But I will check this for sure

60 replies

CC#

•Created by Leandro on 2/9/2025 in #help

refactor database to stop using UNIQUEIDENTIFIER as PK

Well, I was already warned that this lib is harsh on database. Maybe some obscure configuration to make it less of a bottleneck.. Will have to study more

60 replies

CC#

•Created by Leandro on 2/9/2025 in #help

refactor database to stop using UNIQUEIDENTIFIER as PK

yeah, it was definately hangfire. I make like 15 queries to gather data to build a PDF report. Before it could take as long as 20secs. Now with Hangffire disabled, everything ran in less than 2 seconds.

60 replies

CC#

•Created by Leandro on 2/9/2025 in #help

refactor database to stop using UNIQUEIDENTIFIER as PK

SQL Profiler was very active before I disabled

60 replies

CC#

•Created by Leandro on 2/9/2025 in #help

refactor database to stop using UNIQUEIDENTIFIER as PK

I think Hangfire was degrading performance. After I disabled it, some queries are running faster now. Maybe I'll look for a different solution.

60 replies

CC#

•Created by Leandro on 2/9/2025 in #help

refactor database to stop using UNIQUEIDENTIFIER as PK

I dont think so, content column is a json string

60 replies

CC#

•Created by Leandro on 2/9/2025 in #help

refactor database to stop using UNIQUEIDENTIFIER as PK

sorry, I dont understand

60 replies

CC#

•Created by Leandro on 2/9/2025 in #help

refactor database to stop using UNIQUEIDENTIFIER as PK

these are other queries unrelated to the ones I posted here, but it's funny how one time they go fast and all of a sudden it starts to become slow

60 replies

CC#

•Created by Leandro on 2/9/2025 in #help

refactor database to stop using UNIQUEIDENTIFIER as PK

the sql performance seems to have degraded over time. One time when I refactored all the queries, it wasn't taking 3ms to run them all. Now the same batch takes more than 20secs to run. Maybe if I restart RDS time will go back to normal. Maybe the RDS instance is too small? This is driving me crazy with all sorts of problems in production. Any help would he heavily appreciated

60 replies

CC#

•Created by Leandro on 2/9/2025 in #help

refactor database to stop using UNIQUEIDENTIFIER as PK

except using Mapster to map the sql result to DTO and give it back to frontend.

60 replies

CC#

•Created by Leandro on 2/9/2025 in #help

refactor database to stop using UNIQUEIDENTIFIER as PK

and I'm not really doing anything fancy in C# to add such time

60 replies

CC#

•Created by Leandro on 2/9/2025 in #help

refactor database to stop using UNIQUEIDENTIFIER as PK

this is another query that I tried to optmize. In SSMS query runs in less than one second, but when called from frontend and everything else, takes more than 4segs

60 replies

CC#

•Created by Leandro on 2/9/2025 in #help

refactor database to stop using UNIQUEIDENTIFIER as PK

60 replies

CC#

•Created by Leandro on 2/9/2025 in #help

refactor database to stop using UNIQUEIDENTIFIER as PK

it seems to not have speed up anything

60 replies