Käynnissä

Access Database / Query optimization / ASP Website

I have a website that is hooked on an Access database with 3 tables, and the bigger has 8.000 records.

I need help in optimization on some queries that are overloading the site.

Please see the attached file to get the whole picture.

I will value anyone who gives some sort of tip in the first anwser, just to know that you know your biz.

The one who helps me here will have the chance to work on another similar project

Thanks

Taidot: ASP, Tietokannan hallinto, SQL

Näytä lisää: i need an access database, Query optimization, database optimization, c# with access database, c with access database, need access database help, optimization database, access sql query, sql query access, sql query help, sql query access database, database query project, asp project database, project sql query, sql database access database, sql query project, need asp website, access database sql, need access database, sort database sql

Tietoa työnantajasta:
( 34 arvostelua ) Maia - S. Pedro de Avioso, Portugal

Projektin tunnus: #5568247

15 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

ITservice

Hi, Hi, I have 5+ years of experience. Developed various projects in .Net with MsSql database. Infact, 90% of the projects done so far are in ASP, which includes simple dynamic page to complex ecommerce related w Lisää

$33 USD 1 päivässä
(156 arvostelua)
7.5
shmai

Hello, My name is Azam Ishaq (shmai). I run a small business in Faisalabad, PK called Shmai Inc., Specialising in bespoke back and front-end development. If you are interested in contracting for this project solution Lisää

$40 USD 2 päivässä
(176 arvostelua)
6.9
expertcoder1vw

There is 1 thing wrong with the way you are using the SQL for the Access database; and another thing that can be done to speed it up which I can tell you after seeing the database itself. If you select me I can show Lisää

$84 USD 1 päivässä
(35 arvostelua)
5.7
elboukharimu

Hi, I'm very interested helping you optimizing your database, I have more then 7 years of experience in SQL and database administration, modeling, optimizing and manipulating, please do not hesitate to check my portf Lisää

$30 USD 1 päivässä
(33 arvostelua)
5.4
VikashThecoder

Dear Sir. I have done lot of work on asp website and sql queries. I know where the load is high and can optimize it . kindly contact me and we can discuss the details thanks Update :- This can be easily Lisää

$30 USD 0 päivässä
(16 arvostelua)
4.1
catstevens2009

Bom dia senhor! como vai? I've browsed through the attached document and do have a couple of suggestions for #1 : 1st open: to get the family name into the <title>tag, below. Suggestion 1 : SQL="Select categoria Lisää

$25 USD 1 päivässä
(5 arvostelua)
3.4
sanjeevchopra12

Hi, I am an expert web developer. I have developed many websites for US, UK, France, Turkey, India and Australia. You can check my portfolio. I have also developed customized web based ERP for Indian Paper Trading Comp Lisää

$25 USD 0 päivässä
(9 arvostelua)
3.6
alstarkgroup

Hello! Ready to perform the task for minimal price and your positive feedback. To be honest your website can be attacked using sql injection. We also can improve some security settings for your solution.

$10 USD 1 päivässä
(1 arvostelu)
0.6
wotoinfo

Hello. Because queries are quite simple, it is possible to optimize performance tuning indexes only. I'm not a great expert in ASP, but I can tell you what you are missing indexes. Can you send me the structure of your Lisää

$25 USD 1 päivässä
(1 arvostelu)
0.4
paulbehr

I would replace all of your ad hoc queries with stored procedures. There are also several DB optimizations you can make to speed up the response time.

$30 USD 1 päivässä
(0 arvostelua)
0.0
nksundaram

A few things that you should be doing. Not sure how many column are in each table, but it would be better if you do the select with the required only columns. Do not use Select * Do you have indexes on these tabl Lisää

$25 USD 1 päivässä
(0 arvostelua)
0.0
Pokorny

I recommend you use LEFT JOIN in query. So, You will open only 1 recordset. Something like this: [login to view URL] You should also have to have indexes on [login to view URL] Lisää

$20 USD 0 päivässä
(0 arvostelua)
0.0
leenakjain

Hello , As I understand from the project details provided. There is a need to optimize the queries in asp/acess application. I went thru the pdf and as i understand, in this problem, you want to combine the queir Lisää

$25 USD 1 päivässä
(0 arvostelua)
0.0
krishivinfotech

Hi, This is shivakumar from krishiv infotech, Chennai-India. I have 6+ years for experience in asp.net and sql,mysql and ms-access database. i can fine-tune your site. please give me a change to prove my self. once yo Lisää

$10 USD 1 päivässä
(0 arvostelua)
0.0
anomanpk

Hi, I have read the description of your project and I would like to offer my services for this project. Why don't you use a joiner other than using 5 queries independently. Over the last 10 years, i have done m Lisää

$25 USD 1 päivässä
(0 arvostelua)
0.0
jssn

One thing that you need to do is always have a compact database routine running. The problem with Access is that it is not designed for high volumes of traffic. You should have went with SQL Express instead. In orde Lisää

$33 USD 1 päivässä
(0 arvostelua)
0.0