Populate drop php select query jobs

i have one php script which used to load in a few seconds now takes 4 minutes not sure why it suddenly lags need optimised - the mysql query hittin some bottleneck somewhere by looks of it

I'm in need of a skilled individual who is proficient in both PHP and Google Gemini. The primary task is to integrate this platform with my PHP website. Key requirements include: - Basic data syncing: The main goal is to ensure that the PHP website and Google Gemini can share important data seamlessly. This includes basic data such as user information, clicks, and impressions. The ideal candidate must have: - Demonstrated expertise in PHP and Google Gemini. - Prior experience in integrating Google Gemini with websites. - Strong communication skills to understand my requirements and provide updates on the integration process.

I'm looking for an experienced full-stack developer to build ...Content Packaging & Distribution - Content Localization - Import & Export Functionality - Settings & Integrations - Security & Compliance - Performance Monitoring & Optimization The ideal candidate should have: - Proven experience developing admin dashboards - Expertise in Flutter, Firebase, PHP - Strong design sense for clean UI/UX - Knowledge of user management, data viz, content systems - Ability to ensure security, performance, compliance Your role will be to implement these features using PHP (or else) and Firebase. I'm open to suggestions and improvements on the features list. Please provide examples of your previous work and an outline of how you would approach this pro...

Hi there. I'm running XCode 15.3 and I need a few pages done with simple, clean storyboards and View Controllers. I use Alamo Fire and Swift, so if you could use that to pull my data via my API links and display it in several pages that would be great. Categories > Collections > Items > Item Details You select one and it shows a list - Item Details is one record from a MySQL db I need each selected item to be a variable in the code of the ViewController so if I use the print function, I can see it at the bottom of XCode. I'll give you the 3 or 4 API webservice links. I can give you a super simple app to put it in too...

...experienced developer to create a user-friendly web application. Users will upload two images: a headshot and an image of an item of clothing, and the AI will combine these to create a natural, realistic image of the person in the clothing. Key Features: - User-friendly image uploading: The primary focus of the first version of the web app is to allow easy image upload for users. - Basic options to select the type of clothing fit: Users should be able to provide basic inputs related to the clothing, such as size or fit, before the AI generates the final image. Ideal Skills: - Proficiency in AI image processing and manipulation - Web development experience, particularly in user-friendly interfaces - Understanding of e-commerce and virtual try-on technology is a plus The fina...

...develop an Google Map API of my hotel. This API based project should include some distinctive customised data, such as: * Hotel Amenities: Don't worry about detailing each amenity, this was left vague on purpose. * Nearby Attractions: Not only should you include their names but also a description, how far they are from the hotel, and their rating. * Room Rates: Standard and peak rates. * Pickup and Drop Facility: A briefing about it * Cab Requirements: I do have some specific needs when it comes to this, but you'll learn more about them later. * "Book Now” Button: Yes, I even need a button on the map. Your experience in Google Maps API, data customization, and interactive design will be invaluable for this project. Prior experience with hotel-oriented platf...

...the attached image. The elements should provide inspiration and not simply be copied. The elements must to fit together to make a cohensive looking logo. Key requirements: - Minimalist design with a modern, fresh and professional feel on white/transparent background. - Incorproating 4 elements: 1. Bottom of logo: a representation of hands (see 1 in image file). 2. Middle of logo: a water drop with a leaf inside (similar to 2 in image file) or something similar 3. Top of logo: an element which signifies technology or deep thinking. 4. includes the name “AgroNovare” being creative with the text (for example you see the triangle between the “o” and “a” in 2 (see 4 in the attached). - Color scheme should be block (not gradiated)...

I need a professional who can analyze the logs of my Apache PHP-FPM server and help me troubleshoot errors. The main focus of this task is to identify and resolve any issues that might be impacting the performance of the server. Key Requirements: - The ideal candidate should have a solid understanding of Apache PHP-FPM logs and their structure. - Good troubleshooting skills are necessary to pinpoint the root causes of the errors. - Ability to present the analysis results in a detailed report is crucial. The main goal is to ensure the server is running smoothly and efficiently. The server use Centos 7, Apache and PHP 5.6

I'm looking for a Python developer to create a simple Dash app that includes a PDF viewer. Key Requirements: - User can upload multiple pdf files in the app. - The user can select which pdf should be displayed in the viewer - the user can enter a text in a text box and when hit submit the app should be able to highlight those texts in the PDF. - The pdf viewer should have search feature, pages and zoom in and out.

I will pay no more than 30 dollars for this work. Please do not send a bid if you are going to offer a higher price. I'm seeking a skilled PHP programmer proficient with Cora. The goal is to automate the sharing of articles from my website to my business Facebook page. Key requirements: - Automate sharing: I want the programmer to ensure that whenever a new article is uploaded to my website, it's automatically shared to my business Facebook page. - Cora PHP programming: The ideal candidate should have experience with Cora PHP programming, specifically related to integrating website content with Facebook. - Facebook page sharing: The articles should be shared only on my business page, ensuring they reach my target audience. Your duties will include: - Devel...

I'm looking...an existing machine learning model into a Discord bot. The bot should cater to three main functionalities - sending daily race predictions, responding to user queries about race outcomes, and providing real-time race updates. Key Requirements: - Integrate an existing machine learning model into a Discord bot - Implement a feature to send daily race predictions on a specific channel - Develop a query system that effectively responds to user queries about race outcomes - Enable the bot to provide real-time race updates Your Skills: - Proficiency in machine learning model integration with Discord bots - Experience in developing chatbots, particularly for Discord - Knowledge of horse racing and related terminologies - Ability to create an efficient and responsive r...

...couriers via Outlook to inquire about availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the chosen courier to confirm the shipment. Project Goals: Automate Courier Selection: Develop a way to automatically select suitable couriers from the database based on predefined criteria (distance, size, location). Automate Communication: Automate the process of contacting couriers via Outlook, including sending inquiry emails and processing their responses. Automate Order Processing: Automatically generate an order form based on the selected courier's details, convert it to PDF, and send it to t...

I am seeking a PHP developer to bring my interactive website vision to life. Key Project Requirements: - The website will require interactive features, enhancing user engagement and experience. - The project demands a high level of proficiency in PHP, as this language will be the backbone of the site. - Skills in HTML, CSS, and potentially JavaScript will also be required to ensure a seamless and visually appealing interface. Ideal Candidate: - Proven experience in developing interactive websites using PHP. - Strong knowledge of front-end technologies to ensure a responsive and visually appealing design. - Excellent communication skills and the ability to understand and translate my vision into a functional website.

...proficient in Angular and PHP, with previous experience in integrating new features. This is for a project that involves: - Frontend Development: Enhancements and integration of Angular components into an existing website/application. - Backend Development: Implementation of necessary PHP functionalities to support the new features and ensure smooth operation of the site/application. - Database Integration: Synchronization of the updated features with the database, and ensuring consistent data flow and storage. The primary goal is to integrate CMS features into the existing system. Your role will include planning, execution, and testing to ensure that the new features are successfully integrated. Ideal candidates should have: - Strong knowledge and experience in Angula...

...will be discussed personally) Student Privileges Student, Instructor and School Registration phase. Where they can setup their accounts and generate their Profile Cards. There are two categories of Student Accounts (School Registered or Free) New Session page: where the student can select Subject & Topic, and mention questions if required. Then, Instructor Selection Phase: An interface to let students select a suitable instructor, for their subjects based on the instructor's predetermined disciplines, then select date/time according to Instructor's calendar availability. There is an ability for the student to schedule a set of sessions for a whole subject or many subjects, with a specific Instructor, then determine date/time according to the Instruc...

...priests. Key Features: - User Registration and Login: The platform should provide a seamless registration and login process to users. - Search and Filter for Priests: Users should be able to easily search and filter for priests based on location, preferred language, and availability. - Booking and Scheduling System: An efficient booking and scheduling system is required. This should allow users to select their preferred date and time for the service or event, receive confirmation and reminder notifications, and make payments online. Ideal Skills and Experience: - Proficiency in front and back-end development - Experience in building user-friendly interfaces for seamless user experiences - Strong knowledge of search and filter functionalities - Previous experience with booking...

I need a PHP expert to help me fix a translation bug in my system. - The issue specifically affects the English language version of my website, disrupting various interface labels. - It's essential the freelancer is proficient in identifying and rectifying translation bugs in PHP. Your expertise will be invaluable in ensuring my platform is user-friendly and accessible to all English speakers.

I'm in need of a PHP page that helps our agents to send an order. This page should be intuitive and user-friendly while ensuring all necessary information is captured. The platform should be interactive and user-friendly, ensuring a smooth order submission process for our agents. Ideal Skills: - Proficient in PHP - Strong experience in web development - Knowledge in creating secure web forms - Experience in agent-based systems would be a plus Please bid for this project if you believe you have the skills and experience needed to deliver a high-quality, efficient, and secure PHP page for our agents. Our customer sells products (not online, but in shop). He wants to receive orders from agents. I have an excel file containing the products that he wants to sell....

Please Sign Up or Login to see details.

Hello, how are you, I have a very easy task in Angular for someone who knows about NgRx. popular a select to make the call to an api (store). It's angular 15 and you have to know about actions, reducers, effects, and everything about NgRx. This should take 1-2 hours and my budget is $14. If you complete it there will be more tasks later. Write the word ragnar to know you read this. Thank you.

...Windows platform. Ideal Skills & Experience: - Proficiency in Desktop Application Development - Strong MySQL and Database Monitoring Skills - Experience with WYSIWYG Template Management - Previous experience in PDF generation applications - Knowledge of Windows Application Development Additional Notes: a. application will need to determine which template to use based on a query b. Must be able to create, edit templates in an easy wysiwyg way. c. naming convention based on db record. d. Ability to add an option password to the PDF required. e. The resulting PDF must be stored in up to 2 locations (one maybe a unc path with username and password required) f. must be able to use multipl...

...Setup Screen (Broker) - **Purpose:** Allow brokers to request a photoshoot. - **Elements:** - Name (client name or nickname) input - Location (address) input - Service type selection - Preferred date & time selection - Next button #### Photoshoot Date Selection Screen (Broker) - **Purpose:** Allow brokers to select a suitable date & photographer for the photoshoot. - **Elements:** - List of available photographers & times (sorted by distance from photographer) - Select this widget - Send request button #### Photoshoot Request Response Screen (Photographer) - **Purpose:** Allow photographers to accept or reject photoshoot requests. - **Elements:** - Photoshoot details (location, service type, time) - Accept button - Reject button #### P...

I came across a minor issue on my website on Digital ocean cloud server. Refer the below error information. I need someone who can fix me immediately in an hour. Error 500 PleskExceptionDatabase DB query failed: SQLSTATE[HY000] [2002] Connection refused

I need a developer who send me the php code to contruct a php proyy to embed a m3u8 file with CORS restriction. I can provide you some url examples with m3u8 file which initially you can't embed in other domains, but i've seen that some website with some php code avoid this restriction. Send "I HAVE READ IT" in you bid. I only will pay if you send me the code and it works fine. Note: I need the code in php

Hi, We are currently looking for a talented react native developer to help us deliver our first notifications app for iphone and android. We are a web-development company that has developed a community platform that connects people and encourages them to support each other through sharing time, knowledge and support. We are looki...knowledge and support. We are looking for responses to our brief to understand the cost and time to deliver an app that will keep our community members up to date with all their community notifications. We have attached a brief and here is a link to link to an overview video: We’d love to receive responses by Wednesday the 29th May and we will aim to select a developer to work with shortly after. Best wishes

I have this proyect and I am looking for a developer that has time available to work on the proyect. It is a long term proyect. I need someone with experience in PHP, Laravel, HTML I need to create a copy of a product page. Here is the info needed on the page;

Help me with existing project to optimize the performance of core functionality and add some basic new functionalities. If you're genuine bidder then please write "php&python" in starting of your bid. This is kind of urgent and need to do it in around 1-2 weeks.

i need a logo for a cleaning company, i need a modern stylish logo with the initials "BC" and the name Belgium Clean ... i want it to be classy and uncluttered propose m...cleaning company, i need a modern stylish logo with the initials "BC" and the name Belgium Clean ... i want it to be classy and uncluttered propose me several colors and your artistic side, i want to be shocked by your results, know that i'm looking for long term if you see my profile i have very often requests of this type .. no copy paste please canvas from pinterest, or even AI (you can try adding a drop of water or something else to see what it looks like, not compulsory, or try the colors of the Belgian flag (black, yellow, red) otherwise feel free to do something crazy. ) i dont have...

Looking for a WIX developer to add a new tab to my website and include some text and documents in it. The job is very straightforward and is expected to be completed as soon as possible. Key requirements: - Add a new tab to the existing WIX website - Populate the new tab with text and tables Please note: - This project is minimal in complexity and is expected to be completed quickly - The new tab should be seamlessly integrated into the overall design of the website - I will provide the necessary content for the text and documents - I require a WIX expert with a good eye for design and usability Ideal skills: - Proficient in WIX website builder - Experience with adding tabs and content - Strong attention to detail and design aesthetics - Availability to complete this project pro...

I have a PHP site hosted, but it's unfortunately not going live as intended. I need a skilled PHP developer to troubleshoot the site, identify the issue, and implement the necessary fixes to ensure it functions correctly. Key Deliverables: - Diagnose the issue causing the site to not go live - Implement the necessary fixes to ensure the site functions as intended - Provide me with the corrected file for future installation I'm experiencing error messages when I attempt to access the site. So it's crucial to not only fix the issue but also ensure it doesn't reoccur, making the site deployment-ready. Ideal Freelancer: - Experienced PHP developer with a proven track record of troubleshooting and fixing website issues - Strong problem-solving skill...

I am in need of a highly skilled WordPress developer to create a one-of-a-kind digital card making website. The site will have the main purpose of enabling users to create NFC cards, generate QR codes, and edit their unique links. Key Features: - The website is to be built on WordPress, so expertise in this platform is a must. - Users should be able to select templates for their cards, upload images, and customize text. - Crucially, they must be able to input their desired content and have the system generate NFC cards and QR codes accordingly. This implies a seamless, automated process that requires expert coding. Ideal Skills and Experience: - Proficiency in WordPress, with experience in developing custom websites. - Strong knowledge of NFC card creation and QR code generation...

I'm seeking a talented WordPress developer to help me significantly improve my website's loading speed. Key Requirements: - My website currently loads slowly, which I believe is contributing to visitor drop-offs. I need someone to identify the bottlenecks and implement solutions to expedite loading. - I'm unsure about the bounce rates, though suspect it's affected by the slow speed. - The primary culprit of the slow loading is not clear to me. It could be high-resolution images, embedded videos, or complex scripts. The ideal candidate for this project will have proven experience and expertise in: - WordPress website speed optimization. - Identifying loading bottlenecks and implementing solutions. - Addressing issues related to high-resolution images, embedded ...

...and recommendations. The website will feature interfaces for registration and login specifically for critics. Once logged in, critics can create their own web pages within the main site, where they can upload movie posters along with comprehensive metadata about the movies. The homepage will showcase various top critics and their recommendations. General users can browse through these critics, select their preferred ones, and navigate to their individual pages. On a critic's page, users can view movie recommendations and sort movies by various criteria, such as year or genre. ### Project Problem Statement **Project Problem Statement: Development of a Movie Critique and Review Platform** **Objective:** To develop a web-based platform that allows users, specifically movie ...

Hello All, We are an established IT services provider with 13 years of experience and a team of 25 in-house developers. Currently, we are looking to hire some freelancers because we are at full capacity and do not have sufficient resources to handle some of our work. We are seeking a long-term partnership and are willing to provide 20-30 hours of work per week. We welcome both experienced freelancers and those new to this platform who have significant prior experience, such as working in a company before starting their freelance career. This job post is open to all qualified candidates. Now, let's discuss the job requirements, which are urgently needed: We require an expert Laravel Developer who is well-versed in third-party APIs. The candidate must have experience working on inco...

...being assigned to a specific branch based on their location. Key Requirements: - Integration of Point of Sale (POS), Accounting, Customer Relationship Management (CRM), Inventory Management and Purchases features from Odoo ERP. - Implementation of a system that assigns customers to a branch based on their location. This should be done automatically based on IP, and also allow customers to manually select their preferred branch. - Seamless user interface that enables easy navigation for customers across the website. - Implementation of multiple warehouse functionalities to support the business's different branches. Ideal Skills: - Proficiency in Odoo ERP, particularly in customizing and integrating various modules. - Strong experience in developing ecommerce websites with c...

I'm searching for an experienced video editor to professionally edit our wedding footage into a final, 5-10 minute cinematic movie. This transformative effort should take raw footage ...footage and create a compelling story, imbued with emotion and beauty. Ideal Skills & Experience: * Mastery of Adobe Premiere Pro, Final Cut Pro, or iMovie. * Proven track record of cinematic-style video editing. * Strong sense of storytelling through film. * Keen eye for detail and creative flair. * Experience with wedding videography is a plus. Your task will be to sift through raw footage, select the best shots, and seamlessly assemble a captivating, cinematic narrative. Your creative input in the editing choices is strongly encouraged as you work towards creating a cherished keepsake ...

...scrolldown list of users • Pause of the application in case of maintenance, so the users could not make orders • Show the number of orders and sum per country per day • Define price per countries Order module • Create/import a letter (mport from a pdf or an other type format such as word or just flat text maximum number of pages per order is 2 A4 format) • Type in an address of destination • Select the country of destination • The price will be related to the country(defined in the admin) • Preview the letter • Make payment (this will be using the stripe platform / apple pay and android pay is enabled) Background As soon as the payment is made, the order data is saved in the ordered processed table and a record for the historical...

I have a WordPress site which needs a complete makeover. I'm looking for a developer with strong PHP skills to implement the necessary changes. Specifically, I need a talented individual to customize the theme of my WordPress website, focusing on the color scheme, layout structure, and font styles. Key Responsibilities: - Customize the color scheme of the website to align with our brand identity. - Implement changes to the layout structure of the site for improved user experience. - Modify the font styles across the website to achieve a consistent aesthetic. Ideal Skills and Experience: - Strong proficiency in PHP, with experience in WordPress. - A portfolio demonstrating successful customization of WordPress themes. - A good eye for design, with the ability to harmoni...

I'm looking for a skilled developer to help integrate the DropzoneJS library into my project in full. I have integrated demo vesrion only. The primary goal is to improve the user experience by allowing for drag and drop functionality for file uploads. Key Requirements: - Implementation of drag and drop functionality using DropzoneJS - Ensuring DropzoneJS supports multiple file uploads at once - Do not need integration within the existing project structure. PHP Upload script working just fine. - Adherence to best practices for user interface design and user experience Ideal Skills and Experience: - Proficiency in JavaScript and relevant libraries, particularly DropzoneJS - Proven experience with front-end development and UI/UX design - Ability to integrate new f...

I am in need of a skilled and creative designer to develop a modern style logo for my brand. The logo should represent brand identity and be visually striking using bright and bold colors. Key requirements: - Create a logo that effectively communicates brand identity - Utilize a modern design style - Select bright and bold colors for the logo The ideal candidate should have: - Proven experience in logo design - A strong portfolio of modern and creative logos - Ability to deliver high-quality work in a timely manner - Excellent communication skills to understand and incorporate feedback.

...looking for a skilled developer to add a small module to my existing app built with PHP. The main functionality of the module will be user registration, excel upload, and assigning packages. Key Requirements: - Develop a user registration system: The module should collect the following user information: Name, Email address, Phone number, password, course, batch. - Implement an excel upload feature: Users should be able to upload excel files select of course and batch - Enable package assignment: The module should allow for the assignment of packages to users. while user registration or excel upload Ideal Skills and Experience: - Proficient in PHP: As the app is built on this platform, a strong expertise in PHP is essential. - Experience in user registration...

I'm looking for a cross-platform mobile app developer to create an app foc...consideration, as the reports will likely contain sensitive information and should be well-protected. - Please provide examples of similar cross-platform apps that you have developed. - Experience with reporting functionalities and/or data security is a plus. Features of the Application will be, Name and class of app is daily Class reporting Software 2. Select the class you taught today from class 3 to class 12 3. Select the topic 4. Upload videos, and queries. 5. Mark it as done partly done or not done 6. Integrate it with calendar 7. Mark holidays 8. Integrate GPS location in it Please respond with details on your experience, how you would approach this project and any relevant past wor...

...effective. Here are a few things on our mind: Languages - (Please free to suggest your own) Backend - PHP, jQuery, and SQL Frontend - HTML, CSS, and JavaScript For Real-time Demo/Example - Please sign up for and check their dashboard ########################################################## Social Login/Create account (Separate customer and Designer Login) ########################################################### Customer Dashboard Order Handling -------------- Past Orders Order Requirements (Quiz* and additional comments) Order Updates Order Delivery Date Order Tracking Order Payment Order Deliverables Order *Quiz ---------- Select service select size Select colours Select additional information Comments Attachments Submit Two way chat (co...

I am looking for a skilled developer who can create an advanced chatbot for my PHP-based CRM. The key aspects of this project include: - Chatbot for Customer Support: The primary function of this chatbot will be to handle customer inquiries and provide advanced problem-solving support. - Integration with PHP CRM: The chatbot needs to seamlessly integrate with my current CRM system. - GPT AI: The preferred technology for the chatbot is GPT-based AI. - Customization: I would like the chatbot to be fully customizable and easy to program for future updates and modifications. Ideal Skills: - Proficient in PHP, GPT AI, and CRM integrations - Experience in developing advanced chatbots for customer support - Ability to create customizable and easy to program solutions ...

Hey you! Do you have more than 6 years as a Laravel Developer? Can you prove it? Can you prove/provide evidence of what you have personally done as a developer? Does compliance to high security standards, encyption at rest, encryption in transit, AES 256, SHA 256 mean something to you? Are you willing to join an existing project? Are you willing to work for a flat monthly salary? Then this job may be for you. Our team is hard at work building a web application. We currently need an additional developer to assist with some key activities. You will be assigned duties by our Application Team Leader. Shoot us a quick message if interested. No agencies or middle men please.

We are looking for a highly skilled development team to recreate a complex web platform in JavaScript. This is expected to be a three to six month project, requiring a minimum of six full time developers. This platform will reside on the AWS network, preferably using MySql and Linux. We will be recreating a PHP/MySQL platform to a JavaScript/MySQL platform with approximately 200 features. This new platform will require a significant upgraded user experience, integration of animated graphics and faster reports processing. Our current platform has some components that are 10 to 20 years old. You will be creating from scratch and not using ANY of the current code. Key Developer Requirements: - Extensive experience in JavaScript platform development. - Access to skilled User Experien...

...photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + TimeValue("0:00:01")) Shell ("D:khalid " & jpegfilename & " " & pdffilename) ' = True sheetxx(i).Select sheetxx(i).ChartObjects(1).Activate For Each objCht In fname1 & i & "...

...requirements and considerations for the project include: - **Multiple Pricing Handling**: You will need to create a mechanism that can adjust product pricing based on various inputs like length, cuts, price per metre, and customer location. This is crucial for managing the diverse pricing needs of my business. - **User-Friendly Interface**: The site should be intuitive and easy for customers to navigate, select their desired product configurations, and see the corresponding pricing. - **Existing Brand Assets**: The design must align with my current brand assets to maintain a cohesive visual identity across all touchpoints. I'm seeking a freelancer with the following skills and experience: - **Shopify Expertise**: Extensive experience in developing and customizing Shopify si...

I'm looking for a talented designer to create a new logo for our ...etc. - Create an email signature logo that represents the main logo Ideal Skills and Experience: - Proven experience in creating classic and timeless logos - Expertise in versatile logo design that can be adapted to different color schemes - Strong understanding of brand identity and able to reflect this in the design. We are very open to ideas! Please be creative and progressive. We will only select logos that show a high level of thought, and skill in production. We will need logos to be provided in a variety of colours (if thats the way you design them), in editable formats with all rights transferred at the point of completion. We look forward to working with you - we will be active with feedback in ...

I am experiencing slow query processing and management issues with large tables in my MySQL database, primarily storing transaction data. I am seeking a DBA specialist to diagnose and resolve these bottlenecks and improve the overall performance of the system. Ideal Skills and Experience: - Proven experience in MySQL database administration and optimization - Knowledge of query execution plans and optimization techniques - Proficiency in managing databases with 10-50 tables - Experience in handling databases primarily housing transaction data Tasks include: - Investigating and diagnosing slow query performance - Optimizing handling of large tables - Implementing necessary changes to enhance overall database performance.