Sarang Jahagirdar

I am Saran Jagirdar. I have 23 years IT experience. I have a earlier experience in dotnet and 9 year experience in SQL Server. I have experience in AWS and Docker for 1 year. And, uh, I'm currently working for Vivo Technology for last 14 years. So that's about me. I have 3 year on-site experience in USA for client Microsoft. I'm basically a Microsoft dot NET developer, and, uh, I have experience in the ASP dot NET Core ASP dot NET MVC ASP dot NET, and, uh, Web API and SQL Server and AWS and Docker.

If query is complex, then I will first see if I can simplify it using c t or temporary table or a table variable. And, uh, I will also see that indexes are properly utilizing where clause and join clause and group back clause. And I will check, uh, only those columns which are required are taken and not select star columns are taken. So these are the few things I will look into. I will also see that if it is a stored procedure, then set no count on is placed at the top of the statement. And, uh, the cursors are not used that also. I will check. So this way, I will check the how to optimize slow power running performance query.

Blazor gives a single page application uh, without, uh, using Angular and other things. So that is the advantage of Blazor. So you can write c sharp instead of JavaScript or client's head scripting, and it automatically convert it into JavaScript. So that is the benefit of Blazor and that is why we use Blazor. So, uh, programmer need not to be experienced in uh, development of the JavaScript. He can use his family language, c sharp. That is the advantage of Blazor.

So if we have to use CICD pipeline using AWS service, I am not very sure because, uh, I have not used CICD pipeline for AWS. I use basically CICD for, uh, in line on premise, uh, server. So for AWS server, it will be it should be similar and, uh, it requires 3 stages and same 3 stages and only instead of 1 p m I server, we have to give ADS server that will that will be used for deployment. So that is the, uh, what we will use AWS and c CRCW pipeline.

So to monitor target application on AWS, uh, I will, uh, use a performance log or log format, like application to log every, uh, important methods and that will log the time it will take to call along a particular method. So that's it, basically. And I will also see that the dotted application is using caching and other things, uh, like that, uh, before running the performance monitor on that. And, um, yeah, that is the basic thing I will do for the performance monitor of the AWS application.

So to join multiple tables, I will make sure that, uh, those tables have indexes on the on join clause because that will run the application faster. And, uh, if it is complex, I will try to use CTE or cell the table, variable, or temporary table. I will see that only those columns that are required are taken and not select star columns. And, uh, I will see if, uh, isolation level is not required too high, then I can use, uh, no lock on table so that will make it faster. So these are the things I will look for to run the query efficiently and with maximum speed.

To make it thread safe, I can put lock on instance, and that way, I will make it thread safe because without that, it is very difficult to make a thread safe instance. So you see, after the get, I will put a log statement, log instance, lock in bracket instance, and give a curly bracket and close it, uh, at the before the end of get statement. And, uh, I will say that if instance is equal to null, then instance is equal to new singleton and return instance. So that way, I will make it thread safe.

So we have to declare post ID as a integer and set value of ID so that we can execute this true statement. And I think that is the only or a way we can make this statement wrong and a thing more is required.

So I'm not sure on that. I have not face up, uh, problem. Your Docker configuration has minimized latency and other issues. So not sure on this question. So I will, you know, like to skip these questions, and I'm not sure about this question.

So, basically, to migrate to Blazer based on the application from on premise to AWS cloud, uh, the things we had to do is, basically, we had to run we had to run a laser assembly on AWS cloud and in .netcore, and that is the major thing we should do. I'm not very sure about the answer because I have not written a Blazor application.

I will do services with nothing but as your community service means, but nothing but ability to speak in English and, uh, communicate using English. So we can integrate Azure community service by, uh, putting the URL and, uh, making it read the application. So that way we can integrate Azure Community Service into blazer.data.