Σε Εξέλιξη

create MySQL queries for speed improvement

I've got a backend where I have 100s of users, who are actively using a system. This system uses quota and each user has a quota e.g. 500 /month or 2000/year.

Whenever a user subscribes to our service his period start, so each user has a different start date for a period.

We maintain usage in a usage table, but this is a table that's not aggregated.

A couple of times an hour we run queries to determine if a user went over his quota or not. Due to the amount of users this script takes quite a bit of time and this hogs the mysql server.

We need someone with expert mysql skills to come up with a better way of doing this.

UPDATE - I found the cause of the problem - it was not related to this description, but to another query in the script, which took 28seconds to complete. After adding an index to a table that problem was fixed.

The new requirement for this project is therefore to do a general analysis/improvement on my mysql setup. It now runs well again, but I want to make sure we make any improvements that can be made. SO if you have generic mysql performance tuning experience I invite you to bid.

Δεξιότητες: MySQL

Δείτε περισσότερα: speed date script, php mysql create csv file, write queries mysql, php mysql create form, mysql create table longtext, mysql create user python, mysql create lookup table, mysql create user database, mysql create table csv file, mysql create email collection database, mysql create

Σχετικά με τον Εργοδότη:
( 35 αξιολογήσεις ) eindhoven, Netherlands

ID Εργασίας: #8596601

Ανατέθηκε στον/στην:

Walrusyn

Hi, I'm a Linux sysadmin with 14 years of experience managing LAMP servers and would love to help you with this problem. According to my experience, I'd say that there are some parameters on MySQL that need to be Περισσότερα

$30 USD σε 2 μέρες
(0 Αξιολογήσεις)
0.0

22 freelancers κάνουν προσφορές με μέσο όρο $55 γι' αυτή τη δουλειά

coolguyinus2004

Expert here can help you on this. so let me know from you. PHP/MYSQL programmer here. can finish it today itself.

$157 USD σε 1 μέρα
(187 Αξιολογήσεις)
7.1
dagdya99

Hi, I'm interested to work on your project. Please let me know if you require any detailed information. Waiting for your reply Thanks Dev

$54 USD σε 1 μέρα
(110 Αξιολογήσεις)
6.5
techmartsol

Hello, We have gone through the scope of work and would be happy to provide complete solution on this and future support also if required. Scope of work includes - - Optimizing MySql Query for speedy result L Περισσότερα

$100 USD σε 1 μέρα
(43 Αξιολογήσεις)
6.0
avinashjain09

Hello, I have read your requirements, please provide more details about the work, so I can estimate exact cost and time. Please provide some sample/reference link. Can we have more discussion. I have 4 years of experi Περισσότερα

$60 USD σε 1 μέρα
(47 Αξιολογήσεις)
5.3
sljukic

Hi, I can help you optimize your system. I've got 15+ years of experience in IT development, of which 10+years in web development using PHP/HTML/Javascript/AJAX/mySQL technologies. I worked in a bank for 10 ye Περισσότερα

$54 USD σε 3 μέρες
(3 Αξιολογήσεις)
4.5
pakulin

What kind of queries do you use? Do you use caching for query results?

$27 USD σε 1 μέρα
(3 Αξιολογήσεις)
4.5
vermagarima

hello dear sir i m good with mysql u can chk my profile i will do ur work on time thanks sir ================================================================================================================== Περισσότερα

$35 USD σε 1 μέρα
(3 Αξιολογήσεις)
3.5
vinaysinghh

I am mysql DBA having more then 5 yrs of experience

$30 USD σε 1 μέρα
(4 Αξιολογήσεις)
3.7
AccuPro

Hello, Your system should be built in such a way that you should not need to check couple times every hour, only when the user accesses your system. Best regards, AccuPro.

$50 USD σε 2 μέρες
(6 Αξιολογήσεις)
3.4
adityasinghal

we are working in php development since 2010 and having skills to optimize your queries for faster execution.

$45 USD σε 1 μέρα
(2 Αξιολογήσεις)
2.8
umarbsse

Hi.I am a Software Engineer and programmer. I have about 2 years of programming experience and developed 52 project .Project are both web based and desktop based application. I am ready to start your project right now. Περισσότερα

$50 USD σε 1 μέρα
(3 Αξιολογήσεις)
3.1
zkutch

Hello. I had worked in your project some times ago. I need more details to set real time and price - for example: where is stored users period? Regards. ----------------------------------------------------------- Περισσότερα

$100 USD σε 2 μέρες
(1 Αξιολόγηση)
1.4
AliSafder

I have over 8 years of experience in Databases like Sql Server, Oracle, Microsoft Access and MySQL, Programming languages like MVC, .Net technologies(Asp.Net, Vb.Net / C# ) ,PHP, WordPress, ASP CLASSIC etc. Scri Περισσότερα

$35 USD σε 3 μέρες
(3 Αξιολογήσεις)
1.4
rkthearchitect

About ME: ------------- Solution Architect having 11 years of Java/JEE development experience in all phases of SDLC - analysis, proof of concept, prototype, design, development, testing, implementation, post impleme Περισσότερα

$35 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0
MoohHHooM

A proposal has not yet been provided

$50 USD σε 0 μέρες
(0 Αξιολογήσεις)
0.0
mahendrasharma56

Hello, I have go through with requirement and make understating with requirement. i have more than 8 year experience in php,html,mysql and i can help you for sure I have good knowledge for making website with Περισσότερα

$35 USD σε 0 μέρες
(0 Αξιολογήσεις)
0.0
pastmaster2

I have done 4 types of projects like this before. i.e., I had created subscription for certain users. I have an innovative thinking of creating websites and i will give u a perspective design for your need And i am Περισσότερα

$30 USD σε 2 μέρες
(0 Αξιολογήσεις)
0.0
kundanverma89

Hello Dear Sir/Madam, We are having a Company of 25 members and we are new to freelancer and we are here to get big projects as per requirement of client and we have the ability to work anything on our skills such Περισσότερα

$55 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0
rkinfotekh

CRM Work [url removed, login to view] We are professional Web Developer, Mobile application, PHP, Graphic Design and IT development company R K Infotech. We have experience developer teams. Please, visit our freelancer po Περισσότερα

$50 USD σε 2 μέρες
(0 Αξιολογήσεις)
0.0
Bhanwarsa

You can use time difference and can check this by an ajax request( every x seconds) I have used similar solution for my notification system at [ [url removed, login to view]] I believe I can help you with this. JS + Script = A Περισσότερα

$35 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0