I gang

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

Evner: ASP, Database Administration, SQL

Se mere: 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

Om arbejdsgiveren:
( 34 bedømmelser ) Maia - S. Pedro de Avioso, Portugal

Projekt ID: #5568247

15 freelancere byder i gennemsnit $26 på dette job

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 Flere

$33 USD på 1 dag
(156 bedømmelser)
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 Flere

$40 USD in 2 dage
(176 bedømmelser)
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 Flere

$84 USD på 1 dag
(35 bedømmelser)
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 Flere

$30 USD på 1 dag
(33 bedømmelser)
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 Flere

$30 USD in 0 dage
(16 bedømmelser)
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 Flere

$25 USD på 1 dag
(5 bedømmelser)
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 Flere

$25 USD in 0 dage
(9 bedømmelser)
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 på 1 dag
(1 bedømmelse)
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 Flere

$25 USD på 1 dag
(1 bedømmelse)
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 på 1 dag
(0 bedømmelser)
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 Flere

$25 USD på 1 dag
(0 bedømmelser)
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] Flere

$20 USD in 0 dage
(0 bedømmelser)
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 Flere

$25 USD på 1 dag
(0 bedømmelser)
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 Flere

$10 USD på 1 dag
(0 bedømmelser)
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 Flere

$25 USD på 1 dag
(0 bedømmelser)
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 Flere

$33 USD på 1 dag
(0 bedømmelser)
0.0