Slow queriesemplois

...Database building and troubleshooting (SQL and No SQL) - Java 10+ years experience - Cloud and Local network troubleshooting experience The database results very slow in seek requests The SQL queries result in a hanging situation above 10000 indexed records. In the proposal we have to meet an amount of the time needed to complete the job ________________

...Optimiser les réglages Varnish - Optimiser les réglages CSF + Fail2ban - Mise à niveau PHP 7 - Analyse des logs et identification des problèmes (redirections infinies, slow queries, scripts trop gourmands) Facture obligatoire...

English version Hello I have an ecommerce with Magento, but the website is too slow at the first connection (more than 14 seconds, see attachment). However, I enabled cache modul, so then, the site will quite quickly (about 3 seconds per page), but it is also too long. I am looking for a provider able to display the home page in 3 seconds maximum

On veut développer une application qui gère les rencontres des tournois de Tennis d’une saison donnée. Chaque joueur a un nom et un sexe. Deux joueurs peuvent former une équipe. Un tournoi est identifié par son nom et se déroule dans un pays donné à une date prévue. À la fin d’un tournoi, un jou...

our admin becomes slow loading recently, long to like 10 minutes waiting. Not sure what is the reason, maybe some module or some weird code in prestashop causing it. [se connecter pour voir l'URL]

To be clear...I'm looking for asp.net EF queries. These could be Raw SQL queries, but NOT LINQtoSQL. Sorry, Freelancer won't let me updated the title of the project. I have several SQL Server tables from which I need to extract data AND perform calculations on that data. The queries will need to accept a date range and another geographic constraint

Make a simple website which extracts data from Excel sheet according to search. Basically there is a price list on excel sheet, user enters a word and clicks on search and the website displays the price. Two line on the website, one with search and other with price.

...Senior level DBA to help with database indexing and speeding up our php queries and Lookup table creation. We are getting page timeouts and slow query responses for a very Active site. You'll work with my Front and Backend developers to help speed up our pages and database queries. Full Time Freelancer wanted for ongoing work with a very Active website

...Woocommerce and the database is causing real issues. There are slow queries and the site causes high account executions. We are told the database is too large at 1.9 GB but the previous database was 30 GB. The site has a little over 26,000 products. We need someone to optimize our queries and database structure so that the site will speed up and remain

for dreamland

I have a Drupal 8.6x site on InMotion (not yet launched--still in progress). The speed of the site, especially for logged-in users, is terrible. While I'm a fairly experienced D7 site builder, D8 is throwing me for a loop and I need assistance optimizing this site. I'm looking for a diagnosis and recommendations for speeding the site up for administrators especially.

I am looking for a linux server expert to check and fix why the website in my server is suddenly slow, with 503 Error.

Tune/repair SQL database to optimize queries and reduce server CPU load New website using Word Press causing excessive load on CPU resources. Need help identifying and repairing slow queries causing increased resource consumption and the utilization of CPU

i need a very experienced MS access programmer developer t...able to manipulate my Access database to create custom reports, custom look up tables and custom queries to produce formatted custom print out reports all done in MS Access. Must be advanced Access user and be able to easily make custom tables and queries with resultant output for reports.

I need Mysql optimized currently it has Slow queries: 9019 and some other issues which require optimisation perhaps indexing and so on. Centos 7 x64 os on VPS

I need a DBA to help with database indexing and speeding up our php queries. We are getting page timeouts and slow query responses for a very Active site. You'll work with my Front and Backend developers to help speed up our pages and database queries.

Hi Slow Cheetah studio, I noticed your profile and would like to offer you my project. We can discuss any details over chat.

PLEASE IGNORE THE BUDGET AS WE NEED TO DISCUSS The speed of my web hosting is very slow for some reason, it is okay when I have a few people on the website like up to 10. When there is 25 - 35 people the website slows down and is too slow to use. SEE attached screenshot for TOP results in ssh. I believe it is a database issue as it is using 100%

Hello , I am looking for someone who can analyze plugin/ code / theme issue and improve load time . I really dont want below things 1) Using Caching Pluings 2) Scrap methods suggested by various test tools like gtmetrix , pingdom , pagespeed etc etc Anyone well confident and who really can improve speed by fixing issues with existing codes/ plugins or by rewriting plugins / code etc which ...

We want an experienced SQL analyst to write multiple queries to extract value from data generated by our users. Databases are under Google BigQuery. After querying data we´d like to see the results in any Visualization Data Tool.

...degrees) given a sequence of images. Period: Within 1 week Input: We will provide a sequence of images of a scene from the camera moving in the straight line manner (slow and steady) Output: We need the focal length (in pixels) and camera rotations (roll, pitch & yaw in degrees) using those sequence of images Note: 1. No usage of checkerboard

need to take care of slw website please advice about the way you will do it

Write SQL queries for ETL job.

i have some complex sql queries that i need help understanding

Need to set a page up and make it work better than now. Its very slow... [se connecter pour voir l'URL] Please make sure to scan page with google developer tool and send me a fixed price. Will not answer questions as i am not the expert. Site has elementor today and all errors will be shown in google or any other tools.

I need the developer to solve SQL queries which are near 4-5 hour total work. Basically, there is an accounting department and payroll flow and asset flow to solve some small queries.

I need three MySQL queries for the project. I will share the schema of the three tables on which i need queries on. Need an expert with table joining and IN, LIKE statements. I need them asap.

please see example slow loading image [se connecter pour voir l'URL]

I have a website and need some changes made, see attached list with website logon to view what needs to be done. * termdate field needs fixed - does not update termfield * Add - "are you sure " when you click the delete * change "subadmin" to only allow view only * add report for subadmins - add 30-60-90 over due report email to each subadmin for each location. * fix report pag...

I would like to extract json output into excel from an api endpoint . A parameter in the get is changed with values in a provided excel file. Here is an example [se connecter pour voir l'URL] q1 will be changed according to the provided list, all results are to be in one row of excel, for each parameter variable.

We have a brand new website [se connecter pour voir l'URL] but it is really slow. Who can speed it up under the 2 sec?

We need an expert for find the reason of slow server. We want a good tuning and get back good performance. We have some websites with wp on [se connecter pour voir l'URL] config is cpanel last version, csf, php-fpm , mysql , exim. thanks

...project will leverage AWS Lambda to produce and return proper Elasticsearch (6.5.x) DSL queries from data objects stored in DynamoDB. The developer will be expected to follow rules (that will be provided to the selected candidate) in order to build these queries. The developer must work in Node.js (8+) in AWS Lambda and be familiar with DynamoDB. Experience

Write executable SQL queries to answer these 2 questions. Should be easily completed by someone with SQL experience. Read attached word document. Deliverable will be the SQL queries.

Can someone make my Wordpress website fast? It looks like a plugin that has a conflict? Hopefully somebody can help me.

be able to retrieve search queries made on major search engines

I need someone to retrieve SEO data from search engine

Street Fighter 5 on PC is running slow and lagging. Need to fix this via teamviewer.

This is a pretty fast exercise for someone with experience, there are only 5 tables that need to be denormalized. Easy and quick money before Christmas! I need an expert data model engineer to take an existing physical data model documentation and derive new tables in a denormalized format. Please only apply if you have multiple proven experience working in such an exercise. No time waster.

I have a Joomla job site, and am now to busy to do the development myself, scheduled tasks ; (finish off this page , make theme and copy content [se connecter pour voir l'URL]) - create a support page (1st bid project remake [se connecter pour voir l'URL]) $bid - improve module positions in template - enhance template responsiveness and css - create mobile template - create new forms...

I need you to develop some software for me. I would like this software to be developed for Mac using SQL.(3 queries)

I need to have ms sql nested query stored procedures written to replace ms access nested queries

TTFB over 1 minute. Apache server, Ubuntu VPS from linode. Working fine during the last year and starting from last weekend website load super slow.

...to speech in Spanish “Luz, cámara, acción” - Play a wav file ([se connecter pour voir l'URL]) - When the text finish talking, turn on flash, record a slow motion movie for 5 seconds (at highest resolution possible for a iPhone 6) - Turn off flash - Automatically save video with format “YYYY-MM-DD HH:MM:SS” to Gallery - Move to

I have a Joomla job site, and am now to busy to do the development myself, scheduled tasks ; - create a blog page - create a support page (1st bid project remake [se connecter pour voir l'URL]) $bid - create new module positions in template - enhance template responsiveness and css - create mobile template bring other skills to the table ; server side security , mail server support, SEO ...

I am having a speed issue to access all the websites hosting under my Linode vps. (access through either domain name or IP, both are super slow). My IP is [se connecter pour voir l'URL] I have double checked that I have enough free memory (1.5G available), CPU is almost idle (0.3% in use.) and over 50% unused disk storage. I used to be able to load my website in

This task requires to apply the understanding and ability to use Relational DataBase Management Systems (RDBMS) as well as use SQL in the modelling of the physical ...DataBase Management Systems (RDBMS) as well as use SQL in the modelling of the physical world. Based on business scenarios required to design a database and provide related SQL queries.

URGENT - My main form is taking too long to load. Need someone to look at the code and fix the issue that is causing poor performance.

I have problems that slow down the speed of the site, especially the mobile version, please discover and fix it to appear on Google speed

Using MySQL #Consider a schema as follows: Supplier(SID,NAME,SUPPLIER_ZIP) Parts(PID,PNAME,PTYPE,SID) Sale(SHOPID,PID,SALES_DATE,QTY) Shop(SHOPID,SHOP_ZIP) Use VOLUME = SUM(QTY) #SUPPLIER with SID supplies this part. PTYPE can be Perishable or Imperishable. # there can be more than one SHOPID per SHOP_ZIP and more than one Supplier per Supplier_ZIP # more than one supplier can supply a PART ...