Terminé

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.

Compétences : ASP, SQL

en voir plus : 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

Concernant l'employeur :
( 22 commentaires ) Dianella, Australia

Nº du projet : #14814113

Décerné à:

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 Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% AUD en 2 jours
(7 Commentaires)
0.0

41 freelance font une offre moyenne de $160 pour ce travail

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(5 Commentaires)
0.0
nuclearsilomanvw

I will optimize what you need. Simple. If possible, I would like to get a copy of both the Classic ASP page and DB. This way I can create a baseline score in dev and measure improvements. Relevant Skills and Expe Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(0 Commentaires)
0.0
Udnalluri

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(0 Commentaires)
0.0
arstegsolutions

Hello, I am writing to you on the behalf of ARSTEG Solutions that we have developed many Web and Desktop applications. I would also like to mention that I have a team of experts working over here. Relevant Skills and Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(1 Évaluation)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(3 Commentaires)
0.0
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(6 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(0 Commentaires)
0.0
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(204 Commentaires)
0.0
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(32 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(150 Commentaires)
0.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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(18 Commentaires)
0.0
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(19 Commentaires)
0.0
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 4 jours
(3 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(2 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 5 jours
(0 Commentaires)
0.0
Bipin1Mishra

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(0 Commentaires)
0.0
rjjurcisin

I am an experienced professional, I try to return to the free activity. Habilidades y experiencia relevante html, asp, php, mysql, oracle, db2, javascript, cobol, c++ etc Htos propuestos $100 AUD - Init Project $100 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 10 jours
(0 Commentaires)
0.0
singhsuindia

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(3 Commentaires)
0.0