VB.NET prevent "not responding"

Hi My Proposal is that : We will be focused on SQL performance tuning and we will try to make the minimum changes to the application. We will run the profiler to find the most “expensive” queries and we will try to improve them or improve the DB. Of course some queries may be changed, but it will be no need to open threads. Currently I am working at big financial organization in which I’am responsible for the MIS. I have designed and Developed the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2. The database is being administrated by me and is being updated daily from the core system via SSIS and a numerous of KPIS are being daily updated during the ETL and the size is apox. 4TB, i have 14 years of experience working with SQL. if you need to contact me please take into consideration my country’s time zone (GMT+2). The Cost is 15euros per hour Regards George Balaskas

Hi, Yes, this can be achieved by implementing threading. Threading will be implemented on form, not for each query. Another issue seems some locking in database while insert/update. This will be resolved by analyzing query application executing. I have 9 years experience in VB.NET, Win-Forms, ASP.NET/ MVC with Jquery/Ajax and for services using WCF/Rest WCF/Rest Web ApI and SQL Server 2008/R2/2012 for back-end. Thanks

Hello, I have more than 13 years of programming experience with Windows and Web Applications. I am well-versed with the Microsoft Technology. Proficient in programming with VB6, VB and C#.Net and different databases like SQL Server, Oracle, MySQL and MS-Access. Please check my tremendous 116 feedback to know more about my client's views for my work. Please also check my portfolio for some software designs for windows applications. I have vast experience in SQL driven application. Please initiate the discussion on freelancer or skype so we can move further for the work. Awaiting for your prompt response. Thanks, Dhirendra

Hi, I have gone through your descriptions,I am 5+ years experienced Visual Basic,VB.NET,ASP.NET,MS SQL,SQL,SQL Server(2005 to On wards) developer at CMMI-5 level company.I can do your job easily before your deadline . I can give you the proper steps which will be followed by the Software development stage. I am very much Interested to do your work,Please revert me if you have any concern.

Hi I am very interest to work on your project. It looks like you have execution time problem. I wonder is it executing similar queries? I can help you to increase respond time and I can check the source code and fix it. As a start step, I would like to see the problem maybe via teamviwer. Ready to start right now and hope to hear from you soon. thanks

Hi, I am an Expert web application developer having 7+ years of experience with ASP, ASP.NET, ASP.NET MVC3/4, VB.NET, C#.NET, VB, VBA, MS SQL Server, MYSQL, MS ACCESS, MS EXCEL, AJAX, JQuery, Crystal Reports, web & window based services. It is a general technique to place time consuming tasks in a separate thread to avoid application non responsive. However, regarding your question about placing each query in a thread would not be a proper solution. In my opinion, first to identify all those areas that could cause delay in response, try to make them as group then put in thread (if necessary). Thanks

Hi! I'm a SQL Server with 10+ years of experience, performance, security , developing and so on. Thanks in advance!

I can fix "not responding issue". ---------- - I have 97% project completion rate with 100% in time that shows my commitment -I have 32% 'Repeat hire rate that shows client confidence on me - I have more then 7 years of industry experience of software/web/database development with 4 years of computer science educational background and I am also Microsoft certified with following certifications MCSD: Web Applications MCSD: SharePoint Applications MS (Microsoft Specialist): Programming in HTML5 with JavaScript and CSS3 Specialist MCP (Microsoft Certified Professional) Please check my profile for details. Thanks

I am the Dot Net Professional Developer/ SQL Server developer. My professional experience includes extensive hands on expertise on Microsoft technologies.I understand how to build project that directly meet user requirements end to end, user friendly and affordable. I also understand the importance of building strong projects that stand up to the high performance and high volume environment.

Sir; My name is Ahmed Kindly accept my volunteering expert low bid high professionalism .NET and SQLServer service for 4 years, please be sure that this service is totally for volunteering purposes and to build my professional - high value reputation through your review and no money will be taken on your unsatisfied service provided by us desired to build excellent reputation upon professional service and high credibility that we deeply believe in Note: any money you will spend is only to assure seriousness, to cover expenses and as donations to keep our service continue for future employers Programming Hint: it might be because the application pool is highly accumulated so it need programming tweaking Sincerely yours

I'd like to fix your issues, 15+ Years expirience in the .Net and Sql Enviorement. I won't tell you 1000 word's to make you belive how good i am at programing software, i rather show you what i can in code... Life run's on code....

I have good knowlege & experiance in vb.net & sql server SQL Development ability to write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints ) Solid acquaintance with windows server, security delegation, SPNs, storage components. Documentation skills for processes and procedures ( creating KBs, runbooks, topology etc ) SQL Database Operational support to tech users Strong knowledge in database security, auditing.

Hi, Just had a read through your project, and I believe that this is something I can help you with. Firstly, what type of VB.NET application is it (Winforms or WPF) and what version of .NET? In .NET 4.5 you can use async await which was designed to solve this problem. If it is Winforms you may need to refactor your code to handle callbacks whenever the database needs to be hit. My bid is only a rough estimate, depending on the size of your project and how much code needs to be refactored the actual cost to fix this may be more or less. Would you be able to provide more information? Just some background information on myself: I am a Sydney-based senior software engineer with over 10 years of experience. I develop software in the Microsoft technology stack (.NET, WPF, WCF, SQL Server). I always deliver quality and robust code. Hope you are interested, look forward to hearing from you. Thanks Brian

I think that , the statement sql has been had problem .So if you need check , i will check for you.

You are having some optimization issues. Would need to look into the queries that you have created and the way the database is designed. Be assured you do not need to move back to VB6. You just need some fine tuning for your application. Threading should not be used as an alternative when your queries are taking time. They should be used only when asynchronous calls are required.