Find Jobs
Hire Freelancers

C# Code Optimization

$10-30 USD

Terminado
Publicado hace alrededor de 7 años

$10-30 USD

Pagado a la entrega
I have a C# Console App that Queries SQL Server to get a list of id's to process. Then based off the ID will determine which API call to make. The results returned from the API are then stored in a DataTable until the process is complete. Then using a SQL Table Variable and SQL Stored Procedure the DataTable results are dumped into the source SQL Server Table. My syntax works, but it is SLOW! I have read that DataTable's are resource hogs and that could be the slowdown, but need someone more advanced to examine. The things I would like the updated code to do: 1) Minimize strain on SQL Server 2) Speed up the process 3) In the catch block - (somehow save the data so we are not starting back at square 1 when the procedure restarts) ....My thoughts are to 1)Run the Stored Procedure to update the SQL Server Table with the current contents of the DataTable 2) Write the results to a .csv and re-load once the process begins again *Not sure which one would be the fastest and less resource intensive, my opinion is the 1st* This project should be for SQL Server 2008 R2 and .NET Framework 4.6.1
ID del proyecto: 12836759

Información sobre el proyecto

28 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hi sir I am Hasan Jack and I have have been doing C# development since last 5 years and because of my relevant skills and experience I really find myself best fit for this job. Looking forward to hear from you. Regards, Hasan Jack
$30 USD en 1 día
4,4 (4 comentarios)
3,8
3,8
28 freelancers están ofertando un promedio de $51 USD por este trabajo
Avatar del usuario
Hello, I can understand the problem.. Can you share the current execution time .. how much time you are expected.. Thanks for your reply. Regards, Sheik
$50 USD en 1 día
5,0 (29 comentarios)
4,7
4,7
Avatar del usuario
I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations.I can complete your project on time and within your budget.I can assure you that if you work with me once, you will always work with me for these kind of projects.
$30 USD en 3 días
5,0 (12 comentarios)
4,5
4,5
Avatar del usuario
A proposal has not yet been provided
$61 USD en 2 días
5,0 (9 comentarios)
4,3
4,3
Avatar del usuario
Hello, I hope you doing very well! I have gone through the description and would like to provide a quality solution using 5+ years of professional experience in required skills. (.NET/ASP.NET - MVC, EF, SQL, C#). Awaiting for your positive response so we can have final talk and start project immediately :)
$25 USD en 1 día
5,0 (11 comentarios)
4,0
4,0
Avatar del usuario
Hello There, I am a Software Develper with more than 9 years of experience in .NET and SQL Server related projects. Have you tried the SQL Bulk copy option? SP option would be ideal. would like to analyze the code further. Kind Regards, Mafaz
$25 USD en 1 día
5,0 (9 comentarios)
4,1
4,1
Avatar del usuario
Hello! I would like to help you with your project, but before that, I need to know more details. Please chat with me before accepting my offer. Thank you very much
$40 USD en 2 días
5,0 (18 comentarios)
3,8
3,8
Avatar del usuario
Do you know SQL indexing? You need this to improve speed of SQL queries. I a not sure at the moment so I will have to check but it seems it would be mich faster if we Will integrate indexing. Now I would request you to share me the database and aource code so that I can investigate on it.
$55 USD en 3 días
5,0 (7 comentarios)
3,5
3,5
Avatar del usuario
I am Professional C#, ASP.NET, MVC, WebApi SQL & EntityFramework expert at your service to provide you the best quality work on time and within budget. I am committed for professional ethics and customer satisfaction. Available on live chat 24/7. So start conversation on freelancer to discuss about the project. After discussion we'll decide our timeline & budget for this project. I can start right now. So lets get started Cheers! With Warm Regards, Gurudev kumar Project Manager & Sr. Developer WEBPHONIX
$25 USD en 1 día
5,0 (4 comentarios)
3,0
3,0
Avatar del usuario
Dear Employer, I have 11+ years of experience as full stake .net technology expert. I will be happy to take this challenge. I have couple of questions before I can start on this, 1. Did you do any analysis to find the bottleneck step. For example. what if API calls are eating 95% of time of over all process then even by optimizing rest of 5% will make no difference. 2. Are records has any relation in between or is there any constrain that IDs has to be processed in sequence only? I using multi-threading allowed in your application? 3. Have you done any bench marking to evaluate current performance and to-be performance? I mean, how you will evaluate delivery of this project? Please message me to discuss the requirements in details. Thanks Prasoon Kumar Gupta
$111 USD en 2 días
4,6 (2 comentarios)
2,6
2,6
Avatar del usuario
Please review my profile. I have 7.2 years experience in SQL. Please let me know more details and when we will start.
$24 USD en 1 día
5,0 (3 comentarios)
2,0
2,0
Avatar del usuario
Hello. I have worked on .NET platfom and with C# for years, both WinForms and WebForms application, and in all cases that was SQL Server on back end. Have experience with stored procedures. So I think I can analyze your code and make the optimization.
$35 USD en 3 días
5,0 (1 comentario)
1,1
1,1
Avatar del usuario
hello sir, i can solve your issue. i have done this type work .. and i am agree with you that ur 1st opinion is right to get it done faster. u can award me this project
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, Im a C# .NET developer with sql and general performance troubleshooting experience. Have you measured the response time per now? I could replicate the bottleneck if I got the solution file local, and then try to fix the issues. No cure - no pay.
$333 USD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi Greetings from Kautilya Rastogi As my skills and expertise is a perfect match with the requirement for this project so I would like to offer my candidacy for this job Regards
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Can insert data into temp table so that data is not lost for errors and while retrying you can give option to resume or start all over.
$50 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
i m very good back end developer, very good at sql server stored procedures ,functions and assemblies i have 4 year experience on c# and sql server
$30 USD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Madison, United States
4,9
32
Forma de pago verificada
Miembro desde feb 11, 2012

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.