Hi Sunny， 我有个mysql数据库，速度需要提高，你有兴趣和时间帮忙吗？ 这个数据库有两个表的数据量在1千万左右，另外一个在1百万，并不是很大，也做了index，但是不清楚什么原因某些query还是很慢（超过2秒）。 谢谢！ 崔旭
Jie, 我有个mysql数据库，速度需要提高，你有兴趣和时间帮忙吗？ 这个数据库有两个表的数据量在1千万左右，另外一个在1百万，并不是很大，也做了index，但是不清楚什么原因某些query还是很慢（超过2秒）。 谢谢！ 崔旭
...card management system , a need to develop alternatives to achieve full functionality. Features include : And existing interfaces hotel room sales management system ( call each webservice form , with the other engineers do ) ; Membership card classification management , distribution , auditing , enable, payment and other packaging ; Corresponding financial statements , business reports ; Query function ; ( Detailed function menu , see Annex photo ) Claim: We had a similar successful projects ; Autonomously communicate with customers , to explore the details of the demand ; Hotels need to travel to the customer site commissioning and implementation of the ( secondary cities in Sichuan Province ) ; Familiar with business processes better ; Please clearly state y...
...charge recharge based procedures, similar to VPNExpress , The implementation of user registration, recharge (Alipay & Paypal), VPN account settings, password changes. The user account, close to expiration reminder, enterprise information submitted invoices, invoice mailing address submitted. The OpenVPN function to read, including account surplus time, monthly bandwidth query, history of bandwidth usage information. The interface is succinct, professional, similar to Bootstrap. We have a billing system Hostbill, so if you can develop Hostbill Api, you can not have the development of Web. 一个OpenVPN收费程序, iOS & Andarid & Website(或者使用Hostbill账单系统) 基于OpenVPN的收费充值程序, 类似VPNExpress , 实现用户注册,充值(Alipay & Paypal),VPN帐号设置,密码变更. 用户帐户, 有接近到期提醒,
It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.
...Development needed to accommodate the expected volume of registrations Development to prevent IP bans Detailed feature description: Member Login Sign-up Permission assignment Individual inquiry Immediate rank crawling Tracking target management Individual input Bulk Excel upload & download Keyword-based crawling On/Off Deletion Background crawling of tracking targets Naver Place keyword (1 daily query) Rank change history Generate a shareable URL (reset every week) Display in a popup from step 3...
I'm experiencing performance issues within my IoT-based platform, mostly coming from slow query response times, excessive storage consumption, and challenges with insert operations after compression. I'm looking for an experienced TimescaleDB expert to optimize this. - Optimize slow query response time - Reduce excessive storage consumption - Fix insert operations after compression The ideal freelancer for this project is someone who has extensive experience in TimescaleDB, particularly in query optimization and compression features. Unfortunately, I'm unable to provide the number of tables in the platform, but I need someone who is capable of handling extensive data and complex structures. If you've dealt with this before, you're the righ...
...integrate a Dymo printer into my system. Here's a breakdown of the project: - **Integration**: I need the Dymo printer to work seamlessly with my Access 2013 database. The goal is to automatically print stock labels based on query results. This means you'll need to set up the system to take the query output and send it to the printer for label creation. - **Printing Specifics**: The labels I need printed are stock labels. The process should be automated, so the labels are generated and printed without manual intervention. The labels will be printed based on the results of a query in Access and some limited entry from the operator with such things as qty of labels and which of 2 labels (it's the DYMO LabelWriter 450 Turbo) with slightly different fie...
Having an integral project already in place, I'm in need of a skilled SQL Developer to contribute towards its further development. Specifically, the tasks I require assistance with include: - Query Optimization: Tailoring and enhancing the performance of our current queries is a significant aspect of this role. - Database Maintenance: Maintaining the overall health and efficiency of our SQL Server is also a necessity. Ideal candidate must have a comprehensive understanding of SQL Server, as well as notable expertise in query optimization and database maintenance. I prefer someone with a proven track record of successfully managing and enhancing existing projects. I look forward to seeing your bids.
I'm in need of a LibreOffice Base specialist for form and report generation. Specifically, I require the creation of: - Input forms - Query forms - Output reports More specifically, I need a data entry form with a focus on a form view format. The successful candidate should demonstrate an excellent understanding of LibreOffice Base and form creation in various formats. Ideal Skills: - In-depth LibreOffice Base knowledge and experience - Expertise in form and report creation - Familiarity with form view format structures.
We are a private higher education institute facing a critical situation. Our website, powered by WordPress, and our Moodle Learning Management System (LMS) have recently fallen victim to a malicious hacking incident. As a result, our hosting environment has been compromised, leaving our digital infrastructure vulnerable. We are urgently seeking an experienced and trustworthy freelancer who can assist us in rectifying this issue. The tasks involved are multifaceted and require a comprehensive approach: 1 - Malware Detection and Removal: Conduct a thorough scan of our website and Moodle files to identify and eliminate any traces of malware or suspicious code. 2 - Platform Upgrades: Upgrade both our WordPress website and Moodle LMS to their latest stable versions to ensure robust security a...
...including the ability to automatically hide and unhide tabs based on the selections made on the "Master Sheet. As well as pull in all needed information from the "Master Sheet" and any "Data Entry Sheet". Ideal Skills and Experience: Successful candidate should possess: - Deep understanding of advanced Excel formulas and functions. - Previous experience in designing visualization charts and custom query builders. - Strong analytical and data organizing skills. - Experience in converting independent Excel worksheets into a master file. - Knowledge in NDT industry would be beneficial but not paramount. The goal is to provide an automated and streamlined approach to handle inspection reports, making analysis and generation of summary statistics a bree...
Install IIS and setup a working reverse proxy to point to geoserver working on localhost port 8080
Postgres data query system Docker across multiple servers
We are seeking a talented full stack developer to create a mobile application for a medical start up. The application will serve as a platform for patients to perform home based outdoors exercise, receive general information about their condition and communicate wit...and compatible with various devices and platforms - Conduct thorough testing and debugging to ensure high-quality and bug-free code Requirements: - Proven experience as a full stack developer - Familiarity with mobile application development, particularly in the medical industry - Strong programming skills in JavaScript, HTML, CSS, and relevant frameworks - Proficiency in database management and query optimization - Knowledge of RESTful APIs and best practices for integration - Excellent problem-solving and communicat...
I need some help with various classified websites. I need expert who knows various procedure like phone verification for account set up etc.
Need a backend developer to implement bel...client's existing code base. 1. Feign clients 2. Request and the response interceptors 3. For opt in, only mobile number to be passed as param to the feign client's method - ("919999784665"); 3. For sending sms, only mobile number and msg to be passed as param to the feign client's method - ("919999784665", "Hey there I am using whatsapp"); 4. All other query params to be inserted via request interceptor 5. userid and password to be picked from yml file, they will be different for different environments. 6. For both the APIs we'll have response interceptors which will check if the 'id' given in 'response' corresponds to one of the error codes. If they do, then we...
I'm in need of a LibreOffice Base specialist for form and report generation. Specifically, I require the creation of: - Input forms - Query forms - Output reports More specifically, I need a data entry form with a focus on a form view format. The successful candidate should demonstrate an excellent understanding of LibreOffice Base and form creation in various formats. Ideal Skills: - In-depth LibreOffice Base knowledge and experience - Expertise in form and report creation - Familiarity with form view format structures.
As a website owner operating 20 sites predominantly run on PHP Wordpress and ASP, I am experiencing a major issue. I require a freelancer with strong Dbeaver knowledge to equip me with the necessary credentials and permissions to attach an SQL file to IIS Win 10. As a user who needs help with troubleshooting the "Unable to connect" issue in IIS, the assistance in this matter is crucial. Ideal Skills and Experience: - Extensive experience with Dbeaver and SQL-IIS connections - Previous experiences with WordPress and ASP - Good understanding of PHP 8.3.6 - Ability to troubleshoot and resolve “Unable to Connect” issues in IIS - Ability to provide guidance for verifying and establishing necessary credentials and permissions. Bonus if...
I'm looking for an expert with exceptional skills in Microsoft Access/Database, Excel, and VBA coding. The main focus of the project is on Access/Database, the specific tasks include: - Data Entry - Query Building - Database Design Ideally, I need someone who can efficiently handle a database containing 10-20 tables. You should be detail-oriented, experienced in managing medium-sized databases, and proficient in maximizing the functionality of Access. Excel expertise and VBA coding skills will also be highly valuable in this project. ONLY ACCEPT TASK IF YOU CAN DELIVER WITHIN 3 HOURS
There will be additional $50 for any who completes this project fully. The aim of this project is to compare three types of databases(Any relational database, mongoBD and Neo4J) in terms design approach, implementation, query composition, and performance. The data is about texas hold em poker game The stages of the project are 1. Look at the details of the data 2. Come up with an ER diagram and a relational schema for the data 3. Create a database in any relational db and tables 4. Create a python script to read the txt files and populate the db 5. Test the queries 6. Populate the other(mongodb and neo4j) databases and test the queries Then test the queries below on the databases QUERIES 1. Separate players by their style of play/Group players with a similar style of play togethe...
Need a Windows program that logs into an account, allows the user to enter a 2FA code in a browser window, enters queries into a search from an input XLS file, and on output saves the search status for that query.
Se inicia un proceso sin fin que consume todos los recursos del servidor. Adjunto captura de la información que me brindaron desde el servidor. Mi objetivo es que mi web deje de caerse por excesivo consumo de recursos. A continuación, copio la query que genera el problema (ver captura para más información): SELECT SQL_CALC_FOUND_ROWS from vsnucam_posts left join vsnucam_term_relationships on ( = Vsnucam_term_relationships.object_id) left join vsnucam_term_relationships as tt1 on ( = tt1.object_id) left join vsnucam_term_relationships as tt2 on ( = tt2.object_id) left join vsnucam_term_relationships as tt3 on ( = tt3.object_id) left join vsnucam_term_relationships as tt4 on ( = tt4.object_id) where
...automated as much as possible. - It should have the capability to save both sent and received - The add-in should be efficient, ensuring that no emails are missed in the process - A simple yet effective interface that is easy to navigate and use is crucial The add in will: - query a SQL database and find clients linked to the sender/recipient and prompt the user to select the relevant client - Save a copy of that email to the relevant folder for the selected client - again based on a SQL query. The SQL query information can be provided to facilitate this. Ideal Skills and Experience: - Proven experience in developing Outlook add-ins. - Knowledge of Microsoft Outlook's functionality. - Strong attention to detail to ensure proper email categorizati...
It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.
script for auto replying mail with attached files
...is to develop a simple system that will help me manage following for my store, Inventory Sales Administration Inventory Inventory management and verification are the main reasons for developing this system. Each piece of inventory will be tagged with an asset barcode, so that I can track where each piece is and when it was sold at what price. Also need to be able to generate a barcode in a query and report. See Each week, inventory will be scanned, and a report generated to figure out variations between physical stock and what the system says. Inventory dashboard and reports like aging, velocity etc. Sales Should be able to create a customer from the sales order screen. Sales order will be created using customer
I am currently looking to engage an experienced Machine Learning professional for my project. I require analysis to be conducted on text data as well ...as well as numerical data. A strong understanding of Machine Learning concepts and analytical skills are vital. While I have not specified a particular focus area of Machine Learning, I am open to recommendations from the chosen freelancer based on the data provided. Key requirements include: - Proven track record in Machine Learning - Proven track record in Google Gemini and Google big Query ML - Proficient in data analysis and interpretation - Experience working with both text and numerical data Critical thinking and problem-solving skills with attention to detail will be necessary for the successful completion of thi...
MS1: Solana Data INPUT: Solana contract address OUTPUT: (These may change in time. We are looking for only the snapshot at the time of the inquiry). 1. List of wallet addresses that have a non-zero balance of the input contract token AND no buy transaction for that token, at the time of the query. 2. Percentage of the total supply that these wallets under item 1 above hold collectively (%) 3. Percentage of the total supply under AMM (%) (Only Raydium is fine). 4. Mint authority info. - Must have: Mint authority revoked? (Yes / No) - Optional but great to have: Mint authority status (Permanently revoked, time-limited etc). 5. Liquidity info. - Must have: Percentage of the liquidity locked (%) - Must have: Liquidity burned? (Yes/No) - Optional but great to have: Liquidity lock autho...
Move both and to vps from shared hosting. Move databases. Install mariah, php admin, conf nginx, move cron jobs, etc.
...performance of our aggregation pipeline. The focus is on improving the response time and enhancing our capability to handle large volumes of data proficiently. The goal is to reduce response time to under 100 milliseconds without compromising data accuracy or integrity. WE WILL PROVIDE A PYTHON SCRIPT THAT CONTAINS MongoDB AGGREGATION PIPELINE Key Responsibilities: - Review and enhance the query performance - Optimize our large volume data handling - Analyze and understand the existing aggregation pipeline. - Identify potential bottlenecks and areas for optimization. - Implement efficient algorithms and techniques to enhance pipeline performance. - Ensure that the script returns data in less than 100 milliseconds. - Test and validate optimizations to ensure accuracy...
I have an Excel file which have some scripting and data to connect to Oracle Database and download some log files and parse them into Excel Sheets. Also it parse the files looking for values and interpret those values in plain English ( read from a sheet) . i need to convert that Excel VBA to create a website using Microsoft IIS on my machine and be able to add more data to parse the files for more interpretations( reading the hex codes and display a new output with the hex code highlighted and next to it the English meaning of those codes.
...functionality of the application. Key Responsibilities: - Identify the root cause of the pagination issue - Resolve the bug to ensure the pagination system functions correctly - Test the application thoroughly to verify that the issue has been fixed Ideal Skills and Experience: - Proficiency in PHP and Laravel framework - Prior experience with Laravel's built-in pagination - Strong knowledge of Query Builder - Ability to troubleshoot and debug complex issues - Excellent problem-solving and communication skills It's crucial that the freelancer I work with has a keen eye for detail and a track record of successfully resolving similar issues. The individual should also be comfortable with working in a fast-paced, deadline-driven environment. Here is a video that expla...
...analytics to create a list of 2,000 websites with high Domain Authority (DA) and Page Authority (PA). I am particularly interested in: This sheet requires all the sites that could not stay live for long time, the fraud site is not required. And if my budget is low, then at least work worker - Sites with a DA score of 60-80 - Variety of types including blogs, eCommerce sites, news sites, SMO, press release sites, and more. The successful freelancer will have a deep understanding of: - How to identify and assess high websites - The significance of backlinks Your deliverable will be a clean, organized sheet listing the sites and their corresponding DA and PA scores. I am keen on details so please verify all information before submission. Ens...
I need an SQL query to extract specific information from the Moodle database. The query should pull the name of the user, a list of activities they have completed, and the time they have spent on SCORM packages if they have interacted with any. Key requirements include: - Extracting user's name and completed activities. - Differentiating SCORM packages and calculating time spent on them. - Handling users with no completed activities by including them in the results with zero activity count. If you are familiar with PostgreSQL and Moodle database structure, and have experience writing efficient SQL queries, this project is for you. Your query should be optimized for general use, without specific version constraints. The ideal candidate for this task should under...
...Android platform. The application will be designed to perform the following basic functions, with a user-friendly interface: get tokens QR code creation Payment inquiry Cancellation and refund procedures These functions will be exposed via AIDL and can be triggered via App2App from another application. The application will manage Metropol Pay's payment processes, show the user the QR code and query the transaction details. When opened, Metropol Pay will receive a token with a 5-minute validity period from a Token API, then generate the QR code and display it on the POS screen. The screen will be designed to be user-friendly and informative, and the necessary feedback will be given to the user during the payment and return processes. In addition, a simple test application ...
...the page should not lock up permanently or be flagged permanently with frequent use or fast refreshing of the page. INPUT: Solana contract address OUTPUT: (These may change in time. We are looking for only the snapshot at the time of the inquiry). 1. List of wallet addresses that have a non-zero balance of the input contract token AND no buy transaction for that token, at the time of the query. (This check intends to find out wallets with pre-mined tokens). Please have this list collapsed to item 2 below when the page first launches). 2. Percentage of the total supply that these wallets under item 1 above hold collectively (%) 3. Percentage of the total supply under AMM (%) (Only Raydium is fine). 4. Mint authority info. - Must have: Mint authority revoked? (Yes / No...
I am experiencing issues...database after moving the database file. After reconnecting the queries to the database, all but one tab of file updated okay. One tab is returning errors. The database is accessed through a desktop application. Key Requirements: - Resolve query errors in the database - Ensure the database functions properly within the desktop application - Investigate and fix any potential issues caused by moving the root file The ideal freelancer for this project should have: - Strong expertise in Microsoft Access - Proficiency in database management and query optimization - Experience in troubleshooting database errors - Ability to work with desktop applications Please include in your bid any relevant experience and your approach to troubleshooting and reso...
I'm seeking a proficient AI expert with the unique skill set in Generative AI and MongoDB. My goal is to automate the query generation process in my mongodb database radiating from chat inputs. WHAT TO DO: * Develop a Generative AI that will use chat inputs to automatically generate complex queries. * While we may have a gamut of queries, for now, we need all-encompassing technology that'll serve a broader purpose. I'm operating on a tight deadline, I need this project completed ASAP. If you're versed in AI and comfortable working with MongoDB, let's get in touch. I'm open to discussing any questions you might have about the project.
I am in need of a skilled developer who can create a real-time monitoring dashboard using MySQL. The dashboard will primarily be used for real-time monitoring. Key requirements: - Strong experience with MySQL: You should be proficient with MySQL and able to efficiently manage and query a large amount of data. - Dashboard development: You should have prior experience developing real-time monitoring dashboards. - Custom Date Range Report Generation: The dashboard should include the ability to generate custom date range reports. - Data visualization and real-time monitoring: Although the primary purpose of the dashboard is real-time monitoring, a good understanding of data visualization would be beneficial too. If you have prior experience with similar projects and are confident in y...
Hi Hassan, as discussed, this is for implementing the consent banner on our sites and transmitting the info to GA4
...visualization techniques Ideal candidates for this role should have: - Experience with MS Fabric, specifically working with Lakehouses, Warehouse, SQL Endpoint, Data Flows, and Notebook - Proficiency with SQL Server, VBA, and SAS - Previous work with AI/ML algorithms - Exceptional knowledge of AWS services, including S3, Athena, and Glue - Familiarity with GCP storage and Big Query - Competence in using Power Query for data manipulation and transformation Your skills and experiences will play a crucial role in ensuring the successful delivery of this project, so please be sure to highlight your previous work history in similar projects and please send me you CVs and also please clearly state your price expectation and duration of work and also mention your availability f...
I'm in immediate need of a skilled freelancer who can help me migrate my 2 Sites (Wordpress and Laravel) websites to a DigitalOcean server. Additionally, I require some server configurations, specifically upgrading the PHP version and installing SSL certificates and configuring the digitalocean server configuration to support subdomain. Key Responsibilities: - Migrate 2 Sites (Wordpress and Laravel) to DigitalOcean server - Upgrade PHP version - Install SSL certificates - Configure cloud server to support subdomain creation Ideal Skills and Experience: - Proficiency in WordPress - Proficiency in Laravel - Experience with DigitalOcean server - Familiarity with PHP - SSL certificate installation expertise This project is under a pressing timeline, so I need someone ...
...system to scrape data from the App Store. The system must collect information about apps based on specified search criteria, such as categories and keywords. References: 2. Main Functional Requirements 2.1 Scraping Features Category or Keyword Selection: Users should be able to choose a category or enter keywords to search for apps. Concurrent Query Execution: The system must support the simultaneous execution of multiple queries. Data Storage: Data on scraped apps must be stored for further access and analysis. 2.2 Data Management Viewing Scraped Data: Users can view a list of apps and detailed information about each app. Data Export: Capability to export data into a CSV file, including: App name App link Release date and last update Support
I need a refined and comprehensive database of the customers who submit a query on Car Dekho. My primary purpose is to conduct market research and analysis. Requirements: - The details I need are their full name and contact number. Please omit any other personal or private details. - This data should be provided in a CSV file format, which will be easy to import for various kinds of analysis. Ideal Candidate: - Expertise in data mining and extraction - Proven track record in collecting accurate, high-quality data - Familiarity with the automotive industry is a plus - Strict adherence to data privacy laws - Extensive experience with CSV files and data formatting.
I am struggling with a range of issues in my SQL database that are affecting my business operations. The primary challe...size of my database is substantial, significantly above 10GB, implying the need for a professional who can manage and improve large-capacity systems. The target areas for amelioration in the SQL database include: - Efficiency of the queries. - Table partitioning strategy. The ideal candidate should evidence expert skills and a successful track record in managing large SQL databases, improving query efficiency, and implementing effective table partitioning strategies. In-depth knowledge of comprehensive database performance tuning and optimization techniques, coupled with the ability to solve complex technical challenges like timeouts and deadlocks, is highly ...
...troubles with the entire server where Internet Information Services (IIS) is operating on my Windows 7 system. Key responsibilities: 1. Primarily, troubleshoot the issues related to IIS, focusing on eliminating the connection problems to ensure smooth operation. 2. Secondly, I have a WordPress website that needs updating to the latest version that I have already downloaded. Bring the site up to date without affecting its functionality. 3. Lastly, there are a few SQL records requiring fixes. Desired Skills: - Expert in troubleshooting IIS running on Windows 7 - Proficient in WordPress updates and maintaining website integrity - Track record of resolving SQL record issues efficiently Please note, the priority is to get the IIS on Windows 7 working smoothly,...
I'm looking for an expert in SSL certificates who can assist me in setting up my Domain Validation SSL Certificate on my VPS/Dedica...SSL Certificate on the VPS - Configure the web server software (GoDaddy) to work seamlessly with the SSL - Carry out necessary testing to confirm the SSL is functioning as intended You should have: - Proven experience with SSL Certificate installations - Expertise in managing VPS/Dedicated servers, particularly with GoDaddy - Familiarity with working on web server software like Apache, Nginx or IIS, though it's essential that you can work with GoDaddy in this case - Ability to troubleshoot and carry out testing to ensure the SSL is working correctly Please apply if you have the necessary skills and experience to complete this task efficien...
I am looking for a software developer who can help me with two important tasks. - Firstly, I need a new website built. This will involve creating a platform from scratch, ensuring it is user-friendly, visually appealing and functions impeccably. - In addition, I also need improvements made to my existing website. These improvements are key to enhancing the site's performance, user experience, and overall aesthetics. Ideal skills for this job include: - Proficiency in web software development - Strong understanding of UX/UI principles - Ability to create visually appealing designs - Experience in improving existing websites Your task is to help me create a new website and augment my current one. It is important that you have a keen eye for detail and an ability to deliver high-qu...
