Slow mysql queriesJobb
Hallå Linda! Vi håller på o bygger en sajt (ASP.NET med MySQL). Det vi skulle behöva hjälp med är att hämta data viss via olika externa API:er såsom SCB, Riksbanken, Yahoo Finance, Adtraction och stoppa in denna i vår databas. Detta ska ske med olika återkommande intervall. Företrädelsevis så hämtas datan -> och stoppas in via PHP via extern server vi kör - så du kan bortse att vi kör ASP.NET på sajten ? Har du något smartare sätt att sätta upp det än att använda PHP-filer och cronjobs?
Hej, Söker utvecklare som kan bygga vidare och utveckla befintligt projekt för och Nyttkontor.nu.
Jag har en väldigt enkel hemsida för min enskild firma, (Bara 5 sidor, 5 bilder och text med enkel layout. CSS stylesheet. Inte anpassad för mobiler.) Jag har lärt mig HTML och CSS på grundnivå och avskyr WordPress. Att uppdatera hemsidan till HTML5 gick bra men jag har inte satt mig in i viewport och 'CSS media queries for scalability'. Vad kostar det att bara lägga till denna funktionalitet i den befintliga hemsidan?
Hej, Jag söker en Sverigebaserad projektledare på timtid (uppdragstagare) för utveckling av min webbsajt som är baserad på Linux/PHP/MySQL/Codeigniter. Vår tjänst har varit online sedan 1995. Önskar en person som har lång erfarenhet av projektutveckling, kvalitetsarbete och "dataprogrammering" och som samarbetat med utvecklare internationellt. Du ska vara länken mellan mig och utvecklarna och leda, instruera och kontrollera utvecklarna. Nyckelord är funktionalitet, kvalitet, on-time, säkerhet, lönsamhet.
Mac PHP Har byggt en första version av en sajt som låter användare logga in och ange/ladda upp data. PHP/Mysql är använt idag. Skulle i dagsläget behöva primärt ett bollplank kring databasstruktur och koden principiellt men även hjälp med faktisk programmering för vidareutveckling av tjänsten. säkerhetsaspekter är också viktiga i nuläget
ska uppdateras med ny layout och nya funktioner. Sidan uppdaterades senast december 2012 och behöver nu nya funktioner och en mer attraktiv design som speglar innehållet väl. Den är byggd från grunden i php och med databassystemet MySql. Webbsidan har idag ca 500 medlemmar varav drygt 150 av dessa är mässarrangörer. Syftet med är att förmedla ut de hundratals mässevenemang som årligen äger rum runt om i Sverige. Vi fungerar som en länk mellan besökare/potentiella utställare och mässarrangörer och vice versa. Utöver begränsade administrationsroller för våra medlemmar, består av; Kalender (administreras av admin, arrangör) Företagsregister (...
ska uppdateras med ny layout och nya funktioner. Sidan uppdaterades senast december 2012 och behöver nu nya funktioner och en mer attraktiv design som speglar innehållet väl. Webbsidan har idag ca 500 medlemmar varav drygt 150 av dessa är mässarrangörer. Syftet med är att förmedla ut de hundratals mässevenemang som årligen äger rum runt om...Upplysningsvis så har vi det mesta av designen färdig. Endast små justeringar behöver göras där. Dock välkomnar vi gärna råd och tips) Smartast hade kanske varit att bygga från den befintliga sidan och inte en helt ny. Detta för att på ett så smidigt sätt som möjligt överföra all lagrad befintlig infor...
ska uppdateras med ny layout och nya funktioner. Sidan uppdaterades senast december 2012 och behöver nu nya funktioner och en mer attraktiv design som speglar innehållet väl. Webbsidan har idag ca 500 medlemmar varav drygt 150 av dessa är mässarrangörer. Syftet med är att förmedla ut de hundratals mässevenemang som årligen äger rum runt om...Upplysningsvis så har vi det mesta av designen färdig. Endast små justeringar behöver göras där. Dock välkomnar vi gärna råd och tips) Smartast hade kanske varit att bygga från den befintliga sidan och inte en helt ny. Detta för att på ett så smidigt sätt som möjligt överföra all lagrad befintlig infor...
Läsa data från en MySql databas till ett nytt Google Apps Kalkylark baserat på ett urval som t.ex. Artikelgrupp. Sedan skall nya antal matas in för respektive artikelrad i en kolumn. Därefter skall data med artikelnummer och nytt antal skickas till Fortnox Affärsystem med hjälpa av deras Webservice. Detta skall ske när man är klar med alla raderna.
...och tjänsten: "Bli en del av vårt team och du kommer att påbörja en fantastisk resa, där du arbetar tillsammans med ett entreprenörsdrivet och professionellt team” Vem vi tror du är 1) Du får saker gjorda, du vågar tänka utanför traditionella ramverk och du är inte rädd för att ta ansvar. 2) Du har kunskap inom och erfarenhet från minst ett webprojekt där serversidan är baserad på PHP och MySQL 3) Du har viss erfarenhet av hur man sätter upp och administrerar en Linux-baserad server med vanliga LAMP-tjänster 4) Det är ett plus om du har erfarenhet inom HTML, CSS, JavaScript och Ajax, men ditt fokus ligger på backend-utveckling samt viss serv...
...och tjänsten: "Bli en del av vårt team och du kommer att påbörja en fantastisk resa, där du arbetar tillsammans med ett entreprenörsdrivet och professionellt team” Vem vi tror du är 1) Du får saker gjorda, du vågar tänka utanför traditionella ramverk och du är inte rädd för att ta ansvar. 2) Du har kunskap inom och erfarenhet från minst ett webprojekt där serversidan är baserad på PHP och MySQL 3) Du har viss erfarenhet av hur man sätter upp och administrerar en Linux-baserad server med vanliga LAMP-tjänster 4) Det är ett plus om du har erfarenhet inom HTML, CSS, JavaScript och Ajax, men ditt fokus ligger på backend-utveckling samt viss serv...
Server installation, Xen virtual, mysql, apache
PHP ... MYSQL QUERIES ... SMARTY ... Details Attached.
En färdigbyggt e handel webbplats kan ej användas på grund av tekniska fel som behöver åtgärdas. Hemsidan är byggt på PHP, MYSQL CMS. Det behövs en PHP programmerare att fixa felet.
Hejsan sitter med en linux burk med centos 7.0, och en dreambox. Skulle behöva konfigurera dreamboxen så att man kan streama gratis kanaler via sin linuxburk. Jag skulle även behöva få fixat mysql,apache,php m.m.. MVH
Vi har en gammal MySQL databas som byggt på efterhand men aldrig strukturerats om. Den behöver byggas om för att göra den snabbare att söka i samt enkel att hantera för oss själva, idag finns inget admin gränssnitt för att göra ändringar. Sökresultaten skall sedan presenteras på en webbsida så kunskap att integrera i webben är önskvärt.
Jag har pågående arbete relaterat till vårat tidigare projektMySQL database problem (ASP.net nhibernate)'
Installing driver för mysql on Suse 11.2
...and requirements: Primary Functionality: - Users should have the ability to create their own accounts, which is crucial for creating a personalized shopping experience and tracking orders. - The app must support in-app purchases, as it is central to the shopping functionality. - Incorporating a live chat feature will enhance customer service, providing users real-time support and interface for queries and concerns. Ideal Skillset: * Strong proficiency in iOS and Android app development. * Past experience designing e-commerce apps. * Experience in incorporating in-app purchases and live chat functionality is preferred. * Knowledge in user-interface design for retail mobile apps. The perfect candidate should have a proven track record in developing user-friendly e-commerce apps...
...have a predetermined color scheme. The website will be an information hub about my business, hence no e-commerce functionality is required. Key Features Needed: - Contact Form: The site should have a user-friendly contact form for easy interaction with visitors. - Gallery: A gallery to exhibit my business' work or products is a must. - FAQ Section: An FAQ section is necessary to address common queries and to provide better understanding of my business. As the designer/developer, you'll need to be creative with colors (drawing inspiration from the logo), and ensure that the website is clean, professional, and easy to navigate. Experience with informational websites and a strong portfolio of past work will be a great asset. Looking forward to working with a profession...
Objective of the project The goal of the project is to develop an automated system that generates high-quality content related to beauty, cosmetics, ...from various sources (URL, RSS, XML) configurable by a Super User. Filter and process such content using artificial intelligence (AI) to improve it. Automatically publish enhanced content to a WordPress blog and various social networks. Provide an intuitive administration panel for managing system sources and configurations. Technologies and Tools Used Backend: Django Frontend: React Database: MySQL or PostgreSQL Monitoring: Prometheus and Grafana Containers and Orchestration: Docker and Kubernetes This project is already validated by AI tools to correct errors in the part described in the technical document, so the development is...
..." - "Instant Birria Consumé Mix" - All Natural Ingredients & Authentic Taste - Optional: "Quick and Easy" Unleash the Authentic taste of Mexico with Instant Birria -Instructions: "Combine one La Cabra Roja Instant Birria packet, four cups of water, and 1-4 pounds of cubed chuck roast, or meat of your choice, to a slow cooker or instant pot. Instant Pot - Set to Pressure Cook, on High, for two hours, then natural release for 15 minutes. Slow Cooker - Cook on low heat, covered, for 8 hours. Optional: Add the juice of 2 limes to the liquid mixture. Sear the beef before adding to mixture. Empty, wash, and dry the insert of the pressure cooker. Add 1/4 cup avocado oil to the pressure cooker and heat on the highest Sauté ...
...Programmer to join our team and work on our B2B ecommerce website and app development. The ideal candidate will have a strong background in PHP and Laravel, with experience in building and maintaining ecommerce platforms. This is a remote position, offering the flexibility to work from anywhere. Key Responsibilities: Develop, test, and maintain high-quality ecommerce solutions using PHP, Laravel, MySQL, HTML, CSS, JavaScript, and related technologies. Collaborate with the design and product teams to implement new features and improvements. Optimize and enhance the performance of the website and app to ensure a seamless user experience. Troubleshoot and resolve issues as they arise, ensuring the stability and reliability of the platform. Write clean, well-documented, and maintai...
I'm seeking a skilled professional to help me understand the basics of the Zig programming language, specifically in relation to MySQL/MariaDB. I would like assistance in the following areas: - Learning how to incorporate MySQL/MariaDB within Zig projects
As a client, I'm in need of a gifted freelancer who will design an AI chatbot that works hand-in-hand with Google Assistant. This chatbot will be programmed to carry out multiple tasks: - Answer typical queries - Offer relevant advice - Schedule meetings - Perform any function that is currently possible for it to do verbally The AI chatbot should be compatible with Slack and eventually extend to all phone applications. The chatbot should integrate with a database. We could explore other data integration requirements during our discussions. Ideal applicants are those familiar with AI chatbot programming, Google Assistant integration, and broad-reaching app compatibility. Database integration knowledge is essential, with bonus points for those who can offer a variety of data...
I'm searching for an expert Shopify developer with a wide range of skills, particularly in theme customizations and custom coding. We have daily tasks to tackle, so time efficiency is key here. If you're a slow worker, this may not be the right fit for you. Tasks: - Specific daily tasks will be given to you, so be prepared to handle them with agility and precision. - Custom feature development is a significant part of this job. You need to have a deep understanding of Shopify's capabilities to make this work. - Your tasks will focus on customizing three areas primarily: product pages, homepage layout, and navigation and menus. Ideal Skills and Experience: - Extensive experience with Shopify, including theme customizations and custom coding. - A deep understanding o...
I'm currently facing a Forbidden error in my Laravel project that's connected to a MySQL database. I'm looking for a skilled developer to troubleshoot and resolve this issue, and potentially optimize the database connections for a smoother performance. Key tasks: - Troubleshoot the Forbidden error in my Laravel project - Review and potentially modify the existing database connections - Ensure that the database connections are optimized for performance The ideal candidate will have: - Strong experience with Laravel framework - Proficient in MySQL database management - Proven track record in troubleshooting and resolving similar issues
I'm looking for an expert in WordPress to improve my existing pre-registration page...The site is in Japanese, so fluency in the language is a must. The project involves: - **Design Enhancements:** I need a fresh, modern design that is user-friendly and visually appealing. - **Functionality Improvements:** The page should be optimized for better performance and enhanced functionality. - **Fixing Website Issues:** There are some pressing issues that need to be addressed, including slow loading speed and mobile responsiveness problems. The goal is to make the pre-registration page load in less than 3 seconds. A skilled professional who understands the Japanese language and has a good grasp of WordPress is what I'm looking for. Your expertise is highly valued, so please sen...
...accountant who specializes in both US and Canadian tax laws, particularly for dual citizens, to get my taxes in order promptly. Responsibilities: File Canadian tax returns for the years since obtaining US citizenship in 2020. Ensure compliance with both Canadian and US tax laws and regulations. Provide accurate and timely filing of all necessary documents. Assist with any additional tax-related queries or issues that may arise during the process. Provide guidance and support for the green card sponsorship process concerning tax requirements. Requirements: Licensed and certified accountant with expertise in both US and Canadian tax systems. Proven experience working with dual citizens and understanding the intricacies involved. Excellent knowledge of tax treaties and regulation...
We are a web development company looking to expand our team. We need someone highly skilled in PHP and MySQL. Our work primarily involves custom projects, and occasionally WordPress. Currently, we have a job ready to start using the BigCommerce platform. This project requires code customization, assistance with connecting to shipping, and more. Thank you.
I need help migrating my Joomla-based website, which currently features a Currency Converter, to a new hosting server. Key Requirements: - Mig...migrating my Joomla-based website, which currently features a Currency Converter, to a new hosting server. Key Requirements: - Migrate the entire website (including the Currency Converter feature) from the existing server to a new one. - Ensure that the Currency Converter functionality remains intact and fully operational post-migration. Ideal Skills and Experience: - Proficiency in Joomla, PHP, and MySQL. - Prior experience with migrating websites, particularly those with dynamic features like Currency Converters, would be beneficial. - Strong attention to detail to ensure all components of the website are correctly transferred and op...
Requirements: - Vuejs, Nuxtjs - Tailwind CSS - Supabase/PostgreSQL - Nodejs/Deno - Typescript - Responsive Design - Maintainable and readable code - APIs - Authentication, Authorization, Roles & Permissions - Docker - Bonus: Tests Job: - Program members portal (tasks, events, payments, backoffice) - Blog & Blog backoffice with - Create and use queries and mutations - Newsletter: manage emails and newsletter backoffice (sendgrid and others) - Manage registrations (calendly like) 12 Pages: - Portal Login - Registration - Portal Dashboard - Portal Events - Portal Tasks - Portal Profile - Portal Settings - Portal Payments - Backoffices - Blog Main - Blog Single - Others
...our GCP infrastructure, including Compute Engine, Cloud SQL, and Cloud Storage. 2. Logging Setup: - Configure logging for all services: -- Frontend (Nginx, ): Log HTTP requests, errors, and application logs. -- Backend (Gunicorn, Django): Log application errors, access logs, and system logs. -- Celery and Beat: Log task execution and periodic tasks. -- Database (Cloud SQL): Log database queries and errors. -- Redis (Cloud Memorystore): Log Redis operations. - Collect and store logs centrally using GCP's Stackdriver Logging. - Set up log rotation and retention policies. 3. HTTPS Domain Configuration: - Configure an HTTPS domain for both frontend and backend services. - Use Certbot or another tool to obtain and manage SSL/TLS certificates. - Redirect HTTP requests to HTTPS....
I'm looking for an Angular developer who can help me ensure my project is responsive across all devices, including desktops, mobile phones, and tablets. Ideal skills: - Strong proficiency with Angular and responsive design concepts - Understanding of CSS and media queries - Experience with cross-browser compatibility - Able to work independently and meet deadlines Your primary task will be to design and implement a responsive layout that's user-friendly and visually appealing on all devices. Please note that I do not have any specific color scheme or branding guidelines, so you'll have the creative freedom to suggest a design that complements the responsiveness of the project. Looking forward to seeing your proposals.
...experienced CodeIgniter developer to upgrade my existing CodeIgniter 3 project to CodeIgniter 4. The project is currently live and needs to maintain the same database structure and functionality. The key tasks include: Upgrade CodeIgniter Version: Migrate the entire project from CodeIgniter 3 to CodeIgniter 4, ensuring all features and functionalities remain intact. Optimize SQL Queries: Review and optimize all SQL queries to handle heavy loads efficiently. The current system experiences performance issues during peak times, and the new version should resolve these. Fix Bugs and Security Issues: Identify and fix any existing bugs and security vulnerabilities in the current project. Ensure the new version adheres to the latest security standards. API Integration: Connec...
...like you're encountering a MySQL error related to an incorrect DATETIME value in your query. This error typically occurs when the format of the date and time being used in the query does not match the expected format in MySQL, or when an empty string is being used where a datetime value is resolve this issue, you should first check the format of the 'date_scheduled' values in your 'banners' table to ensure they are in the correct DATETIME format. You might also need to modify your query to handle cases where 'date_scheduled' might be empty or incorrectly you're not sure how to proceed or need further assistance with checking or adjusting your database, you can manage and review your MySQL databases and their tables from Site...
wordpress needs updated and the health pages errors fixed. woocomerece and plugins website is slow, need to make it load faster
...geo-location feature with map integration to track delivery drivers and shipment status. Customer Satisfaction: Monitor customer feedback and ratings for deliveries. . - **Customer Management**: A comprehensive customer management system is essential to handle orders, complaints, returns, and inquiries. - **Support System**: Ticketing System: Integrated ticket system to manage customer support queries and issues. Chat Support: Real-time chat support for immediate customer assistance. Call Center: Call center integration to handle customer inquiries and support calls. - **Points System**: Customer Loyalty: Implement a points system where customers can earn points on purchases, which can be redeemed for rewards or converted to wallet credit. - **Mobile Apps**: iOS and Android D...
I'm looking for a skilled professional who can meticulously guide me in video call through setting up a VPN using Google Cloud and OpenVPN. The primary aim is to ensure secure remote access to a MySQL database from my Windows laptop. Key requirements: - In-depth knowledge of Google Cloud and OpenVPN - Proven experience in configuring secure VPNs - Expertise in MySQL database security and remote access Your role will be to provide detailed, step-by-step instructions on how to properly configure the VPN to meet my security needs. Please bear in mind that I may require access to the MySQL database from multiple remote locations, but most likely will only need it running from 1 remote laptop - the VPN should be flexible enough to accommodate this added funct...
...Migrate the current backend code to Laravel 11 while ensuring functionality and logic remain unchanged. Database Optimization: Optimize MySQL queries for improved performance without altering the existing database structure. Bug Fixing: Identify and fix any existing bugs to enhance the overall stability and performance of the application. API Output: Ensure the new Laravel backend provides a consistent and reliable API output, compatible with current requirements. Performance Enhancement: Implement best practices to improve the performance of the backend system. Requirements: Proven experience in both CodeIgniter and Laravel frameworks. Strong understanding of MySQL database management and optimization techniques. Ability to maintain existing database structures and...
...(credit cards, PayPal, etc.) Order tracking and history Payment Gateway Integration: Integration with major payment processors like Stripe or PayPal Secure transaction handling Rating and Reviews: System for buyers to rate and review sellers and products Display of ratings and reviews on product and seller profiles Messaging System: Direct messaging between buyers and sellers for negotiation and queries Notification system for new messages and updates Price Tracking and Market Analysis: Historical price data and trends for products Alerts for price changes and new listings Detailed price history, including a 12-month history of trade range, sales, price, average sale price, last sales, current sales, current bids, and current ask price Authentication and Verification: Option...
I'm looking for a talented artist to create a minimalistic cartoon character based on a paperclip with arms, eyes and legs for my project. The character will convey a focused emotion and will be illustrated in two different scenarios. There will be more work if the first 2 are suitable. - Climbing out of a cardboard box. - Picking up li...more work if the first 2 are suitable. - Climbing out of a cardboard box. - Picking up litter. The character should exhibit a unique blend of simplicity. This project is perfect for freelancers with experience in character design and a knack for minimalism. Particle knowledge of conveying emotions through characters would be desirable but not mandatory. Feel free to reach out if you have any queries. See the picture for the sort of thing I...
...system that generates reminders for clients' appointments. * Personalized Booking Page – Each client should have their own dedicated booking page. A standout aspect of this site is the Resources section, which must include: * Regularly updated articles and blog posts about relevant therapy topics. * A catalogue of recommended books and resources. * A comprehensive FAQs section addressing common queries about the practice and therapy in general. Ideal Skills and Experience: Freelancers should have proven experience in web development, with a portfolio showcasing their ability to create engaging, user-friendly interfaces. An understanding of the therapy industry and appointment-based businesses would be beneficial. Experience integrating automatic reminder systems, blo...
Build an ISO for a raspberry pi (with cellular notecard) to scan for unique cell phones in a specific range and log the unique phone ID and timestamps/ping (distance) from the raspberry pi and store in mysql database using cellular adapter.
I'm in need of a proficient expert who can assist me with running queries on DuckDB using data originating from Amazon S3. This task primarily involves: - Interacting with semi-structured data such as XML and JSON - Processing a substantial data volume ranging from 1GB to 1TB The ideal freelancer should have the following capabilities: - Deep understanding and experience with DuckDB and Amazon S3 - Strong skills in handling and querying semi-structured data - Experience in managing and processing large volumes of data Please note: it's critical that the freelancer have experience with managing these sorts of tasks previously and has a solid understanding of large volume data manipulation.
...backend developer who can build a robust REST API. The ideal candidate should be proficient in MySQL, and have experience in user authentication, data retrieval, and data modification. Key Requirements: - Develop User Authentication: The API should include secure user authentication functionality. - Implement Data Retrieval: The API must be able to retrieve data from MySQL database as needed. - Data Modification Capability: The API should also support updating and deleting data in the database. Additional Needs: - Third-Party Integrations: The API will need to integrate with a payment processing system and also be able to send WhatsApp messages. If you have a strong background in Node.js, MySQL, and building REST APIs, I'd like to hear from you. Please incl...
I'm looking for an experienced web developer to help me with some quick fixes on my website. Key Issues: - Slow Loading Time: My homepage and product pages are experiencing slow loading time. The website is currently loading in more than 10 seconds, and I need this to be improved to less than 10 seconds. - Formatting Issues: There are also some formatting issues on the website that need to be corrected. Ideal Skills and Experience: - Proficiency in web development and optimization - Experience in resolving slow loading time issues - Strong understanding of responsive web design and CSS for fixing formatting issues
I'm seeking a professional to provide advanced technical support for my desktop software that runs exclusively on Windows. Specifically, 2016 windows office and current outlook, not recognizing Recent emails, calendars, and inbox sub folders Key Responsibilities: - Offerin...issues Ideal Candidate: - Proven experience in providing technical support for Windows software - Strong knowledge of how desktop applications work - Excellent problem-solving and communication skills - Ability to work remotely and respond to support requests in a timely manner - Familiarity with software debugging tools and techniques - A patient and customer-oriented approach to handling user queries Your involvement will play a crucial role in enhancing the overall user experience and satisfaction wit...