Mysql slow query magento jobs

Magento backend not working Showing invalid or password expired

I'm currently dealing with a file (PHP and MySQL nested queries) that urgently needs to be resolved. - The content of that page takes a long time to load (sometimes i get a timeout error message, but not always). While the page is trying to load, the other pages of the website are not accessible (loading indefinitely until the problematic page has finished loading). The problem requires an experienced PHP and MySQL freelancer with strong diagnostic skills, who is not averse to confronting an undefined problem. For now.

I am looking for an enthusiastic and hard-working website developer experienced in creating e-commerce platforms. Particularl...user review functionality with options for rating and comments to enhance trust and reliability about tour packages. - Develop a vibrant and interactive bloggers' page where travel enthusiasts can share their experience and tips. Ideal skills: - Experience in developing e-commerce sites, especially TOUR PACKAGE COMPARISON. - Expertise in platforms like Shopify, WordPress with WooCommerce, or Magento. - Proficiency in UI/UX design to create an engaging and easy-to-navigate website. Your bid should include platform suggestion, time estimate, and consultation on user-friendly design practices. Excited to collaborate with individuals who can bring this ...

It is a javafx application which stores records in a mysql database, it was made with an older version of JDK 8 I need to rebuild it for my project using the latest JDK because the new SDK 21 doesn't have inbuilt javafx I need it done preferably in netbeans . Only help Migration from Nashorn to GraalVM is needed , the older ANT build doesn't work.

I'm currently dealing with a file (PHP and MySQL queries) that urgently needs to be resolved. - The content of that page takes a long time to load (sometimes i get a timeout error message, but not always). While the page is trying to load, the other pages of the website are not accessible (loading indefinitely until the problematic page has finished loading). The problem requires an experienced PHP and MySQL freelancer with strong diagnostic skills, who is not averse to confronting an undefined problem. For now.

Im using a python ffmpeg script to encode videos, script rendering videos very slow, maybe some guru can speed it up here is my code

...expertise to design and implement the right architecture to handle such load (interative client-side or server-side rendering modes, use of SignalR or SocketIO, caching, load balancing, load testing etc.) - Over 2 years of solid Blazor experience, including the latest .NET 8 rendering modes - Over 5 years of C#/.NET experience - Strong experience of API integration - Excellent database skills (MySql) - Experience with MAUI is advantageous, as the development of a mobile app could be a future stage of the project. The project is expected to last 4 to 6 months. The work is fully remote. We offer flexibility in terms of the weekly hours you can commit to the project. Our preferred compensation model is an hourly tariff rather than a fixed project fee. This is an innovative and exc...

...achieve best performance and reconfigure multicast / mdns so Spotify Connect and AirPlay / Screenshare work properly. As for now when I restart the mdns devices, they appear properly (Spotify connect / AirPlay), but disappear after a while. Also my device names (MacBook / iPhone) keep adding incremented numbers to their names (e.g MacBook (2747)), this should also stop. The network is very sluggish / slow when trying to connect to it and sometimes it takes multiple tries. Furthermore I’d like to activate IPv6 on the whole system, so the modem, switch and wlc, etc. need to be configured. The setup is as follows: There is a central netgear switch Netgear GS748Tv5 (), no management functions active, that has the following devices connected (wired): internet modem / router ...

I'm currently dealing with a file (PHP and MySQL queries) that urgently needs to be resolved. - The content of that page takes a long time to load (sometimes i get a timeout error message, but not always). While the page is trying to load, the other pages of the website are not accessible (loading indefinitely until the problematic page has finished loading). The problem requires an experienced PHP and MySQL freelancer with strong diagnostic skills, who is not averse to confronting an undefined problem. For now.

...for managing credential categories: * Allow users to add new credential categories (e.g., PALS, NRP). * Provide the ability to edit or remove existing credential categories. * Ensure the application adheres to secure coding practices to protect sensitive instructor information. **Technical Skills:** * Proven experience in PHP development * Experience with database management systems (MySQL preferred) * Strong understanding of secure coding practices * Familiarity with email-sending functionalities in PHP (e.g., PHPMailer) with templating capabilities * Experience with user interface development (HTML, CSS) is a plus * Experience with data visualization libraries (optional, but a plus) **Deliverables:** * Functional PHP application with a user interface * Well-document...

I'm seeking an experienced web developer to create a comprehensive e-commerce website selling physical products predominantly to an adult audience. Key Requirements: - Expertise in the best and most responsive e-commerce platform. I'm not tied to Shopify, WooCommerce or Magento, but I'm looking for the most effective solution. - Proficiency in creating an intuitive user experience, clean design, and strong SEO practices. - Familiarity with my target market - adults. An understanding of their online purchasing behavior and experience building similar sites will be a bonus. Skills and Experience: - Proven experience in designing and building responsive e-commerce websites. - Knowledge of SEO best practices. - Ability to recommend the best e-commerce platform based ...

I'm seeking a highly skilled video editor to help me create a compelling video with a narrative storytelling edit style. The ideal candidate will have a knack for prope...video editing skills, preferably with experience in narrative storytelling. - Ability to compress narratives to a maximum duration of 5 minutes without losing the message's essence. - Creative approach to integrate seamless transitions and captivating visuals. - Capable of delivering a finalized project promptly. Though special effects aren't strictly necessary, familiarity with color grading, slow motion, and animation effects may be advantageous should your creative vision call for their application. I look forward to seeing your past works and discussing how your style might best serve this proje...

I'm currently dealing with a file (PHP and MySQL queries) that urgently needs to be resolved. - The content of that page takes a long time to load (sometimes i get a timeout error message, but not always). While the page is trying to load, the other pages of the website are not accessible (loading indefinitely until the problematic page has finished loading). The problem requires an experienced PHP and MySQL freelancer with strong diagnostic skills, who is not averse to confronting an undefined problem. For now.

I need a programmer with strong skills in...programmer with strong skills in Python, React, and MySQL to quickly and effectively connect my existing cPanel cloud MySQL database to my current react app/python project. This task will involve the ability to: * Work remotely via Anydesk * Perfectly connect to both local MySQL database and cPanel Cloud MySQL * Print the status and any table values for sample from both databases The ultimate goal is to both retrieve and update data in the database. The specific type of data we'll be dealing with largely encompasses user profile information. Rest assured, the database schema is already settled on my cPanel, making your work easier. To fit this task, the ideal freelancer should possess strong technical proficie...

I need an experienced AWS specialist to set up, configure and secure a database on an AWS server. This job will involve hosting a relational database i.e., (MySQL, PostgreSQL), and therefore requires someone with strong experience in this area. Key Tasks: - Set up and configuration of the database on AWS - Implementing data encryption for enhanced security Ideal Skills: - Proven expertise in AWS - Strong experience with MySQL or PostgreSQL - Familiarity with data encryption methods Please, highlight your previous experiences with similar projects when placing your bid.

I am in search of a highly skilled web designer and developer. An ideal candidate should be adept with HTML/CSS, Javascript/jQuery, and PHP/MySQL. The specific use case for the site was not specified, which brings the need for someone with wide-ranging capabilities and able to adapt to a variety of requirements. Key Responsibilities: - Website design - Website development - Code implementation I will provide the content for the website, so your focus would be solely on developing a functioning, dynamic, and user-friendly site. Multi-faceted experience is key and a proven track record in efficient and quality code implementations is a huge plus.

I'm in urgent need of an experienced C# developer skilled in ASP.NET and MySQL for a web development project. This project involves building a robust, yet dynamic website from scratch. The potential freelancer would preferably have: - Proficiency in C# programming, particularly related to ASP.NET. - Previous experience in front-end and back-end web development - Comprehensive understanding of MySQL database systems for ASP.NET web development. If you have hands-on experience with these technologies, I'm looking forward to discussing the details further. The applicant must be detail-oriented and have a result-driven approach. Come prepared to show relevant examples of your past work.

...forms into a database. Preliminary specifications of the form source, type of data to be saved and the type of database have not been provided, thus, I need a professional who is versatile with different forms and databases. Here’s what I expect: • Proficiency with different types of forms, such as HTML, Google forms and WordPress forms. • Ability to work well with various databases, including MySQL, PostgreSQL and MongoDB. • A proactive approach in your actions. For example, suggesting the best form and database for this task if required. • Strong communication skills, providing regular updates about the progress. While bidding, please include: • Your past work related to this project. • Your experience dealing with various forms and databa...

I have a mysql query which loads customers email addresses thru a php script. inside the php script it loads all customer email and usually only takes about 5 seconds then also in the script it loads any emails which have been BLOCKED or BLACKLISTED these come from another table then it allows me to filter the emails and remove the blocked emails from the mailing list before sending emails. BUT HERES THE MAJOR PROBLEM as my blacklist or blocked list grows the query time seems to GROW EXPONENTIALLY ive went from 5 secs with 0 blocked emails to 70 secs with just 300 blocked emails its taking around 5 secs for every additional email i add i had a look at the query it doesnt seem excessive but something is slowing it down i need this looked at to see if we can ...

I am in need of an experienced software developer to work on an open-ended project. Though I've not provided specific bugs, I need a professional adept in problem-solving and proficient in identifying and fixing a range of software bugs, which may include, but aren't limited to, error messages, page crashes, and slow loading speeds. The ideal specialist should be highly responsive, detail-oriented, and able to proactively suggest feature enhancements for optimization, based on their professional evaluation of the system at hand. Skills and Experience needed: - Proficient in software troubleshooting - Experience in improving webpage loading speed - Adept at identifying and addressing error messages and crashes - Can suggest system updates and feature enhancements - Quick...

...integration instructions for future reference. Stay up-to-date with new technologies and best practices in API development to suggest improvements to our platforms. Requirements: Proven experience in Flutter and Node.js development, with a portfolio or examples of previous work. Strong knowledge of RESTful API development and experience with API testing tools. Familiarity with databases (e.g., MySQL, MongoDB) and understanding of data structure principles. Excellent problem-solving skills and ability to work independently on solutions. Good communication skills for effective collaboration with the development team and stakeholders. Attention to detail and a commitment to delivering high-quality, functional, and user-friendly applications. Ability to meet deadlines and efficientl...

Hello, I am looking for a creative freelancer who can create new teaching materials for teachers to use in the classroom every day. You can find examples of good teaching materials here: Nice cover: Currently, I would like to have different teaching materials for children in grades 1 to 4 (ages 6-10). Each material should have a goal. Please let me know in advance exactly what the material you create will be used for, what subject it will be used for and how it will be used. Each material should be 5-25 pages long with 1 cover page (in a file). No copyrights must be infringed (if other resources/licenses other than are used, always specify). Only

I need a professional developer to overhaul my Android store. Currently, it suffers from regular crashes and connection errors which impede its performance. I'm also interested in improving the application's UI/UX to offer my users a seamless interface. The project will involve: • Rectifying the current issues, including the slow loading time, and ensuring optimum performance. • Integrating new features such as push notifications, in-app messaging, and social media integration for a versatile and engaging user experience. Ideal Skills: • Expertise in Android application development and troubleshoot. • Proficiency in enhancing mobile application performance. • Experience in implementing push notifications, in-app messaging, and social media int...

We are looking for an Experienced Magento Developer. We require specialized skills to enhance our website's functionality and user experience. The job involves a series of key tasks: Redirection of /en Directory: You will need to redirect all URLs containing the /en directory to the website's main domain. This task is crucial for maintaining a seamless user experience and preserving our SEO rankings. Regeneration of Canonical Tags: Update and regenerate 301 canonical tags for all links that have the /en extension. This step is essential to ensure proper link attribution and to avoid any duplicate content issues. Removal of /en Extension on the Homepage: The homepage URL currently includes an /en extension, which needs to be removed. Additionally, you'll implemen...

After reviewing the files you have sent, I understand that you are looking for SQL expert to write sql query and extract the data. I have carefully analyzed your needs and believe that I possess the skills and expertise necessary to successfully complete this project. I estimate that I will take approximately 1-2 days to complete.

I need an experienced Sys Admin who specializes in NGINX, M2, WHM, Varnish and SSL configuration. My e-commerce website is built on Magento. Responsibilities: - Configure Varnish for optimal performance - Ensure seamless integration with M2, WHM, NGINX and SSL - Boost website performance and minimize server load Ideal Skills: - Expertise in NGINX, WHM, Varnish, SSL performance tuning - Proficient in Magento e-commerce platform - Strong problem-solving ability, able to resolve unexpected issues during configuration No beginners, please. This task requires a deep understanding of server administration and Magento performance optimization. I'm looking for a smooth, efficient process without disrupting live operations. Your innovative solutions and meticulous atte...

...highly experienced Magento 2 development team. We prefer a company with a proven track record, as the work will be for a corporate website. A couple of things to mention: - The developer should be able to resolve any and 99% of the errors thrown by Magento 2. - They should be capable of customizing email templates, as that is one of the tasks we have at hand. - They should know how to create custom payment modules, like a UPS module to auto calculate the shipping rate based on the postal code, etc. Strictly no outsourcing companies, please. We are looking for a reputable Magento development company that employs in-house developers. These are some of the tasks we have at hand, but there will be more projects and ad-hoc needs, since we just migrated from Magent...

...and promotions with a 50% discount. Users will have access to a wide range of purchasing opportunities, covering various product categories. Project Benefits: Expansion of research to cover a wide range of offers. Increased accuracy in online searches. Specific relevance to user needs in the buy-sell market. Overall improvement of the user experience. IT Professional Needed: Advanced Search Query Architect: We are looking for an IT expert specializing in optimizing online searches through advanced queries. Required skills include: Programming Languages: Advanced experience in scripting languages like Python to develop a dynamic and adaptable script. Google Dorking and Advanced Search: In-depth knowledge of Google Dorking and advanced search techniques. Reference Ontolog...

...into manageable sections for AI processing. Familiarity with PyMuPDF, PDFMiner, and natural language processing tools like SpaCy will be crucial. Searchable Index Creation: Creating an efficient searchable index with Elasticsearch to power quick retrieval of text segments relevant to user queries. Experience in integrating Elasticsearch with large datasets is highly desirable. AI Integration for Query Processing: Collaborators will also work on integrating AI models to analyze queries, retrieve relevant document segments, and generate coherent answers. Expertise in AI model integration, preferably with OpenAI's ChatGPT or similar technologies, is required. User Experience & Interface Feedback: Ensuring a seamless loop of user feedback and application refinement, aiming f...

I am seeking expert assistance with a Microsoft Access report that is a bit complex for me. The report is built around several linked tables, and I am currently having difficulties managing calculations and queries related to it. Key Tasks: • need last price from vendor for list of items in a table • Revising existing queries • Extracting operational data The crux of this project revolves around understanding the report and improving the queries to get the right operational data. As such, vast experience in handling Microsoft Access linked tables and proficient knowledge of SQL will be crucial. Thank you for considering my project.

I am experiencing some difficulties with my Apache HTTP Server. It has been unable to load web pages, and I get frequent error messages. There's also noticeable slow server response time, which affects the user experience drastically. Despite not having made any recent changes or updates to the server configuration, these problems persist. My Apache server primarily hosts a WordPress website, so it's critical that these issues are resolved as soon as possible. Skills & Experience Required: - Extensive experience with Apache HTTP Server - Ability to diagnose and resolve server issues - Familiarity with WordPress and hosting configurations - Proven track record of improving server response times My website is receiving "HTTP ERROR 500" when going to the do...

I am currently experiencing a problem with slow loading speeds on my WordPress website and I am looking for someone to help. Primarily, the loading issues are occurring on the home page and product pages, which need instant attention. The ideal freelancer for this job would be someone who has: - Proven experience with WordPress and optimizing its speed. - A clear understanding of how to analyze and solve these types of issues. Given that this project is all about improving the load speeds, success will be measured by the tangible impact on site performance. So if you're applying for this task, please make sure to include: - Any relevant past work experiences. - How you intend to solve the mentioned problem. - Any tools or methods you'd use to achieve these kinds of imp...

I am looking for a freelancer who can set up a new project. The main tasks will include the installation of WordPress on a traditional LAMP stack (Linux, Apache, MySQL, PHP). Configuration of W3 Total Cache to work with a Redis server is also required. The goal is to optimize the website's load times, creating a seamless experience for the users. This project should result in a well-optimized, high-performing website. The website is already done, you will only migrate it with All in one migration plugin. Recording a video of the whole process is a must.

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

... What is needed: If request URL returns 404, display a page with relevant Google search results. Get the results from my API (or your API if the price is good). How to display results: Query API for the request URL Take title (minus subdomain name if exists in title) and query API again for that title Display 4-6 results on this page. Store results in JSON in case this URL is requested again (to avoid API calls for this URL). If Query API for the request URL returns no page title, query API for the subdomain of the request URL, return 4-6 results. You will need to do it on your localhost, I cannot provide server access. Any reply without " I have fully read and understood what needs to be done and I can do it on localhost " will

Looking for magento developer for ongoing issue

I have some errors on my website which I need to fix . Looking for Magento Developer

Work to do: 1. add two parameters in one specific API that already work 2. Optimise speed, current grading is F at gtmtrix Key Requirements: - Strong experience in Magento 2.4.3 p1. - Proven experience in API development and troubleshooting. - Strong understanding of backend performance optimization techniques. - Problem-solving skills and attention to detail. - Good communication for efficient progress reporting. By the completion of this project, I expect the product API to function seamlessly with the additional special parameter and an enhanced server speed. I'm looking forward to working with a professional who can quickly resolve these issues.

I have installed macOS Sonoma on VMware 17 on a Windows 10 OS and was using it for a year already. Now I have noticed issue with Internet speed inside VMware Speed Test showing download 50MBps and upload 0.09MBps Outside MVware the speed test is normal and showing both download and upload speed 50MBps. AnyDesk access can be provided to connect to the system remotely to fix this issue

...plesk where it isn't possible to view or edit procedures/routines in PhpMyAdmin on Plesk. The root cause seems to be related to MySQL privileges. This issue needs to be addressed as soon as possible given that it significantly hampers the operation of our business. I have tried to set: - SUPER to the DB admin user, GRANT SUPER - GRANT ALL to the user and a lot more whatever I do the routines and procedures are inaccessible. And yes, I have tried with both root and admin For this project, the ideal freelancer would have: - Extensive experience in managing Plesk environments - Profound knowledge and experience with PHP, specifically in a Plesk environment - Strong MySQL skills particularly around user privileges - Have the ability to start and end the task urgently ...

I'm searching for a Laravel developer to make some upgrades in our API. The project lacks specifics as some initial questions were skipped, however, the core objective is enhancing our API. The possible changes as per initial query comprised: - Adding new features - Improving performance - Fixing bugs The subsequent questions on the specific required changes were also overlooked, so we're open to any enhancements that could be made on your professional perception. Ideal Skills: - Proficient in Laravel framework - Strong experience in API building and optimization - Deep knowledge of web performance and bug-fixing Please, provide your proposal highlighting your previous experience and your ideas on possible upgrades for this API. Let's bring this Laravel API to a ...

I am searching for an experienced web developer with solid expertise in HTML/CSS, JavaScript, PHP, MySQL, and jQuery. This assignment involves creating an e-commerce platform adhering to my specific design requirements. In particular, the project scope includes: • Building the e-commerce platform from scratch utilizing HTML/CSS, JavaScript, PHP, MySQL, and jQuery • Implementing specific design requirements offering a seamless user experience Potential candidates should have a background in e-commerce website development, and a strong understanding of frontend and backend operations. Previous work examples which reflect your technical skills and creativity are essential. This project could potentially extend into a longer term, making this an excellent opportuni...

...seeking a skilled freelancer who can help me integrate my Buy Now, Pay Later (BNPL) app with my MySQL database and make several design alterations. My requirements include: Server Integration: I already have a server where my MySQL database is hosted that will need to be integrated with the flutter application. Design Modifications: • Color Scheme Alterations: I am looking to modify the current color scheme of the application. • UI Redesign: The user interface of the application will require a complete redesign. • Layout Changes: I am expecting a significant change in the current app layout. MySQL Database Modifications: • Adding new Tables: I will be needing additional tables within my MySQL database. • API Endpoints Integrati...

...then redirected to either the success or failure URL provided by the merchant, based on the outcome of the transaction. The PSP sends a server-to-server API notification to the merchant with the payment status, ensuring that the merchant is immediately informed of the transaction outcome. Step 9: Merchant Communication Beyond the immediate transaction notifications, the merchant has access to a Query API provided by the PSP. This allows them to check the status of the payment at any time, supporting ongoing order management and customer service efforts. This revised flow incorporates your specific requirements, focusing on leveraging information provided by the merchant to streamline the payment process, ensuring clarity and compliance with necessary agreements, and enhancing the...

...Clear Requirements for Proposal: Fixed Price Proposal: I expect to receive proposals with a closed price for the complete development of the plugin. Proposals that are not clear or suggest potential price variations will be automatically discarded. Required Expertise: I am looking for a developer with proven experience in WordPress, particularly in plugin creation, and solid knowledge in PHP, MySQL, along with familiarity with JSON data structuring and REST API operations. This project has a well-defined scope, focusing on backend functionality and creating a JSON endpoint, without the need for front-end implementation. If you have the skills and willingness to work within these parameters, with a transparent and fixed budget, please send your proposal including your portfolio...

I'm currently facing an issue with my website's home page, which is loading at a painfully slow speed. The issue predominantly arises due to the presence of high-resolution images and heavy scripts or codes on the page. To curb this, I'm seeking the assistance of a skilled Website Performance Optimizer who can: 1. Minimize the load time of high-resolution images without compromising image quality. 2. Scrutinize, optimize, or potentially rewrite the heavy scripts or codes that are slowing the site down. Ideal freelancers for this job would possess demonstrable experience in improving website load times, particularly in optimizing both images and code for superior performance. Proficiency in coding languages (such as PHP, JavaScript, CSS, HTML) is essential, along ...

...replication of Bigcommerce or Magento website, identical 100% in everything. The aim is to exactingly recreate the vital aspects: * Product Catalog: The ability to easily list, manage, and categorize our products is vital. * Shopping Cart: A user-friendly and secure shopping cart is required. * Payment Gateway Integration: This should include all the major processors for customer convenience. * Advanced Search Functionality: Customers should be able to find what they're looking for within seconds. * Inventory Management: I require a simple yet robust system to track stock. Design-wise, the Homepage layout, Product listing page design, Checkout page design, etc must be identical. Ideal candidates for this project should have ample experience with Bigcommerce or Mag...

I need an experienced Laravel developer who can identify and solve issues...experienced Laravel developer who can identify and solve issues with the efficiency of specific database queries and faulty job queues in my Laravel 5.8 project. Key Areas of Concern: - Fixing slow queries: The database query that retrieves user information is running slower than it should. I am looking for a solution to speed up this process. - Resolving queue issues: Job queues are failing to run, causing an operational bottleneck. Your task also includes finding and implementing a fix for this issue. Ideal Skills: - Proven expertise in Laravel, particularly version 5.8 - Good understanding of database query optimization - Familiarity with queue and job execution in Laravel - Clear and pro...

I'm looking for someone with experience in improving CSS rendering times, specifically to address slow load times on my homepage and product pages. My website is built on Codeigniter. The ideal candidate should have: - Proficiency in CSS, JavaScript, and Codeigniter framework - Experience in website optimization techniques - Knowledge in handling LCP (Largest Contentful Paint) elements - Ability to eliminate render-blocking resources, specifically in CSS Prior modifications done include image optimization and addressing the LCP elements, but I want to push the performance further by better handling CSS rendering. A successful project will result in noticeable improvements in page load times. *** ***

...management system that will help keep track of product availability and sales insights. Moreover, the website should be compatible with my Point of Sale system, with a possibility for integration via MYSQL for a smooth flow of data and operation. Though the prototype I provided should give you a general idea, I would like the design to be all the same as the Empire Kosher Supermarket website, which suggests a neat and simple design with effective branding and having all exactly similar capabilities. For this project, you should have a strong background in custom solution development, with experience in MYSQL for POS integration. You should also have expertise in creating intuitive navigation and efficient search and filter systems. Your ability to weave these together i...