Optimize mysql count slow työt

...moitteettomasti päivityksen jälkeen (3 eri). Apache-järjestelmä on käytössä. ## Työnkuvaus: - Ubuntu version päivittäminen 20.04 LTS -> 22.04 LTS - Tarkista ja varmista, että nettisivuserveri toimii päivityksen jälkeen: - PHP laajennukset - Turvallisuusliitännäiset - MYSQL - PHPmyadmin - Raportoi mahdollisista ongelmista minulle ja tee parhaasi ratkaistaksesi ne ## Edellytykset: Odotan sinun olevan perehtynyt seuraaviin taitoihin ja kokemukseen: - Ubuntu LTS -käyttöjärjestelmän päivitykset - Apache-web-serverit - PHP, MYSQL, PHPmyadmin laajennusten, optimoinnin ja ylläpidon - Serverin turvallisuuteen liittyvät tekijät - Kyky kommunikoida s...

Tehtäväpohjainen työajanseuranta. (php mysql html5) Käyttäjät puhelimella (selainpohjainen) - tehtävien vastaanotto ja työajan kirjaus (kellokortti) - tehtävien kuittaus Pääkäyttäjät tehtävien lisäys ja tuntien seuranta. - Koosteraportit tunneista - tehtävien priorisointilistaus (esim 3 luokkaa vanhemmuusjärjestykseen) Sopivan henkilön löydettyä tarkempi käyttöliittymäsuunnittelu jonka pohjalta arvioidaan projektin kesto ja kustannukset.

...HTML5 as a page, where the game area is a canvas area and the game has three different colored coins that come down along a predetermined path. The database is a MySQL database, which is pre-coded. Player makes bitcoin transfer us, and the transfer is calculated to 20-digit binary number which determines a coin shop. 0 = right and 1 = left. Binary and bitcoin transfer calculation are encoded completed, but the playing area and mainsite should be encoded bit in the same style as has been done site. This would be good to manage HTML5, Canvas Advanced Animation Toolkit, jQuery, Windows animateframe, maybe socket open. Mysql database is complete, 20-digit binary number and the database is ready, but the game on the site is not yet as a PSD file. The coin must looking good whe...

as agreed Custom help java + mysql Custom help java + mysql Custom help java + mysql Custom help java + mysql

Hei, Sen verran hyvät meriitit löytyi Sinun freelancer.com esittelystä, että oli pakko ottaa välittömästi yhteyttä! Meillä on Wordpress pohjalla oleva laajennus, joka palvelee käyttäj...oli pakko ottaa välittömästi yhteyttä! Meillä on Wordpress pohjalla oleva laajennus, joka palvelee käyttäjiä tallentamaan monenlaista sisältöä oman profiilin alle ja näitä voi sitten toiset käyttäjät tutkia&vertailla. Ikävä kyllä valmis pohja kovin puutteellinen ja tarvitsisi useilta kohdin muokkauksia ja parannuksia. Muokkaukset tehtävä niin wordpressin puolella, kuin myös tietokannan puolella (mysql). Alkuun varmaan usealle p&au...

Php, joomla, drupal, wordplus mysql

c/c++ | c# | java | mysql | ngxin

Moikka, huomasin profiilisi ja ajattelin kysyä olisiko sinulla kiinnostusta tehdä etätyönä PHP/MySQL/JS koodia erilaisiin projekteihin jotka on tehty Yii Frameworkin päälle? Yst. Terv. Mika Saarinen Puh. 040 480 6791 mika@

Java Mysql Project

Etsimme pitkäaikaiseen yhteistyöhön suomenkiltä osaavan koodarin. Tarvittavia taitoja on php, mysql, html ja wordpress osaaminen.

our customers, our company is looking for website optimization skilled people. We want to hear your views on how you could implement for our customers tehokaita and affordable SEO solutions. What kind of tools you can use? Reporting tools, monitoring tools etc etc. In addition, we would like to hear your views on whether järkeävää our clients to set up a landing page for different domain and optimize the separate sites for different search words. Sell ​​yourself to us! What to give and you have the know-how for our company, and how and where you work consists of Reward

Job Title: Blockchain Architect for Gaming Innovation Job Description: We're seeking a talented blockchain architect to lead the creation of a pioneering blockchain network tailored for gaming. You'll design and implement smart contracts, collaborate with game developers, and optimize performance for a seamless gaming experience. Requirements: Proven experience in blockchain architecture and development. Proficiency in smart contract development (e.g., Solidity). Creative problem-solving skills and a passion for innovation. Strong communication and collaboration abilities. Gaming industry experience or a strong interest is preferred. Additional Information: Freelance position with flexible hours and remote work option. Compensation based on experience and project scop...

I'm currently looking to upgrade my website for two main reasons. Firstly, I want to improve the speed and overall performance of the site. Secondly, a modern design overhaul is needed to enhance the user experience. Key Upgrades: - **Website Performance**: The current website is running slow and I want to significantly improve its speed and overall performance. This includes optimizing images, code, and potentially hosting. - **Design Overhaul**: I am looking to give the website a modern, clean and visually appealing design. - **Key Functionalities**: The upgraded website should include enhanced blogging functionality and seamless social media integration. Ideal Freelancer: - **WordPress Expertise**: Experience with optimizing WordPress sites for speed and performance is ...

I'm searching for an outgoing, eloquent individual to make calls to homeowners in New Hampshire, with a focus on selling our solar home improvement services. Responsibilities will include: - Communicating professionally to promot...- Answering any questions homeowners may have about the service - Tailoring your sales pitch to persuade homeowners of our solar service's value It's essential that the candidate possess: - Exceptional communication and persuasion skills - Previous experience in telemarketing, preferably within the home improvement sector - Knowledge of solar energy systems and their benefits, as this will count heavily in your favor when conveying the product’s value to homeowners. If you are a determined go-getter with a knack for sales, thi...

As the developer of an existing project written in Python, SQL Server, and MongoDB, I am currently facing a challenge. A logical error in the code is causing a bug, and I need an expert to fix it. High-level summary of the code- 1. Fetch records from SQL server ( total 680000 records) 2. Apply face recognition on each record 3. Insert the response from step 2 in MongoDB along with other data from the SQL server Issue- The existing code is currently doing steps 1 & 2 and performing step 3 at last when face recognition is applied on all records. Due to this it step 3 is waiting to complete the step 1 & 2. Expectation- After fetching each record from SQL server, the code should apply face recognition and then store the data in MongoDB immediately. I will share my screen through te...

I'm looking for a skilled web developer who can create a stunning landing page to effectively showcase my product/service. Key Requirements: - Design a visually appealing and professional landing page that effectively presents my product/service. - Ensure the page is responsive and works well on multiple devices. - Implement the necessary SEO elements to optimize the page for search engines. Ideal Skills: - Proficiency in HTML, CSS, and JavaScript. - Experience in designing and developing landing pages. - SEO knowledge is a plus.

...Shiprocket API to facilitate seamless order fulfillment and shipment tracking. 5. Connect the frontend to the backend, ensuring proper data flow and interaction between the two. 6. Collaborate with the frontend developer to ensure smooth integration of custom designs. 7. Optimize the website for performance, security, and scalability. **Skills Required:** 1. Strong experience with Laravel 10.x framework, including MVC architecture, routing, middleware, and blade templating. 2. Proficiency in database management with MySQL or other relational databases. 3. Deep understanding of backend development principles and best practices. 4. Proven track record with API integration, particularly with payment gateways and shipping partners. 5. Familiarity with frontend technologies (H...

I'm looking to improve my website's SEO to generate more leads and conversions from local customers. The aim is to get visitors to submit inquiries via the contact form or place phone calls. Key Duties: - Optimize SEO to target local audience - Implement strategies to increase contact form submissions - Implement strategies to encourage phone call inquiries Ideal Freelancer: The ideal candidate will have significant experience with SEO, particularly geared towards converting local traffic. They will also have a proven track record in increasing contact form submissions and encouraging phone inquiries via effective and engaging website design.

...critical for the following reasons: - Enhancing user experience - Increasing my search engine rankings - Decreasing the bounce rate The freelance expert I am seeking must have proficient experience in website optimization, be results-focused, and exhibit understanding of the impact that the speed has on user experience and search engine rankings. Your task would be to identify, prioritize, and optimize the slowest elements of the specified website pages to improve the overall performance. Relevant experience in website speed diagnostics and relevant tools and techniques for speed optimization will be considered a plus. My website is earphoneguy.com. I am looking for specific tasks that can be verified and completed to increase the load times of my site. I have no problem doing...

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

I'm looking for a skilled professional who can set up and optimize Google Merchant Shopping Ads for my e-commerce website, Maxko.nl. I'm aiming to enhance my sales through this platform. Key Responsibilities: - Setting up Google Merchant Shopping Ads for - Conducting research on competitive keywords - Optimizing these ads to maximize ROI - Regularly monitoring and tweaking the campaigns for finer performance - Implementing conversion tracking to assess the effectiveness of the ads The ideal candidate should have: - A proven track record of setting up and managing Google Merchant Shopping Ads - Extensive experience in e-commerce and online marketing - Familiarity with 's e-commerce platform - Strong analytical and problem-solving skills - Demonstrable evidence of i...

Seeking a freelancer to revamp a WordPress webshop plagued by malware. Priority on simplicity in design, ensuring fast loading and security. Need existing products migrated to the new version seamlessly. Requirements: Malware removal & security enhancement Simple, elegant design Optimize for speed Seamless product migration WordPress expertise Timeline & Budget: Please propose timeline and budget. Previous WordPress experience required. If you're ready to tackle this project efficiently and deliver a sleek, secure WordPress webshop, send your proposal with relevant experience. Let's revamp this shop together!

I'm looking for an experienced SEO specialist to optimize my Google My Business (GMB) page at a city level, focusing primarily on keyword optimization. The ideal candidate would be someone who can confidently assure guarantied positive results, as success is key for our project. Our company o have retail store of Battery Operated three Wheeler. Therefore, knowledge and hands-on experience in this sector would be advantageous, particularly when pinpointing the most effective keywords to use. This project does not have a hard deadline and I am open to a flexible timeline. However, I would appreciate someone who can deliver guarantee results within a reasonable timeframe. We are into multiple business, will hire the person for other projects too. Ideal Skills: - Proficient in...

I'm currently in need of a skilled professional versed in CSS3, HTML5, PHP, and MYSQL. My primary requirement consists of creating minimalist and clean CSS styles for specific pages, namely the products page, product view, and checkout page. In addition to this, there will be some light PHP work involved. The ideal candidate should have demonstrable experience in these areas and a good eye for clean and minimalist design. Efficiency and attention to detail are key.

I'm in need of a skilled translator to convert a biography Wikipedia page from Portuguese to English. Key Project Details - Translation from Portuguese to English: The Wikipedia page I need help with is a biography. The task requires the translator to faithfully convert the content into English while maintaining the original context and meaning. - Word Count: I'm unsure of the specific word count. It would be ideal to have a translator who can handle varying lengths of content efficiently. - No Additional Research: The primary task is to translate the existing content, without the need for additional research or the inclusion of new information. Ideal Candidate Skills - Proficiency in Portuguese and English: The ideal candidate should have native or near-nativ...

I'm in need of a digital marketing expert who can effectively manage my email campaign. The primary goal of this campaign is to promote a product or service to potential new customers. Key Responsibilities: - Develop and execute an email marketing strategy to promote our product/service - Monitor and optimize campaign performance - Ensure compliance with email marketing regulations and best practices Skills and Experience: - Proven experience in managing successful email campaigns - Understanding of email marketing regulations and best practices - Ability to engage potential new customers through email outreach - Proficiency with email marketing tools and analytics.

We have an existing PHP/QuickBooks Online application designed to sync QuickBooks invoices to a MySQL database. The application works correctly when executed but we have an issue where the security token needs to be refreshed manually every 24 hours. We need to devise a way for this application to run with no requirement for refreshing the token manually. The program syncs orders in real-time so manual token refresh is not an acceptable way to do this. A developer is required with experience working with QBO applications and working with the QBO token refresh system so this refresh is done automatically.

...tables. The script should be optimized to avoid system slowdowns and long processing times. Script to Parse Product XML Files: The second script. This script will run continuously and parse XML product files located in a specified folder and its subfolders. Mapping of data: Correct mapping between products and relevant categories will be established using XML data and existing PrestaShop MySQL tables. As we have large amount of products and the feature data. We dont want the filter to read all the data while loading. for example TV category filter should only load and read filter data where products belongs to TV categoeiry. This will speed up filter load. Adding Filter Button for Mobile Display: This task involves modifying the mobile layout to include a filter ...

I'm seeking a highly skilled system administrator capable of installing CloudLinux with LVE and cPanel support on my server. - Purpose: The key goal behind this project is to optimize resource allocation for my server. I intend to host multiple websites on this server, making resource optimization crucial to seamless performance. - Websites: The server will host a diverse range of websites including e-commerce, blogging, and corporate websites. - Volume: The server should comfortably accommodate between 10 to 50 websites simultaneously. The ideal candidate for this project should have strong CloudLinux and cPanel working knowledge. An in-depth understanding of server management, specifically for resource management in high-traffic environments, is vital. Prior experien...

I have a medical document in Portuguese that requires immediate translation into English. I'm looking for a translator with a strong command of both Portuguese and English, as well as experience in translating medical documents. The translation needs to be completed within the next 24 to 48 hours. Word count: 1400 to 1600. Budget: 15 USD.

I'm in need of a skilled social media expert to manage and optimize a Facebook and Instagram advertising campaign to work with me on a contract basis , if shown exceptional work, we will be hiring too. Key Responsibilities: - Set up and manage ad campaigns across Facebook and Instagram - Generate leads through the campaign - Monitor campaign performance, optimize and tweak as necessary Ideal Skills and Experience: - Proven track record in managing successful Facebook and Instagram ad campaigns - Demonstrate expertise in the lead generation domain - Ability to analyze data and make data-driven decisions - Understanding of audience segmentation and targeting Please submit your proposal if you have the necessary skills and experience to help me achieve my marketing obje...

...detail-oriented and analytical professional to join our digital marketing team as a YouTube Analytics and Optimization Specialist. The ideal candidate will have a strong background in analyzing digital content performance, particularly on YouTube, but also with experience on other platforms. Your primary role will be to review and interpret analytics, and developing and implement strategies to optimize video content for increased views, conversion rates, and revenue generation. Responsibilities: 1. Conduct comprehensive reviews of our YouTube channel's analytics to identify trends, strengths, weaknesses, and opportunities for growth. 2. Develop and implement optimization strategies for video content, including but not limited to title and thumbnail adjustments, to enhance ...

I'm seeking a professional with deep experience in MySQL and Linux OS to carry out an installation. * Desired Proficiency and Experience: - Linux Operating System: You need to be familiar with Linux as the installation has to happen on this platform. - MySQl 5.7: The installation is specifically for MySQL 5.7 and you should have experience with this exact version. * Task Overview: - Install MySQL 5.7 on my Linux machine following the Development Machine Settings. * Configuration: - MySQL should be configured to run optimally on a development machine setting. - Your skills should extend to understanding the unique configuration needs of a development system and apply those effectively. Looking forward to your bids, please feel free ...

I'm seeking an experienced professional in WordPress site optimization to enhance my website's page speed. My target is a score of 70+ and a speed index below 2 seconds for the whole site. Key tasks include: - Run a thorough audit of the website to pinpoint speed issues. - Implement the necessary changes to optimize page speed. Skills and expertise required: - Proficiency in WordPress platform. - Deep understanding of website performance optimization. - Ability to perform a detailed audit and execute the needed changes. - Proven track record in achieving 70+ page speed scores and sub-2s speed index. I'm looking to get this project completed as soon as possible. If you have the skills and availability to deliver fast results, please get in touch.

I require an expert in Asterisk and FreeSWITCH development, along with experienced system engineering skills. Specifically, I need help with: - Asterisk and FreeSWITCH development - Integrating VoIP - Setting up Call routing and IVR (Interactive Voi...system engineering skills. Specifically, I need help with: - Asterisk and FreeSWITCH development - Integrating VoIP - Setting up Call routing and IVR (Interactive Voice Response) - CTI - Skill group base call routing to agents. Apart from these, the implementation of Asterisk and FreeSWITCH clustering as well as Call Center Reporting is required. The technology stack should be Linux, PHP, MySQL along with postgresql and API knowledge. The freelancer should have considerable experience in these to meet the project's specifi...

I need a basic web application for maintaining an efficient inventory of automotive spares. The key elements to be tracked include the part number, description, supplier information, purchaser details, condition, make, model etc. In the current scheme, we anticipate less than 100 spares in our inventory system. This is a very basic php/mysql application. I have created a rough up of the requirements using MS Access. I anticipate that the application will have; 4-8 tables. Main tables are - Contacts - Parts - Events 6-10 pages - Search Parts based on any field. - Search contacts - View/Create Contact with image upload - View/Create part with Image Upload and ability to print label - Create event associated with Part - Show all events related to part. Application needs to im...

I am currently struggling with slow loading speed on my WordPress website, causing less-than-optimal user experience. The issue started appearing after I added new plugins and uploaded large media files, which now need troubleshooting and resolution. Key tasks include: • Identify and resolve issues causing slow website loading • Optimize large media files without losing quality • Evaluate and optimize newly added plugins performance The ideal freelancer for this project will be an experienced WordPress developer with a strong understanding of how to optimize WordPress site speed. Knowledge and experience with plugins and large media file optimization are essential. While I am unable to provide a list of the recently added plugins, the hi...

...developer with a strong background in AI and ML. The project involves a full spectrum of responsibilities in these fields, and I'm looking for a professional who can hit the ground running. Key Responsibilities: - AI Development: You'll be tasked with creating, implementing and maintaining complex AI algorithms and systems. - ML Model Development: This role will require you to design, train, and optimize machine learning models. - Data Analysis: You'll need to collect, interpret, and present data in a meaningful way, to help inform our AI and ML projects. Required Skills and Experience: - Expertise in Python is a must. You should be comfortable with Python libraries and tools commonly used in AI and ML projects. - Proven experience in developing and deploying AI ...

...databases, and external APIs. * Develop and optimize SQL queries and scripts for efficient data retrieval. Data Transformation: * Perform data cleansing, validation, and transformation to ensure data quality. * Convert data from source formats to Oracle-compatible formats. * Apply business rules and data mapping for aligning source data with target data structures. ETL Development: * Develop and maintain ETL (Extract, Transform, Load) processes using standard tools. * Handle data integration tasks, including aggregation, enrichment, and consolidation. Error Handling: * Implement error-handling mechanisms to identify and address data conversion issues. * Monitor and log data conversion errors, creating processes for error resolution. Performance Tuning: * Optimize data conv...

...users' BTC funds and personal information, ensuring compliance with industry best practices and regulatory requirements. - Design a user-friendly interface that enables seamless navigation, account management, and transaction tracking for users of all experience levels. - Integrate with external APIs and services for real-time exchange rate data, liquidity provision, and transaction processing to optimize platform functionality. - Provide comprehensive documentation and support resources for users, including tutorials, FAQs, and troubleshooting guides. **Key Requirements:** - Proven experience in developing cryptocurrency platforms or similar financial systems, with a focus on Bitcoin (BTC) transactions. - Expertise in relevant programming languages, frameworks, and technol...

...interesting vlog. Creatively enhance the footage with colorful grading, engaging text, seamless transitions, captivating sound effects, and stunning VFX; add a playful touch - all to make the final product truly entertaining. Ideal Skills: - Proficiency in video editing software like Adobe Premiere Pro, Final Cut Pro etc. - Strong ability to incorporate effects such as color grading, graphics, and slow-motion - Experience in creating playful and entertaining vlogs targeted at a toddler audience - Impressive portfolio of previous video editing work Requirements: - Incorporate chosen effects following specified themes - Maintain the playful tone throughout the vlog - Provide samples of previous edited videos for review Your talent in converting ordinary footage into an appeal...

I'm in need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Prod...- Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in SQL and MySQL. - Experience in creating and optimizing database tables. - Strong understanding of relational databases. - Ability to write effective and efficient SQL queries. - Excellent c...

I'm in need of a seasoned .NET developer who possesses the following expertise: - Skilled in developing Web API - Knowledgeable in MySQL as a database system - Need 5+ Years Experience This is a personal project and I'm seeking someone reliable, efficient, and with a firm grasp on these skills to ensure successful implementation. If you have the experience and are keen on a unique personal project, I encourage you to bid.

I'm in need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Prod...- Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in SQL and MySQL. - Experience in creating and optimizing database tables. - Strong understanding of relational databases. - Ability to write effective and efficient SQL queries. - Excellent c...

...by xxxxx Design. xxxxxx have done updates for us over the years, including more recently a new checkout, mobile optimisation and SEO (2022). System Overview Our current developers have answered the below questions (their responses are in Yellow) 1. What are the current versions of software being used? OpenCart, PHP, MySQL etc in the various systems used?  Opencart V1.52 PHP Version 5.6.40 (any other newer version won’t be supported by the platform) MySQL - 10.4.28-MariaDB Laravel V5 … custom interface Active cron jobs running   2. What is the server spec & software versions? RAM, CPU, disk space etc. Full Software list here:  https://xxxxxxxxx/ We run a dedicated machine and resources can be allocated on demand… as minim...

I need a skilled professional to conduct a thorough review of my Shopify store. I'm primarily concerned about: * Navigation and user interface * App integration issues * Store performance and speed With 5-10 apps currently installed, the review should confirm that they are best practice and working efficiently. The freelancer should have significant experience with Shopify, UI/UX design, and ecommerce app integration. Recommendations for improvements are expected. Let's enhance the shopping experience and performance for my online customers.

...non-essential information. You might also need to correct any formatting issues or errors introduce during copy 3 Text Analysis: Analyze the copied text for various metric such as word frequency readability score sentiment analysis or topic modeling. This can provide insight into the writing style tone and themes present in the text. 4 Statistical Analysis: Calculate statistical metrics such as word count average sentence length or vocabulary richness to gain deeper insights into the writing style and complexity 5 Visualization: Create visualizations, such as word clouds histogram or scatter plot to represent the analyzed data in a more intuitive and understandable way. 6 Interpretation: Interpret the results of the analysis, drawing conclusion about the writing styl...

...in need of a savvy social media expert who can help me build my personal brand, focusing on Facebook, Instagram, and LinkedIn. The objective is to engage and grow my audience of self-development enthusiasts. Key Responsibilities: - Create and post original content resonating with my target audience. - Develop a consistent brand voice and aesthetic across the platforms. - Monitor analytics and optimize strategy for audience growth. Ideal Skills: - Proven social media management and brand building experience, preferably in the self-development sector. - Exceptional content creation skills. - Knowledgeable about Facebook, Instagram, YouTube & LinkedIn algorithms. - Strong understanding of audience analytics. Let's enhance my personal brand together and inspire more self...

I have a music website and I want you to optimize the website for SEO and build the website's backlink (good and effective backlink) the website is you can look it up and give me a short proposal from 7 days to 3 months. Also show me other websites you have done the same for in the past and evidence that show you did the job ( not more than 3 months please).

I'm looking for a proficient social media marketer to manage and optimize our Facebook and Instagram accounts. With a clear understanding of our target audience, primarily teenagers and young adults, the ideal candidate should craft engaging content, and execute strategies geared towards: - Increasing our brand awareness - Driving traffic to our website - Generating promising leads A proven record of similar past projects, creativity to resonate with the mentioned demographic and ability to analyze social metrics will be immensely valuable for this role.