Building search queries sql jobs
Need to convert splunk queries to logstash
Hi i need you to connect and write 9 sql queries asap using SQL server management tool. thanks a
...hosting with 8GB RAM. Issue to be rectified is once there are more calls continuously mysql is not returning/responding which is delaying the queries and very slow responses. There are API calls like 300-500 queries per every 10 seconds,have to fix this and response should be very quick in milliseconds,sometimes its slow and sometimes its fast,when there
...hosting with 8GB RAM. Issue to be rectified is once there are more calls continuously mysql is not returning/responding which is delaying the queries and very slow responses. There are API calls like 300-500 queries per every 10 seconds,have to fix this and response should be very quick in milliseconds,sometimes its slow and sometimes its fast,when there
optimize your PHP script and MySQL queries to reduce the PHP script execution time Website using Magento Ver 2.2 Now the server default php version is PHP 7.1. System PHP-FPM service and PHP-FPM service for the domain are turned off.
I have started a personalised products business & need a website to sell & market my products.
We have a site where the index page loads very slowly due to poorly written queries - here is an overview of its issues. Need someone who can write queries with joins and understands what an index is etc. Here are the issues and suggested corrections: Too many sorts are causing temporary tables. Consider increasing sort_buffer_size and/or read_rnd_buffer_size
We have built a system with WordPress, and are using the Quick Chat plugin (...chat system, it begins to slow down, until the site becomes unresponsive. The hosting company have said it is due to most of the load and slowness coming from inefficient sql queries. It is being hosted on a dedicated VPS. We are looking for someone to resolve the issue.
...the database in the new environment and learned that it broke most of the reporting modules. Why we are looking to migrate is to improve client search times. It appears that when performing a search, the search is indexing the entire database before reporting any information. It is not a feature that was present in the previous version of our server and
Write queries to get the required data from mongoDB. Details attached. [login to view URL]
Require resource to build Hierarchical Transact-SQL Queries Table 1 Geoboundary: Name (city, state, sales territory) Table 2 GeoboundaryType: Name (categorises geoboundary state, city etc) Table 3 GeoboundaryAssociation: FromGeoboundary - ToGeoboundary Table 4 GeoboundaryAssociationType (describes association- city to state) Table3 contains
I am looking for an elasticserch expert who can tune my elasticsearch queries and give recommendations on reducing the cpu and memory usage
Hi I am looking for an SQL expert to write 10 SQL queries We have to agree on a specific date and time, log in at the same time. i will give you access, and work together. LEVEL REQUIRED : EXPERT ! Thanks A.
i want to write 6 simple sql queries see the [login to view URL]
Running a 2003 access database in 2013 64bit server, need to migrate without breaking functionality. Also, need a special report query, that will utilize several tables, and a unique Identifier of the Birth month, vs. specific birth date on customer record.
Write queries to get the required data from mongoDB. Details attached.
I need a PostreSQL 9.6 syntax expert that can produce simple to medium complexity queries. I'll provide DB access and specifications to what fields of which tables are needed to be queried
...fields from the form will use multiple REST queries to web-services like [login to view URL] (requires sign-up and setting the account from scratch). The REST queries should go deep into service to fetch the historical data. Having experience building stock market/trading/brokerage website building will be a great plus. The initial work is very
Hi, mongoDB ----> PostgreSQL I hav...-Write query codes for insert into PostgreSQL tables from other PostgreSQL tables -There are 7-9 query codes for insert No need to setup anything on the server, just need the SQL files, I will set them up on the server. This is an easy, but urgent project, please correctly specify the turnaround time and cost.
I have a data base manged by a system, I want to create some queries to get information from differents tables, in the same queries do some operations and IFs conditions, then download the data in excel, and create a dashboard to manage a special replenishment of requirements as a Distribution Center.
...must be able to be used to: - Manage the units, add new units, change configuration settings etc - Store the records from the Units in tables so that the - Run automated queries and send messages to customers when readings are recorded outside paramaters - Provide a customer access (web and app) for customers to see their units, change the nick name
...must be able to be used to: - Manage the units, add new units, change configuration settings etc - Store the records from the Units in tables so that the - Run automated queries and send messages to customers when readings are recorded outside paramaters - Provide a customer access (web and app) for customers to see their units, change the nick name
Looking for someone to help me with R-Programming! Please make sure you know what I am talking about before bidding.
We are looking for an SQL Expert to both analyse and optimise our database and code to fix a recurring deadlock and any slow queries. Here is a sample of the deadlock error. Order saving error: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: UPDATE `catalog_product_entity`
We are building a generic management information system, the platforms used are Microsoft SQL Server database, HTML 5, JavaScript, PHP, leaflet and D3. We have the general website structure and Database and need an applications development programmer to; • Build a login form linked to the database • build web forms using bootstrap for 3 views/tables
I need help with some api requests POST GET. Documentation included but somewhat vague. Having a hard time figuring out some errors. Need someone to figure it out.
I need optimize Database because is generating the slow MySQL queries and my website goind down for heavy file [login to view URL] My website is developed with wordpress/woocommerce with template Flatsome My hosting is siteground and below you can see the message about last Technical Support -------------------------- The previous error was caused by
Language known- hindi/English Ability to handle clients effectively
I need 4 query tables created from the uploaded gdb. The queries are: 1. List the players based on the number of home runs hit in their rookie seasons (from high to low). [login to view URL] the players by the number of seasons played (high to low). (Do not double-count in cases in which a player switched teams mid-season; i.e., 1987, which Sammy Sosa split between
We upgraded mysql to 5.7 and we are getting a few SQL call errors in our PHP script. Here is an example of one of the errors which we need fixed. we expect there to be 5 or so that need fixing, We have traced it back to this "In mysql 5.7 it is required to have the order by fields to be present in the select statement when using DISTINCT" Expression
Make a script that makes a few queries to current mysql database table, according to some simple conditions and update the results in that same table. These queries must be made for each record in the table, the table has many records, so it is important to use an appropriate programming language to speed up the queries. Maybe it would be convenient
A simple project where sql file is given for creating tables and data . using the sql file we have to write queries for the given questions.
Discuss SharePoint Online Migration & Office 365 queries - We can have discussion first then we can go ahead from there!
We have 43 queries for MySQL writed for Voku controller (PHP) that we need to migrate to MySQL controller. See the queries in the attached file.
I need a logo designed.
Hi everyone, I need help with Microsoft Access. Anyone who has experiences in Queries and Form, please help me out thank you
... Project Overview: 1x Search Box - MySQL DB Lookup 2x Registration From Wizards - [login to view URL] 2x Well coded registration forms required using our existing material bootstrap php template: [login to view URL] Excellent SQL skills required as you will
Load goes through the rough and website turns very slow it seems to be caching things, but disabling nitropack doesn't work I need you to find out what's causing it and fix it I'm hosted on AWS You need to be experienced in opencart to do the job
...found a script online that i require to be modified. The script can be found here: [login to view URL] The script listens for dns queries on a server and responds with the same IP address for all requests. Currently this is not working for me , as when i use the dig tool on linux the IP address i request does
Looking for skilled Microsoft Access Developer to create forms, queries, reports and tables. I will share complete details to shortlisted candidates. I need a smart developer for 2 projects. Another project is related to Tableau. So If you know Tableau that would be a plus point. Limited budget. Thank You
You are to write SQL queries for several questions and receive the required output.
Hi, My project is based on php MVC, the script was working in previous hosting but now when i moved to php 7.x hosting it's stop working, i know it's due to mysql to mysqli problem. i need quick fix. Thank
Hey guys, This is reasonably simple job. I will create a Digital Ocean VPS to your requirements. I then need you to: 1. Setup the web server 2. Create a small MySQL database 3. Create a single webpage, which will be a table displaying data from the MySQL database 4. Create a dropdown combo box, which changes the data that is queried from the database (and therefore changes what is displayed in th...
We are a booking site. Cities that have huge listings are not opening and throwing back error. We want to optimize the query to not search for as many results at one time or optimize the database queries to run in a different way for our site.
We need a python script that queries mongoDB for jobs (unique id, execution date) and then parses LaTex template and executes db queries based on special keywords embedded in LaTex (address, float values, currency based floats). It then generates a pdf from the processed LaTex file and stores it on filesystem with unique key and stores the key in the
I need a 1 page web app that accepts 3 inputs and returns data based on queries against neo4j and hyperledger. Results are separate, would be displayed separately, and don't need to be merged.
I have a wordpress directory website. I need businesses to add their own price lists and business team. I have a plugin called WpDataTables. I have managed to make all of the businesses submit their price list to the same table, with their business ID. But I want business pages to pull the correct row's from this table and display to visitors on correct business pages. I am looking for someon...
Add new search queries to very big database (Symfony, Elastic Search, Python) Looking for an experienced backend developer for a continous project. You will work directly with the CEO of a young trading and data analytics company. The project consists of developing search queries for a big data-set of 60 million factory records and adding order tools
