Find Jobs
Hire Freelancers

Calendar Spa

$1500-3000 USD

Closed
Posted over 9 years ago

$1500-3000 USD

Paid on delivery
We are a small business that created appointment scheduling software. It needs to be updated. 1. When I check my database that support my system, I found one of the major data table holds over 3.5 million records . I took a simple test to run a database query to this table and it takes about 12 seconds to get back the result. This data table is the source of all your reports/forms -- so you can imagine in daily use when everybody want to open a form all the queries are queued, it took even more time to response. 2. Some figures of my current system: it has 53 custom defined form/report (template) it defines 927 form fields it now holds 92687 saved forms/report in DB it now has 23596 cases (user case) We need to Backup and remove some old forms from the database -- purely to reduce that single large table (bottle-neck) -- if possible, we can develop some new module that reads the old forms Suggestions are welcome.
Project ID: 6824959

About the project

42 proposals
Remote project
Active 9 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
42 freelancers are bidding on average $2,421 USD for this job
User Avatar
Let's discuss over freelancer Personal Message Box for the proper estimation of cost and time. I am myself doing programming so you will directly work with one person and that's me. No mediators. No managers. No subcontractors. see my recent work for the technical expertise along with reviews & feedback on my profile page.
$2,319 USD in 30 days
5.0 (172 reviews)
9.3
9.3
User Avatar
Greetings! We are experienced in completing complex web development projects winning Excellent Feedback from our clients: https://www.freelancer.com/u/evsoftpk.html. The problem that you are facing with your appointment scheduling software usually occurs when the database is not completely optimized and the database tables take longer to respond. The problem further increases when the stored records run in millions. Our systems analyst will work with you to resolve the issue, with fair distribution of Tables and creating optimized performance of the entire database. Let us work together with faith, trust and integrity towards resolving / streamlining the issues in the software. Regards, Sam evsoftpk
$2,368 USD in 30 days
5.0 (236 reviews)
9.1
9.1
User Avatar
Dear Sir, I have read your Project Description & understand the initial high level details but do you have more detailed requirements, some reference/example website URL or can you drop me a message thru' Freelancer PMB to discuss requirements? Just so you know, our current bid is just a placeholder to submit the proposal & start our communication. Look forward to hearing from you. Regards, YK LEADconcept
$3,157 USD in 40 days
5.0 (100 reviews)
9.1
9.1
User Avatar
Thank you for looking at our bid. Hope we should plan set of tables (if possible) and backend to take these in to account. May be we should time query in a simulated (but resized) table before proposing model split. Please disregard my timeline for now, we can comeback with a proposal based on further details; Kindly visit our profile on Freelancer.com to know more about our past history. We look forward to your response. Best Regards
$1,947 USD in 45 days
4.9 (94 reviews)
8.2
8.2
User Avatar
Hi, I (Myself a senior PHP, ASP.NET programmer using C# and VB) have a team having experience of more than 10 years in developing web and mobile applications. I have a team of expert programmers who write robust and bug-free codes at the very first instance. After seeing our quality of work and the cooperation offered to you even after the work has been delivered to you, you’ll come to us again and again to avail our services. I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I can achieve the results that you are asking for within your timeframe and budget. I am confident I can exceed your expectations and I would love to work on your project. Thanks, Priyanka
$2,577 USD in 50 days
4.8 (56 reviews)
7.1
7.1
User Avatar
Hello. This looks like a challenging project. I like it :) Please tell me this: DB is Microsoft SQL or MySQL? People get confused. Do you need to have access to have access to historical records all the time? I don't know how your system works, but I imagine it as a booking spa sessions. Then if that's the case you can get ride of historical data by moving it to a secondary table once the date is in the past. You should only care about present and upcoming dates. That will reduce drastically the amount of data to check on each query as it's clearly two separated actions to book a new session and to get reports from historical data. So most probably your application will need a database refactoring. In order to better assess this project I'll need to get a database schema dump. Also seeing the application working will be useful to know the uses and don't imagine them ;) Finally I'll request access to the source code, but not right now, I need to check DB first. Thank you.
$3,333 USD in 30 days
5.0 (15 reviews)
6.3
6.3
User Avatar
Warm Regards, I am pleased to inform you that your PR matches our expertise who own all the right credentials to execute this job in a very proficient way with a proven track record of 100% Completion Rate and 100% On-time record which shows our dedication towards satisfactory work, I request you to please initiate the discussion so that I can reach you efficiently, I can schedule an in-person to have better understanding on every minute requirement, final quote and deadline. Ready to share Portfolio on demand.(Committed instant reply) | Regards :Mike Blane
$2,368 USD in 30 days
4.4 (67 reviews)
6.8
6.8
User Avatar
A proposal has not yet been provided
$2,500 USD in 30 days
5.0 (25 reviews)
5.3
5.3
User Avatar
Hello I'm experienced PHP/MySQL developer with 9+ years of developing web applications for my clients. I have some similar projects in my past I'm can to solve your project on your satisfaction. There is several solutions for your projects - we can create new table which will hold old records ( ie. by monthly or yearly basis ) - i can rewrite your code to optimize database ( and optimize database itself ) - i'll need then sample of your data row ( you can blank important fields ) those just some of possible solutions and ways how to do this I'm ready to start right away if you have some question for me please don't hesitate to contact me for further discussion Best regards Sven
$2,000 USD in 10 days
4.9 (43 reviews)
5.1
5.1
User Avatar
Hello I am a full-time freelancer who has rich experience and high skills in PHP / MySQL / Javascript / jQuery / HTML5 / CSS3 / Bootstrap / ,,,, programming. I am sure that i can complete your project successfully. No problem. I have many recipes to make simple and fast the browsing of the data in DB. Can we talk about your project detail ? I hope to keep long-term relationship with you. Best Regards.
$1,578 USD in 12 days
4.8 (22 reviews)
5.2
5.2
User Avatar
I am a highly experienced UK developer who has been working professionally as a software developer for 20 years. I have working daily in SQL for about the last 12 years. I regularly deal with large databases and work on performance improvements where slowdown issues occur. As well as increasing performance and removing bottlenecks in existing data/structures I also refactor and restructure databases to provide greater speed increases where this is appropriate. I have a couple of initial questions about your project: 1) Which db backed are you using, MSSQL, MySQL? 2) What is the overall size of the database? Tim.
$2,666 USD in 30 days
5.0 (1 review)
2.7
2.7
User Avatar
Hi, I already done wrok on many type caldnars for another client If you agee then I will send my calendar work screen shots. Weekly Timesheet, Daily Entry (Site diary) etc... I have 4+ year experience in web developement. If you want to more details read my profile. Thanks Raj
$2,500 USD in 30 days
5.0 (5 reviews)
2.7
2.7
User Avatar
Hi, 3.5 million rows of data can be huge and not too huge at the same time depending on how the queries are being fired and what indexes are being used. But anyways, I believe its always better to archive the data which is older than a year or so. This keeps the data to optimum level. We can set you up in different ways, one with a product + live data and one with product + archive data. Or we can lookup into the queries and the database and see if the data itself can be optimized Regards, Tarun
$2,000 USD in 16 days
5.0 (1 review)
2.1
2.1
User Avatar
I like the big data, I have many years of doing work with large data. your data needs to be normalized so that a more structured.
$2,500 USD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Project Owner, I am a professional programmer. In freelancer.com I am still learning to build trust with the project owner. I hope you will feel comfortable working together with me and satisfied with my work. Regards, Ryco
$1,666 USD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, i'm serious professional IT specialist, DB SQL Server and Oracle builder. I like your challenge. I have some ideas but i must study well your situation. I need a VPN for remote connection at your system and time for analysis. I can resolve your work but before i need all element. At this moment i dont know how many time i need. For this reasons my offer is indicative. Maybe your budget is sufficient maybe no. If you want open negotiation, i'm here. I'm sure we will have a good satisfaction in our collaboration. Thenk you. Best regards.
$2,333 USD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello I have come to know your project post regarding need of updation in your existing web application of Spa Calender Booking System. Major issue right now you have is system takes 12 seconds or more time to fetch data from database of 3.5 millions records. Well, I would like to share one my story of client. He has SQL Server Database of more than 10 millions of records and it took more than 20 seconds to fetch data. When it comes to me, I have gone through the database and its connection and dependency in brief and give the surprising solution with reducing data fetching time to 1-2 seconds. So, the same solution I can provide you for your system. Also, gone through other listed requirements and able to fulfill it. Let me know, if you have any queries regarding the job or my development work and experience. Looking for your response soon. Best Regards, Naresh Dabhi
$1,666 USD in 30 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Walnut, United States
0.0
0
Member since Dec 5, 2014

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.