Alex
Alex
PostsComments
CC#
Created by Alex on 5/31/2024 in #help
Performance Advice
My intuititon sent me directly to NamedPipes because previously I've needed to connect through the parent process to the child one, that could be running indefinitely and needed command inputs. It's not needed in this case since the child process will only be needed as long as the parent one exists.
19 replies
CC#
Created by Alex on 5/31/2024 in #help
Performance Advice
Actually it isn't, you were right on calling me out... Since I'll be starting the process myself I can just use a normal pipe
19 replies
CC#
Created by Alex on 5/31/2024 in #help
Performance Advice
Yes, I thought of using System.IO.Pipes.NamedPipeServerStream so I can define a name to the pipe and connect to it through the x64 application. Is that not the best approach?
19 replies
CC#
Created by Alex on 5/31/2024 in #help
Performance Advice
For sure, then I'll be setting up a NamedPipe for continuous IO
19 replies
CC#
Created by Alex on 5/31/2024 in #help
Performance Advice
this is still pretty vague
Yeah, unfortunately I have to keep it like this, but you're helping a lot even then ^^
19 replies
CC#
Created by Alex on 5/31/2024 in #help
Performance Advice
Either way, would the loop be the best option then?
19 replies
CC#
Created by Alex on 5/31/2024 in #help
Performance Advice
Thinking back it was pretty stupid
19 replies
CC#
Created by Alex on 5/31/2024 in #help
Performance Advice
Only for confirmation on my theory; There was something that supposedly needed to run every 250ms to ensure things were processed, but it didn't make sense to me and I questioned it; I looked into the code and changed some things in mine and now it only runs once
19 replies
CC#
Created by Alex on 5/31/2024 in #help
Performance Advice
Okay, I've just managed to reduce said resource usage to practically none
19 replies
CC#
Created by Alex on 5/31/2024 in #help
Performance Advice
Actually I just got an idea... I'll be back in a minute
19 replies
CC#
Created by Alex on 5/31/2024 in #help
Performance Advice
The dependency was made by someone a long time ago, and it's maintained by a few people on the development team. Unfortunately, the guy that initially made it did not document a very specific part of it and due to a few questionable choices it ends up taking up quite a bit of resources on the implementation which I'd like to avoid. I'm trying to keep the dependency usage to a minimum because of it.
19 replies
CC#
Created by Alex on 5/31/2024 in #help
Performance Advice
Note: Asking for an x64 build of the dependencies is not feasible, unfortunately. It would take many, many months due to this being something critical, and it would overload the already busy development and QA teams 😛
19 replies
CC#
Created by Alex on 4/9/2024 in #help
Adding program to Local Machine Registry
Nevermind, moved on to using the TaskSchedulerLibrary
2 replies
CC#
Created by Alex on 10/31/2023 in #help
✅ SQLConnection and queries to the database
Yep, thank you!
33 replies
CC#
Created by Alex on 10/31/2023 in #help
✅ SQLConnection and queries to the database
Yeah
33 replies
CC#
Created by Alex on 10/31/2023 in #help
✅ SQLConnection and queries to the database
It should be [Escola].[Alunos] right?
33 replies
CC#
Created by Alex on 10/31/2023 in #help
✅ SQLConnection and queries to the database
That's embarassing
33 replies
CC#
Created by Alex on 10/31/2023 in #help
✅ SQLConnection and queries to the database
God damnit. Thank you so much
33 replies
CC#
Created by Alex on 10/31/2023 in #help
✅ SQLConnection and queries to the database
When ... I create a table like this... I'm creating a table named "Escola.Alunos" right?
33 replies
CC#
Created by Alex on 10/31/2023 in #help
✅ SQLConnection and queries to the database
CREATE TABLE [Escola.Alunos] (
    NumeroInterno INT IDENTITY (1,1) NOT NULL,
    Nome VARCHAR(50) NOT NULL,
    Idade INT NOT NULL,
    Localidade VARCHAR(50) NOT NULL,

    PRIMARY KEY(NumeroInterno)
)
CREATE TABLE [Escola.Alunos] (
    NumeroInterno INT IDENTITY (1,1) NOT NULL,
    Nome VARCHAR(50) NOT NULL,
    Idade INT NOT NULL,
    Localidade VARCHAR(50) NOT NULL,

    PRIMARY KEY(NumeroInterno)
)
33 replies