Need a SQL server DB expert to optimize a stored procedure performace
Buget ₹1500-12500 INR
Job Description:
We have a stored procedure which is parsing a XML file and inserting and updating a table with more than 25 column which is already having more than 4 lakh record, Procedure is doing its job but it is taking approx. 900ms to just insert or update few records which is too much as large no of records need to be updated, we need an expert who can optimize this procedure to complete the task.
Acordat lui:
14 freelanceri licitează în medie 8899₹ pentru acest proiect
Hi I have 16 years of experience in sql server database development, mysql database development and postgresqldb development. Expert in sql performance tuning. Extensive etl on json and xml data structure. Programming Mai multe
I have read your requirement,I am 10 years experienced database optimizer, database developer, designer,administrator,Database Programmer in MS SQL Server , MySQL, I am specialize in database design,analysis, report Mai multe
Hi, I can help you I'm Database Administrator with 10+ years of experience in maintenance, security, backup, recovery, designing, coding, testing and supporting solutions , SAN Storage and Backup Solutions Thank you f Mai multe
Hello there, I am excited to apply for the job you have posted. With over ten years of experience in Oracle PLSQL, PostgreSQL, MySQL, MS SQL, and other NoSQL databases, I am confident that I have the necessary skills Mai multe
Hello, I have more than seven years of experience in the office and more than three years of freelance experience in the required area of work and would like to help you with this task. Thanks for posting in my area of Mai multe
Hello I am a professional python developer. My main specializations are automation, web scrapers and bots development. I have already developed over 200 scrapers. From the simplest (for example, a competitor's price Mai multe
Hi, could you share the stored procedure with me? So I could check first how to tune the SP. Please contact me via chat for the details. Thanks
I have 7 years of experience working in SaaS, I worked on databases like Oracle, Sql Server and Mysql. I believe in my experience to help you. let me look at your stored procedure to see what I can do.
i constantly look for new ways to improve myself and keep updated.i will be open minded when presenting the ideas by looking pros and cons. and i seek help when needed and do not hesitate to ask any questions
I have 14 years of experience in SQL and .net technologies. Experience in writing complex queries and expertise in optimization of query
Según mi experiencia y ser considerado para el proyecto te daré unos tips a mejorar 1-Simplifica el código: Revisa tus procedimientos almacenados para asegurarte de que estén lo más simples y directos posible. Reduci Mai multe