Find Jobs
Hire Freelancers

Access Database / Query optimization / ASP Website

$10-30 USD

In Progress
Posted about 10 years ago

$10-30 USD

Paid on delivery
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
Project ID: 5568247

About the project

15 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
15 freelancers are bidding on average $26 USD for this job
User Avatar
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 websites. I can see there queries written, it could be combined, so process time will automatically get reduced. I will help you. Look forward to hear from you. Regards
$33 USD in 1 day
4.7 (156 reviews)
7.5
7.5
User Avatar
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 you the mistake and make the recommendation to speed up the query. Bests, Larry
$84 USD in 1 day
4.9 (35 reviews)
5.7
5.7
User Avatar
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 portfolio, there is some samples of databases modeling and database assignments. I've checked your requirement I can do this job in the deadline without a problem, because I've done many projects like this. Please send me all other details if you have about your database, so we can start asap. I'm available, and can start immediately. Looking forward to working with you. Thank you for your consideration. Regards
$30 USD in 1 day
4.6 (33 reviews)
5.4
5.4
User Avatar
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 optimized. First tip . The record set once open is not closed. second tip : The sql queries written will consume more time, we can use small queries that can do the work Thanks
$30 USD in 0 day
5.0 (16 reviews)
4.1
4.1
User Avatar
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 Company. I will complete this project within time limit and with accuracy. I will be available on skype. Thanks and regards
$25 USD in 0 day
5.0 (9 reviews)
3.6
3.6
User Avatar
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 in 1 day
5.0 (1 review)
0.6
0.6
User Avatar
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 database? Thanks.
$25 USD in 1 day
4.4 (1 review)
0.4
0.4
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 table on the columns used in the Where clause Are you querying again for the second open? can you not reuse the record-set created in the first one? Do you keep adding and deleting records from this database? if so do a compact database and this will improve the performance to some extent
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 your satisfied, then pay to me. otherwise no need to pay. [Contact details removed by Freelancer.com Administrators for breaching the site Terms and Conditions] I\'ll provide long term support and ready to work for low-cost. Thanks
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 order to optimize your queries you need to make sure that you place indexes on columns that are frequently used. As you can see I have some experience with this type of problem, but you ultimately need to move to SQL Express at a minimum. When using SQL Express you can connect using SQL Management Studio and run the query analysis tool. This will pin point bottle necks. Also, depending upon the queries that you have written you made need to use NOT EXISTS to speed up querying. I look forward to helping you further if I already haven't problem you with an answer. Check out my profile. Thank you, John
$33 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of PORTUGAL
Maia - S. Pedro de Avioso, Portugal
4.7
34
Member since Jul 15, 2004

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.