SQL query optimisation in classic asp script

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.

Vil du gerne tjene nogle penge?

Tildelt til:

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 Mere

$80 AUD in 2 dage

(3 bedømmelser)

3.0

45 freelancere byder i gennemsnit $159 for dette job

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 webMere

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 Mere

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 deMere

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 SkillMere

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 specialisMere

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 amMere

I can help you with this project. I am a full time programmer. I just wanted to have another job to gain more skills, learn from others and help others to solve their problems.
Relevant Skills and Experience
I use .NeMere

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 projeMere