Đang Thực Hiện

SQL query optimisation in classic asp script

We have a classic asp script that creates an XML page.

The script calls 5 individual SQL queries of which 2 are repeated with slightly different values around 40 times.

Due to the database server being moved to another location and latency being an issue we need to optimise the queries so they are more efficient and the xml page is generated quicker.

We need someone to optimise the queries and modify the existing classic asp so that the xml page is written quickly.

A copy of existing code and xml output will be provided to awarded bidder.

**Please note** - the database the query calls is only accessible via our internal network so the work will need to be done offline using the existing code. We'll then be able to test the code internally.

Kỹ năng: ASP, SQL

Xem thêm: asp classic vbscript connect sql, malicious script classic asp, thumbnail script classic asp, import csv ms sql asp script, classic asp passing xml stored server sql, asp script export table sql dts, asp script export sql database, classic asp script timeout, asp script user registration classic net, search asp script sql 2000, asp classic save image sql, asp script mysql update query, sql 2000 asp script, free captcha script classic asp, rss asp script

Về Bên Thuê:
( 21 nhận xét ) Dianella, Australia

Mã Dự Án: #14814113

Đã trao cho:

vibhav107

Dear sir, I'm having an experience with both Classic ASP and SQL queries. As I can understand about your sql query optimization, and its take me max 2 days to complete. Thanks Relevant Skills and Experience Classic Thêm

$80 AUD trong 2 ngày
(4 Đánh Giá)
3.2

44 freelancer đang chào giá trung bình $157 cho công việc này

ITservice

Sql query optimization. Relevant Skills and Experience I have 15+ years of experience. Developed various projects in Classic ASP with MsSql database which includes simple dynamic page to complex ecommerce related web Thêm

$188 AUD trong 3 ngày
(207 Đánh Giá)
7.6
$180 AUD trong 3 ngày
(130 Đánh Giá)
6.7
gkalish

Having good experience in SQL Server and willing to start the work immediately Relevant Skills and Experience Having 10 + years experience in SQL Proposed Milestones $155 AUD - milestone1

$155 AUD trong 1 ngày
(204 Đánh Giá)
6.3
deepindersingh

Hello Sir, I have 10+ years of web development experience in ASP.NET MVC, ASP.NET Web forms(C#), Classic ASP, SQL Server, HTML5, CSS, jQuery, javascript, JSON and XML.I have handled similar projects. Please review m Thêm

$250 AUD trong 5 ngày
(29 Đánh Giá)
5.8
blackjk

Hello. I see 3 ways: 1) add new indexes 2)optimize asp code 3)optimize sql queries. Also may be hardware reason (slow disk system, etc) and software reason (other program use all resources). Relevant Skills and Expe Thêm

$140 AUD trong 3 ngày
(32 Đánh Giá)
5.3
IMExpertEngineer

Hi, I need to apply indexes on database and then query can perform better and I can do using team viewer if you like. Thanks

$250 AUD trong 3 ngày
(5 Đánh Giá)
4.4
hatimtaj

I should be able to do this. I have 15 years of classic ASP and SQL experience. If the db is only accessible through your internal network, would you be able to provide a copy with some test data? Relevant Skills and Thêm

$150 AUD trong 3 ngày
(10 Đánh Giá)
4.5
vinaysinghh

A proposal has not yet been provided

$110 AUD trong 1 ngày
(22 Đánh Giá)
4.3
mauricemarinus

Hi there. Send me the details I would like to see what I can do. Perhaps if your version of SQL server is latest enough we can generate the XMl on the server itself. Relevant Skills and Experience 17 years software de Thêm

$100 AUD trong 3 ngày
(4 Đánh Giá)
3.7
$155 AUD trong 3 ngày
(2 Đánh Giá)
3.8
yony82

Hi. I am a web developer with 8+ years of expreience with SQL. I have learned to work with advanced and complicated queries, profiling and indexing for performance optimization Relevant Skills and Experience Hi. I am Thêm

$70 AUD trong 1 ngày
(10 Đánh Giá)
3.4
$155 AUD trong 3 ngày
(2 Đánh Giá)
3.6
vickey181

I am having a good expertise in classic asp with xml as i have worked with many api providers with xml soap request response [url removed, login to view] i have good experience with database creating reports and xml. Relevant Skill Thêm

$222 AUD trong 5 ngày
(5 Đánh Giá)
4.0
intemo

I have long term skills for classic asp web application and MS SQL. I can done your project Relevant Skills and Experience classic asp, MS SQL Proposed Milestones $155 AUD - job is done

$155 AUD trong 3 ngày
(7 Đánh Giá)
2.9
polarjin2017

the database the query calls is only accessible via our internal network so the work will need to be done offline using the existing code. We'll then be able to test the code internally. I am from china as a specialis Thêm

$155 AUD trong 3 ngày
(3 Đánh Giá)
3.5
bhupen2606

Hi, SQL query tuning is my primary skill. i know various techniques to optimize slow running queries. i would need some details about your database. Let's have a quick chat. Relevant Skills and Experience SQL, Query o Thêm

$100 AUD trong 3 ngày
(8 Đánh Giá)
2.8
kashivw

Veteran (15+ years) database developer. Thousands of lines of SQL and procedural SQL code. Have done query optimization for several years. Excellent communication skills. Relevant Skills and Experience 15+ years SQL S Thêm

$155 AUD trong 3 ngày
(4 Đánh Giá)
2.4
$111 AUD trong 2 ngày
(2 Đánh Giá)
2.1
$135 AUD trong 3 ngày
(2 Đánh Giá)
1.7
forususa

Dear Employer , we are experts in Microsoft BI stack , SQL Server ,C# , ASP.Net . we work for Microsoft as consultants and this is first time we are entering into the freelancing world. we are good at data entry proje Thêm

$100 AUD trong 4 ngày
(3 Đánh Giá)
1.7