Find Jobs
Hire Freelancers

MYSQL DB Query Work Optimization $30 - $250 USD

$30-250 USD

Zaprt
Objavljeno pred več kot 8 leti

$30-250 USD

Plačilo ob dostavi
I have a large-db Joomla 3 site. In some cases the mysql database is very slow, for example, when displaying a list of articles (category list). I know this is a standing issue with Joomla and I know there are ways to adjust the database to work better or query very differently using different methods and relying more on the server. Your job is to adjust this and speed up the pages on the already-optimized website that have this issue. We can discuss further using the messaging system. We can discuss in further details through messaging syste
ID projekta: 9317712

Več o projektu

16 ponudb
Projekt na daljavo
Aktivno pred 8 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
16 freelancerjev je oddalo ponudbo s povprečno vrednostjo $181 USD za to delo
Avatar uporabnika
Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks
$237 USD v 10 dneh
4,8 (475 ocen)
8,2
8,2
Avatar uporabnika
Propunerea nu a fost încă furnizată
$155 USD v 0 dnevu
4,6 (178 ocen)
6,7
6,7
Avatar uporabnika
Dear sir. I am very interesting to bid on your project. I have enough skill-set for your project and do my best for it also. I can do it well more than you can guess, and I wish have a long-term relationship with you. Kind Regards.
$250 USD v 7 dneh
4,9 (71 ocen)
6,5
6,5
Avatar uporabnika
Hi, Hope you are doing well. I have gone through the requirements and found you are facing issues in SQL queries. I have worked on business intelligence reports where millions of records are fetched with high calculations within seconds. Yes, there is a way to design queries so it can't take more than 1 or 2 seconds with calculations. all depends of query optimazation. query optimazation can be done by using query optimisers, and some indexing in database tables to boost the performance. We are highly qualified and experienced team works on large Java based web applications using following technologies. Java, j2ee, spring, struts, jsp, jsf, ejb, hibernate, ibaitis, I but , camel, maven, gradle, ant, mysql, oracle, mongo, json, xml, HTML, CSS, bootstrap, angular js, jquery, JavaScript, hyperjaxb3, Jersey web services and spring rest web services. we have developed applications with following feature secure web SSO login user management with roles hierarchy business intelligence reports emailing feature live dashboards to show live business API integration Please let me know how may I help you awaiting positive response Regards Vishal
$222 USD v 5 dneh
4,9 (12 ocen)
6,0
6,0
Avatar uporabnika
A proposal has not yet been provided
$111 USD v 3 dneh
4,9 (47 ocen)
5,2
5,2
Avatar uporabnika
Thank you for posting a clear description of your requirements. It sounds like the category list and some other database areas need to be tuned. Typically this can be addressed with some strategic index tuning. There could also be some benefits in optimizing the queries as you mentioned. Optimization is an area of specialty for me. I recently tuned a large, 1 terabyte database for a manufacturing client in the UK. Report queries on their alarm data were taking more than twenty minutes to complete. I was able to bring each query to within five seconds. I invite you to read the client feedback on my profile regarding past optimization projects. My bid includes the following services - Profile your system to locate the bottlenecks - Create a plan to optimize the system and discuss with you - Implement the changes - Provide after-project support to ensure you are satisfied with the results For each project I create a VMWare Virtual Machine in my lab that replicates the software and tools in your environment. This allows me to fully analyze and optimize your database on a copy without impacting your production site. I am located in Alberta, Canada. I am a native English speaking freelancer and can bring creativity, dedication, and depth of experience in the computing industry to your project. This project sounds like a great opportunity, thank you for your consideration. Best regards, Jay
$148 USD v 5 dneh
5,0 (18 ocen)
5,3
5,3
Avatar uporabnika
Hi I'm a french web developer used to create and update complex web sites, some are tailor made some are made using CMS or engines (WordPress, Joomla Smarty, DWOO, CMS made Simple...). I'm very good using SQL as my first job was database adminstration (mostly for DB2 and SQL server databases). I'm good at creating or optimazing SQL queries on many DBs (MySQL, PostgreSQL, Oracle, SQL Server, Firebird...). If you choose me, I'll first make an analysis to see why the queries are low and then correct then. Best regards Alex
$180 USD v 3 dneh
5,0 (17 ocen)
4,5
4,5
Avatar uporabnika
Hello! I have necessary skills and I'll be glad to perform this task. Please describe more details and requirements.
$180 USD v 3 dneh
5,0 (2 ocen)
1,8
1,8
Avatar uporabnika
I can do that for you. If you have got a vps or dedicated server we can optimize your database to perform optimally.
$30 USD v 2 dneh
5,0 (1 ocena)
1,9
1,9
Avatar uporabnika
Hello, I'm a data scientist and SQL query optimization expert. I'm interested in helping speed up your site. My background is in computer science, math, and statistics. Looking forward to hear from you! Christian
$250 USD v 3 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
I have a lot of experience with mysql, actually in my job I have optimized many tables and view which have some problems about displays's time
$155 USD v 3 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
A proposal has not yet been provided
$177 USD v 3 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
A proposal has not yet been provided
$155 USD v 10 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
I have a seven year professional mysql dba experience. I work with mysql query optimization and mysql performance issues on regular basis.
$155 USD v 3 dneh
0,0 (0 ocen)
0,0
0,0

O stranki

Zastava UNITED STATES
DOBBS FERRY, United States
5,0
493
Plačilna metoda je verificirana
Član(ica) od feb. 4, 2009

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.